LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  How to define record delimiters

    Employee
    Posted 06-10-2008 16:02

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: roeperg

    Hi

    I am trying to import a pipe delimited file and have been unable to figure out how to represent a line feed in the RecordDelimter field. If I leave it blank the node fails validation. I have tried 0A, x0A, 0D0A, x0D0A and a couple of wild guesses like <CRLF> but nothing works. This is a standard MS-DOS text file. The field delimiter ("|") works fine.

    Greg


  • 2.  RE: How to define record delimiters

    Employee
    Posted 06-10-2008 16:05

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: mmarinelli

    Use "\\n". You can use other standard characters like "\\r", "\\t", etc., along with the "\\x" notation for enumerated ASCII values.


  • 3.  RE: How to define record delimiters

    Employee
    Posted 06-10-2008 16:14

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: roeperg

    Oh, duh! I have 20 years of C programming but it did not occur to me to try backslash n here. Thanks for the quick reply!<br><br>Post edited by: roeperg, at: 2008/06/10 18:29