Main Area and Open Discussion > General Software Discussion
Converting Spreadsheet to Table in forum
tomos:
This is really a problem. SED goes through the CSV line by line and I see no way to change this. One possible solution is, that you dont put multiple lines in one cell, but instead use some kind of seperator - # for example - which could be translated to a simple
--- ---[br].
I tried to save the Spreadsheet as HTML, but then you lose the Linebreak. Hmmm... I try to find a solution.
-crono (May 14, 2007, 03:00 PM)
--- End quote ---
didnt really understand till -
only saw the "br" when I quoted you ;)
sounds like a good idea!
tomos:
Any luck crono :)
I think if the # idea is feasible it might be the best !?
But I can do that in Text-Editor as well !! ;)
crono:
Hi Tomos,
I tried to dive into "Openoffice.org XML Export Filter"-Programming. This would be the "cleanest" way to do it, but I haven't found the time right now.
The #-thing would work at least I believe...
Try:
--- ---@echo off
set infile=%1%
sed -e "s/#/\[br\]/g" "%infile%" > temp1.txt
sed -e "s/;/\[\/td\]\[td\]/g" temp1.txt > temp2.txt
sed -e "s/$/\[\/td\]\[\/tr]/g" temp2.txt > temp1.txt
sed -e "s/^/\[tr\]\[td\]/g" temp1.txt > temp2.txt
echo [table] > table.txt
type temp2.txt >> table.txt
echo [/table] >> table.txt
del temp1.txt
del temp2.txt
Its untested - please try it :)
tomos:
thanks crono
might not be able to try for a couple of days (holiday here tomorrow - moving furniture plans..)
will let you know how i get on (with the script!) when i try it.
David1904:
Hi all,
There is a program called Columnizer (freebie) - from Gulf Coastal Software.
It does a lot of stuff with aligning columns, adding or deleting lines or characters. I really don't know whether it is of any use in this situation or not, but thought I'd mention it
David
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version