Row-Delimiter & column Delimiter in Datastage

[saj]

Hi,
Could you please help me out in the below questions.

1) If we have a file with combined row-delimiter (which
means a char is appended in front of the new line char), is it possible
to set the combined delimiter as the row delimiter in data stage?
Field1|Field2|Field3${LR} Field1|Field2|Field3${LR}
Field1|Field2|Field3${LR} ---> here ${LR} is the row-delimiter.

2) If we have a file with combined column-delimiter, is it possible to
set the combined delimiter as the column delimiter in data stage?
Field1$|Field2$|Field3{LR}Field1$|Field2$|Field3{LR}
Field1$|Field2$|Field3{LR} ---> here $| is the column delimiter.

[ray.wurlod]

I don't believe the server Sequential File stage can handle this (the parallel one can). In a server job, given that your file does have operating system line terminators, why not run a Filter command (for example sed or awk) to strip out the {LR} characters?

Similarly for the multi-character field delimiter, a Filter command could convert these to a suitable single-character field delimiter; one that does not occur in your data (for example tab).