[Solved] Text CSV to Calc import columns and rows
Posted: Fri Jul 16, 2010 7:46 am
Yes I read FAQ and guides. It helped me get as far as now able to import a txt file created in OOO into CALC
BUT
the text separates itself across columns and not like Excel where one sentence or delimted section oif text gets placed in one row ro form one case, and
so one has one text string or in my situation I require one sentence per row in the first column field
so that i can code each senetnec for research analysis using one coumn for each variable I intend to code for.
Please help me get it right as I have an enormous corpus of text.
I trialed one file by using OOO to insert TABS after ecah full stop but that seemed not to work so when i asked the CALC import box to use
a period of full stop it seemed ahppy but arranged ecah sentence in pone column right across the page forever...HELP
Thanks
Researcher
Poor academic who cannot afford to buy Excel
and lives where piracy is the norm and difficult to find legal copies even in institutions
BUT
the text separates itself across columns and not like Excel where one sentence or delimted section oif text gets placed in one row ro form one case, and
so one has one text string or in my situation I require one sentence per row in the first column field
so that i can code each senetnec for research analysis using one coumn for each variable I intend to code for.
Please help me get it right as I have an enormous corpus of text.
I trialed one file by using OOO to insert TABS after ecah full stop but that seemed not to work so when i asked the CALC import box to use
a period of full stop it seemed ahppy but arranged ecah sentence in pone column right across the page forever...HELP
Thanks
Researcher
Poor academic who cannot afford to buy Excel
and lives where piracy is the norm and difficult to find legal copies even in institutions