After reading the various responses to my question I now understand what is being suggested. Here are the steps as I understand them (I am currently testing this): 1.) Open the delimited file with OpenOffice Calc 2.) File -> Save as -> select the Text CSV file type -> check the "Edit Filter Settings" box -> click Save 3.) Click Yes in the warning dialog box (warns about losing information by not saving in an OpenOffice format) 4.) In the Field Delimiter drop down box select what you would like the file delimited by 5.) In the Text delimiter box select delimiter for text (is this necessary, what would be the advantage of doing this?) 6.) Click Ok 7.) Rename the file as .txt 8.) Import the file into Power Builder (unfortunately the only format allowed for uploading delimited files, in our case, is .txt)
I am currently testing if this will work and will report the results shortly. Please notify me if any of you know of a better way to go about this. Thank you for your help. Robert >>> [EMAIL PROTECTED] 11/02/05 1:50 PM >>> On Wed, 2005-11-02 at 13:13 -0600, Robert Volke wrote: > If I check that option it saves the file as .csv rather than as tab > delimited which is what I actually need. Unfortunately, comma delimited > won't cut it. Do you have another suggestion? Thank you again for your > help, > > Robert Are you saying that the Save As dialogue does NOT offer another dialogue that permits you to set the Field delimiter and character delimiter? If yes then you have a bad installation. Otherwise use this dialogue to set whatever you like. > > >>> [EMAIL PROTECTED] 11/2/05 10:59 AM >>> > On Wed, 2005-11-02 at 10:19 -0600, Robert Volke wrote: > > My understanding so far is that you cannot save a file as tab > delimited > > using Calc, but I recently learned that one of our applications > > (PowerBuilder) requires that files be imported as tab delimited. > Does > > anyone know a way I can use OpenOffice Calc to save an .xls file as > tab > > delimited? Thank you for your help, > > > > I think you understand wrong. Try Save as and select Text CSV as the > output format. -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
