On Sunday 24 December 2006 14:23, ad van-elsacker wrote: > Dear all > > I am already searching for quite some time for the OO equivalent of the > Excel Data option "Text to column" which allows separation of text data in > several columns, by specifying either a fixed width or alternatively a > separating character. Could you help me please ? > Thanks in advance, ad > I
I assume you are asking to read a text file into OOo Calc, where the file is encoded one line per row, and the columns are identified either by (one or more) delimiters, or by some fixed width. This can be done. Go to File -> Open In the dialog, select the file you want to open (use the File type filter All Files (*.*) to see all the files in each directory. When you have selected the file, search the drop down list under File Type looking for the section headed Open Document Spreadsheet, and in that section find the line Text CSV (*.csv,*.txt). Hit Open. [It helps if you use either .csv or.txt as the extension for the files, but is not essential. Note: the drop down list is long - you'll have to scroll down some way.] This puts you in a dialog where you can specify which characters are the delimiters between columns. Or you can say Fixed width, and then select the width of each column in the heading of the diagram at the base of the dialog - click at the appropriate position and a red mark appears to indicate the column boundary position. You can save a spreadsheet in a similar manner through File -> Save As and look for Text CSV (*.csv) as the file type to save under. -- Andy Pepperdine On this mailing list help is provided by volunteers. Please subscribe to the mailing list to see all the replies to a query, and reply only to the mailing list. For FAQ, userguide, see: http://documentation.openoffice.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
