Carraige Return {CR} Sequential File

nvalia · Post by **nvalia** » Thu Jun 20, 2013 9:57 am

Hi All,

DS 8.7 on Windows 2008 R2

We have a Pipe delimited source File and the Record Delimeter is a Carriage Return.I am Using the Sequential File stage to read it.
I tried using all the Record Delimiter options like end, none, whitespace , tab..but it fails and cannot read the file

Then I tried using the Record Delimiter String = "Dos Format" but this fails too..also tried using CHAR(13) here but that failed too

Finally when I tried using Record Type = "implicit", it does not give any error and does read the file but the data read is correct as it does not assign data to each field as we would expect, per the pipe delimiter.

Any Suggestions on how to read this file?

Thanks,
Nirav

nvalia · Post by **nvalia** » Thu Jun 20, 2013 11:33 am

It worked successfully by setting these properties

Record Delimiter String = \r
Final Delimiter = end

Thanks,
NV