hi

i have a text file with firstrow
03 ex 12345678912345678912xxxxx9999988888
fifth row
04 gh 23564789122334788933zzzzz3333388888822222555556666 688888

how to delimited my file?
if i used fixed lengths, it is only taking first row number of charecters
because each line has "return key".


thanks

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200511/1

Only you can answer how to delimit the data.

I would be asking

Why does it look like this?
What does each value in each row represent?
What was the criteria for the system that created the file?


Allan

"chinna j" <u13422@uwe> wrote