Different Record Delimiter

[Ken Grubb]

Most file systems use CR (Hex 0D), LF (Hex 0A), or both to delimit a record. However, we use some data files that use different characters. One uses ÿ (Hex FF). Is it possible to configure a custom record delimiter character for certain file types?

[Patrick C]

Hi Ken,

As far as I can see using a newline character other than the typical CR &/∨ LF combinations doesn’t seem to be possible.
However, you can write a macro to convert ÿ into CR LF and back again. Provided you aren’t dealing with >1 million lines and >10MB files, this should be pretty fast too.

Best wishes,
Patrick

[Author]

Posts