On Thu, 2005-03-17 at 10:07 +0000, [EMAIL PROTECTED] wrote: > Yes but my fields are not separated by anything i have fiels fixed sized > width numbers with thousand separator "," and decimal separator "." >
AH! Fixed width fields. Calc will import these and allow you to set the field boundaries and field types. Simply select the checkbox that says Fixed width and go. > > 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] -- Documentation Co-Lead http://documentation.openoffice.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
