How to include carriage return in VI job

SUGGESTED

I'm importing invoice records from MS Sql server and one of the fields has line feed characters, but they get stripped out during the import.


The sql field contains something like "Line one text" + char(13) + char(10) + "Line two text". 

In MS Access i did the same thing but with chr() instead of char().  MS Access worked fine.


My current attempt is to use functions, but i cannot find a dam thing on how to use the functions.  I could inject some kind of placeholder and then let the import job run a calculation and replace the placeholder with a carriage return.  But how?

Thanks.

Parents Reply
  • 0 in reply to BigLouie

    I've tried BigLouie"s suggestion of the ~;~ and it did not work.  It did not recognize that as a line feed.  Just showed the ~;~ in the field.  I'm on 4.5 and I looked in the file to see what the existing line feed character is in there and it looks like DF or char(223). But when I tried importing that way it did not work either.   We have formatted text (multiple line breaks) that I'd like to import to extended descriptions in CI Item extended descriptions.  Any more ideas?  

Children