Where is the code for importing a pipe separated file into a table?

[HGAutomator]

Thanks edk,

Sorry I was mia for more than a week. Been working on a production problem at the office, which is actually related to this topic.

I'll try and extract a sample pipe file from the one we have, and post.

after
#include <hmg.ch>
Function Main
put this:

Code: Select all

SET CODEPAGE TO UNICODE
SET CENTURY ON
SET DATE FRENCH
SET DATE FORMAT TO 'dd/mm/yyyy'

See if it works?

Pay attention to the indicated date '06/15/2023'. It is in the American format 'mm/dd/yyyy' and not French (there is no month 15 in the calendar )

@HGAutomator. Can U upload sample CSV file with a pipe delimiter