Hi all can some one help me
I am trying to split AAA to AA and 0
and GASABN0 to GASABN to 0
as you can see from the sample data the are a lot of different values
I would also like to add a number if there isnt on AAA to AA and 0 etc

This is above my head as I am a jnr dba


1 OA Abnormality AAA ASSOCIATED ABNORMALITIES YES
1 OA Abnormality AAA ASSOCIATED ABNORMALITIES NO
1 OA Abnormality AAA ASSOCIATED ABNORMALITIES NOT RECORDED
1 OA Abnormality AAG GASTROINTESTINAL ABNORMALITIES YES
1 OA Abnormality AAG GASTROINTESTINAL ABNORMALITIES NO
1 OA Abnormality AAG GASTROINTESTINAL ABNORMALITIES NOT RECORDED
1 OA Abnormality GASABN0 GASTROINTESTINAL ABNORMALITIES DUODENAL ATRESIA
1 OA Abnormality GASABN1 GASTROINTESTINAL ABNORMALITIES DUDENAL STENOSIS
1 OA Abnormality GASABN2 GASTROINTESTINAL ABNORMALITIES PYLORIC STENOSIS
1 OA Abnormality GASABN3 GASTROINTESTINAL ABNORMALITIES GASTROESOPHAGEAL REFLUX
1 OA Abnormality GASABN4 GASTROINTESTINAL ABNORMALITIES TRACHEO-BRONCIAL REMNANT
1 OA Abnormality GASABN5 GASTROINTESTINAL ABNORMALITIES MALROTATION
1 OA Abnormality GASABN6 GASTROINTESTINAL ABNORMALITIES MECKELS DIVERTICULUM


Many thanks

g