Problem with end of line characters CR LF

gal

• January 30, 2015 00:00

• Answered

Follow

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

• 

  imriskal

  • January 30, 2015 13:32

  0

  Comment actions Permalink

  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.

Please sign in to leave a comment.