Hello everyone...
I have a problem here..ill explain...

I have a column in my database which contains data about mainframe's datatypes.. like this...
pix x
pix xx
pix x(5)
pic 9
pic 9(4)


Thats how the data exists in the column.
Now I need to retrieve that data and convert them and store them into 2 columns in another database like this....This is the translated form of the example shown above...
DATA TYPE COLUMN . DATA LENGTH COLUMN
Alpha numeric . 1
Alpha numeric . 2
Alpha numeric . 5
Numeric . 1
Numeric . 1

Im trying to make my program to do this...Can you all give me your ideas?
My idea is to check with many if statements? well,sounds long code...anything else I can do?
Any ideas? help..Thanks
Thanks