Skip to Content
0
Former Member
Oct 12, 2005 at 09:51 PM

problem with flat file upload with ASCII file

241 Views

Hi All,

I am trying to load data into an ODS object via PSA using a text file (tab delimited). I have the following settings in my InfoPackage

External Data tab: ASCII File

Seperator for thousands:

Character for decimal point:

Currency Conversion:

Number of Header rows to be ignored: 1

Processing tab: Only PSA and Update into data targets subsequently

When I do a preview the data is not showing up in the right format....the tab seperation does not work and data is garbled with extra hexadecimal characters too.

The same file contents in .csv format is loading the data in the right format and preview is fine too.

I need help trying to convert this csv file to .txt format.

Any clues are highly appreciated

Thank you