Text Import, Delimited

Treasury Software can import text files (ASCII), in both:

--Delimited (Comma Separated Value, or tab delimited) Format

--Fixed width format

 

You can view either type of file by starting Windows Notepad, then selecting Open and open the file type up to all files *.* (from text *.txt).

 

Comma Separated Values (CSV, delimited)

It's always easy to identify a csv file.  There will be numerous commas on each line.  If you are unsure as to which format the file is in, view your data by alternately selecting each format and viewing the data in the grid.

 

Below is a CSV file viewed in a fixed width format (wrong format, notice all the commas, and secondly notice that the columns don't line up):

 

 

 

Below is a CSV file viewed in a tab delimited format.  Again, it is in the Wrong format - notice that all the data is in one column AND that there are commas (commas are always a give-away for Comma Separated Values):

 
 
 

 

Now we'll select the Delimited - CSV option button at the top of the screen (correct selection, all the columns line up) :