DSXchange

Posted: **Wed Jun 28, 2006 1:08 pm**

hai,
I got a table in which combined data is present in a particular column.I want to get that data seperately and want to use that for the other purpose.I also have the field positions for the combined data.
Thanks

Posted: **Wed Jun 28, 2006 1:11 pm**

if you have the field position then use the substring functionality to split the data.

Posted: **Wed Jun 28, 2006 2:32 pm**

Sorry

. Did not pay attention that it was a TX question.

Posted: **Thu Jun 29, 2006 1:51 am**

However, you could use the LEFT, RIGHT and MID functions.
Extract the data into your input card using a query then split up the field as required.

DSXchange

parsing data from a table

parsing data from a table