Page 1 of 1
Posted: Mon Mar 03, 2014 3:45 pm
by chulett
Set the 'Delimiter string' property.
Posted: Mon Mar 03, 2014 3:51 pm
by mandyli
Thanks for your reply.
Is this option available in Sequential File Definitions import tab?
Thanks
Man
Posted: Mon Mar 03, 2014 4:13 pm
by ray.wurlod
It's not.
Who creates these weird files anyway? My suggestion, just for the metadata import, would be to grab a head sample of, say, 30 records and translate (tr) the delimiter so something "regular" (maybe tab) that's not in the data.
Then, in the actual job, use the delimiter string property.
Posted: Mon Mar 03, 2014 4:51 pm
by chulett
ray.wurlod wrote:It's not.
Phooey. Should be.