DSXchange

Hello,
I am getting multi delimiter separated flat file.
Delimiter is : <|>
Can anyone have idea how to handle these type of file ?

Thanks in advance for your time.

Typically that would involve some kind of O/S level preprocessing step to change those characters into a more 'traditional' delimiter the stage could then handle. Or read the record in as one long string and then use custom logic to parse the fields out inside the job.

Hi,
I vaguely recall our instructor pointing a format specification for "Delimiter string" in the Sequential File Stage properties..... I checked it out now and looks like there is no luck with Server Jobs.
This property is available only in Parallel Canvas

Thanks

You could pass your file via a 'Filter Command' to translate the multi-character delimiters into something you'd prefer. Remember to check the box on the Stage/General tab to enable Filter Commands.

True, the 'O/S level' step I mentioned could be leveraged in the Filter option of the Sequential File stage... say, something like 'tr' or 'awk'. My personal preference would be to do it as a separate step, for whatever that is worth.