Yes but my fields are not separated by anything i have fiels fixed sized width numbers with thousand separator "," and decimal separator "."
> Hi Marcelo, > > [EMAIL PROTECTED] wrote: >> 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. > 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. > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
