Welcome Guest. Please Login or Register. Apr 5th, 2018, 11:03pm
ATTENTION MEMBERS: Conforums will be closing it doors and discontinuing its service on April 15, 2018. Ad-Free has been deactivated. Outstanding Ad-Free credits will be reimbursed to respective payment methods.
If you require a dump of the post on your message board, please come to the support board and request it.
Comma delimited files
« Thread started on: Oct 25th, 2013, 11:25am »
I have saved a .dat file containing just numbers. I want to import this into Excel for further processing as a comma-delimited file. But the file contains gibberish - a load of symbols instead of my numbers.
Can anyone advise me how to keep this in the format I wrote to file, please?
I have saved a .dat file containing just numbers. I want to import this into Excel for further processing as a comma-delimited file.
A good format to use, which will be understood by Excel, is CSV (Comma Separated Value). This Wiki article describes how to read and write CSV files in BBC BASIC:
The routines listed there assume that the data will be contained in a 2-dimensional string array, which is a good way of representing spreadsheet-style (row and column) data.
However, since CSV files are basically just plain-text files you can choose to read and write them in other ways if you wish. This article may be helpful: