Hi Marcelo,
[EMAIL PROTECTED] wrote:
The important thing in importing text or csv files into any spreadsheet or even database program, is the character that separates the fields. This character MUST be unique to the data being imported.I need very much of help in importing text file into OpenOffice Calc, because i have a text file with fixed width columns, and the numbers are thousand separated by "," and decimal separated by "," and i'm not able to import it into OpenOffice Calc, with the numbers as numbers.
Available field separators are , ; : TAB etc. I have found that the semi colon is the best field separator as even in URLs might contain a : but after 6 years never have I seen a URL contain a ;
So your data, if opened in a text file editor would look like this:
Field1;Numb.er1;Field3;Fi'el,d4; etc
See after each Field on Number there is a unique field separator that does not appear anywhere in my data.
Hope this helps
-- ======================================================================== Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 ========================================================================
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
