On Fri, 2011-10-07 at 07:36 +0700, toto wrote: > On 10/06/2011 09:28 PM, planas wrote: > > On Thu, 2011-10-06 at 15:41 +0200, Stephan Zietsman wrote: > > > >> toto wrote: > >>> I want to save file from Calc into CSV file or text file using macro, but > >>> before that I want to change the content and use semicolon as delimiter. > >>> Anyone can help or have some reference on it? > >> Not sure if I understand you correctly, but you can save a file as CSV > >> with "File> Save As...(Ctrl + Shift + s)". Then in the "Save as > >> Type" drop-down select "Text CSV (.csv)". Then if you click the > >> "Save" button, you are given the option to select the delimiter. > >> > > After selecting CSV, click the "Edit Filter Settings" box. The wizard > > will eventually get to a dialog box that allows you to select the > > delimiter, its the middle box. > > > >> Hope this helps. If I misunderstood your question, please rephrase or > >> explain it a little more. > >> > >> Regards > >> Stephan > >> > > > > > I need a macro script to save file into CSV file, but I want to change > delimiter into semicolon. I already look at this > http://stackoverflow.com/questions/1319136/openoffice-calc-macro-for-csv-saving > > but I don't find a way to change the delimiter ... >
Hi, Perhaps this will help http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=2551 This is one example, there are few others on the forums do a search for "change delimiter CSV macro" perhaps... HTH, //drew -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
