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








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