I am new to script writing. With the help of others I now have a script that reads the files names in a folder and records each file name in a comma delimited file. "import.txt".
I can now import this into Open office Calc as a TextCSV file but it places each file name at the head of a separate column.
What I really want is to be able to import the file such that it shows each file name in a separate row but in the 1 column.
It seems to me I need some how to put a return. line feed or carriage return in where the , is in the script.
How do I do this?
I known one can do an Edit cut and the a special paste in a way that transposes the data base from a single long row of data and to a single column but this is messy for the numbers I have to do. So if it can be done in the generation of the CSV file it would be a lot beter and easier.
I am using OpenOffice 3.3, and Fedora 14 64 bit as the OS
The current script in the area where the comma is is
"$LINE," >> import.txt: done.
This works fine for what I want but it gives the end results as I say with the file name one per column when importing as comma delimited.
Thanks for the reply. I generated a file as you suggested and looked at the readable character it put in to the TextCSV file the showed up as "bread"$ where the $ was coloured blue. There was a $ characters after every line so when I tried in import it again I have all the names listed in a single column with each on a different row.
So I tried to change the text file I had generated with the files names in it. The $ was just put in as a $ straight from the key board (just in black) but when the text files was imported using TextCSV into open office all the file names were in one row and one column.
Clearly the $ was not being recognised as a control character.