parsing data from a table

mullaguru123 · Post by **mullaguru123** » 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

DSguru2B · Post by **DSguru2B** » Wed Jun 28, 2006 1:11 pm

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

DSguru2B · Post by **DSguru2B** » Wed Jun 28, 2006 2:32 pm

Sorry

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

janhess · Post by **janhess** » 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.