Re: [libreoffice-users] need help how to save file into text file or CSV file

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: users+help@global.libreoffice.org
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