DSXchange

Hi All,

How can we use 3 characters(@#$) as field delimiter while reading a text file using Sequential file stage either in server or parallel.

But, I checked the documentation and it says it will allow only one ASCII character.

Please shed some light on this.

Thanks in advance.

No light to shed. The documentation is correct.
It can not be done in a Sequential File stage, unless that stage has a filter command to convert the three different delimiter characters to a consistent one.
Otherwise read each line from the file as a single string (for example if you need to preserve the actual delimiter characters) and parse in a downstream Transformer stage.

PX jobs can do it.

Delimiter String may help you at PX jobs.