Results 1 to 1 of 1

Thread: Trim

  1. #1
    Join Date
    Feb 2004
    Posts
    5

    Unhappy Unanswered: Trim

    HI
    I am trying to split GASABN0 to GASABN and 0
    Any value that doesnt have a number I wish to also have a value added

    AAA to AA and 0
    You can see from the data sample that

    OA Abnormality AAA ASSOCIATED ABNORMALITIES NO
    OA Abnormality AAA ASSOCIATED ABNORMALITIES NOT RECORDED
    OA Abnormality AAG GASTROINTESTINAL ABNORMALITIES YES
    OA Abnormality AAG GASTROINTESTINAL ABNORMALITIES NO
    OA Abnormality AAG GASTROINTESTINAL ABNORMALITIES NOT RECORDED
    OA Abnormality GASABN0 GASTROINTESTINAL ABNORMALITIES DUODENAL ATRESIA
    OA Abnormality GASABN1 GASTROINTESTINAL ABNORMALITIES DUDENAL STENOSIS
    OA Abnormality GASABN2 GASTROINTESTINAL ABNORMALITIES PYLORIC STENOSIS
    OA Abnormality GASABN3 GASTROINTESTINAL ABNORMALITIES GASTROESOPHAGEAL REFLUX
    OA Abnormality GASABN4 GASTROINTESTINAL ABNORMALITIES TRACHEO-BRONCIAL REMNANT
    OA Abnormality GASABN5 GASTROINTESTINAL ABNORMALITIES MALROTATION
    OA Abnormality GASABN6 GASTROINTESTINAL ABNORMALITIES MECKELS DIVERTICULUM
    OA Abnormality GASABN7 GASTROINTESTINAL ABNORMALITIES ANORECTAL ABNORMALITY
    OA Abnormality GASABN8 GASTROINTESTINAL ABNORMALITIES CLOACAL ANOMALY
    OA Abnormality GASABN9 GASTROINTESTINAL ABNORMALITIES OTHER
    OA Abnormality GASABN10 GASTROINTESTINAL ABNORMALITIES NOT RECORDED
    OA Abnormality AAH CONGENITAL HEART DISEASE YES
    OA Abnormality AAH CONGENITAL HEART DISEASE NO
    OA Abnormality AAH CONGENITAL HEART DISEASE NOT RECORDED
    OA Abnormality HD0 TYPE OF CONGENITAL HEART DISEASE INTRACARDIAC SEPTATION DEFFECT
    OA Abnormality HD1 TYPE OF CONGENITAL HEART DISEASE GREAT VESSEL DEFECT
    OA Abnormality HD2 TYPE OF CONGENITAL HEART DISEASE COMBINED SEPTAL AND VESSEL
    OA Abnormality HD3 TYPE OF CONGENITAL HEART DISEASE NOT RECORDED
    OA Abnormality SEPT0 SEPTATION DEFECT ASD
    OA Abnormality SEPT1 SEPTATION DEFECT VSD AND COA
    OA Abnormality SEPT2 SEPTATION DEFECT CAVS
    OA Abnormality SEPT3 SEPTATION DEFECT OTHER SEPTATION DEFECT
    OA Abnormality SEPT4 SEPTATION DEFECT SEPTATION DEFECT NOT RECORDED


    Please take a look at the attached screen piture
    Attached Thumbnails Attached Thumbnails screeen.jpg  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •