AnsweredAssumed Answered

Creating a CSV file with comma separated values to import

Question asked by jeremy_oz on Sep 24, 2018
Latest reply on Sep 26, 2018 by beverly

Hi All

 

I am trying to export a file and then import the data into a 3rd party system

 

The data is purchasing data and the critical information is

 

Item, Qty, Price

 

I have read a number of threads on here and tried a number of solutions

 

Bev suggested in a thread to create a calculated field containing the data and comma's which I did, then export just the one field as a tab file and then change the .tab to .csv

 

this gets very close except all of the values are in the same line

 

I then tries to add the the end of the string & char(13) no luck then I tried char (13) & char (10) still no luck

 

when I get the exported file and manually edit the file with a CRLF it works fine.

 

Any suggestions would be much appreciated

 

best

 

Jeremy

 

 

 

Screen Shot 2018-09-25 at 10.57.26 am.jpg

Outcomes