Problem with end of line characters CR LF

CloverDX Platform
1

I’m trying to read a fixed length file in which the end of each record is marked with ‘*’ and then CR LF characters. When I’m using ‘\n’ in the delimiter value of the metadata I’m always getting an error for the last field mapped “record #0 doesn’t match type string”.
Which value should I use for the delimiter?

Thank you,
Gal

2

Hi Gal,

\n is just Line feed, you miss \r which represents Carriage return. So \r\n represents CR LF and * will be the prefix. The correct delimiter is therefore the following:

*\r\n

I hope this helps.