Sequential File - 2 Character Delimiter

nvalia · Post by **nvalia** » Mon Oct 27, 2014 2:09 pm

Hi All,

We have been trying to finalize the source extract delimiter but the source system seems to have most characters like | ~ and so on.

We were thinking of using Double Quotes around every field in all the extracts to take care of this issue there is a likely hood of even " (Double Quotes) being present in the data itself.

I know this is not an issue with Datastage per se but any ideas on how to handle this handle this scenario..

Is using 2 character combo as a delimiter an option, like Pipe and Tilde --> |~

We anticipate the biggest first full file to be 40-50 GB for the biggest one and then incremental extracts

Any known issue with this approach?

Thanks
NV

qt_ky · Post by **qt_ky** » Mon Nov 10, 2014 6:47 am

Go with a fixed-width format instead of delimited.

ray.wurlod · Post by **ray.wurlod** » Mon Nov 10, 2014 3:59 pm

When the field delimiter has more than one character replace the Field Delimiter property with the Field Delimiter String property.

Nagac · Post by **Nagac** » Tue Nov 11, 2014 5:59 pm

You can go ahead with 2 characters as field delimiter. and follow Ray's suggestion.