Import metadata from Sequential file

chulett · Post by **chulett** » Mon Mar 03, 2014 3:45 pm

Set the 'Delimiter string' property.

mandyli · Post by **mandyli** » Mon Mar 03, 2014 3:51 pm

Thanks for your reply.

Is this option available in Sequential File Definitions import tab?

Thanks
Man

ray.wurlod · Post by **ray.wurlod** » Mon Mar 03, 2014 4:13 pm

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.

chulett · Post by **chulett** » Mon Mar 03, 2014 4:51 pm

ray.wurlod wrote:It's not.

Phooey. Should be.