Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / August 2007

Tip: Looking for answers? Try searching our database.

export XLS to CSV with particular delimiter

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Alain R. - 10 Aug 2007 09:03 GMT
Hi,

I would like to know how can i export content of XLS file to CSV
specifying the delimiter will not be "," (comma) but ";"(semicolon) ?

thanks a lot,

Al.
Dave Peterson - 10 Aug 2007 12:44 GMT
You can change your windows list separator to a semicolon.

Go to windows control panel, regional and language options|Regional options tab
then click customize and look for List separator on the Numbers tab.

I'd change it back when you're done--it's a windows setting and you may not like
it as your default.

Another option would be to use a macro.

You could use a macro and write code and have complete control over what you
write.

Here are three sites that you could steal some code from:

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly:  http://www.smokeylake.com/excel/text_write_program.htm)

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

Earl's program may work right out of the box.

> Hi,
>
[quoted text clipped - 4 lines]
>
> Al.

Signature

Dave Peterson

Earl Kiosterud - 10 Aug 2007 17:33 GMT
Although folks are free to steal code from my Text Write Program, I wanted to point out that
it's a ready-to-use utility, if you want to run it that way.  Fill in the blanks and run
it -- it'll write the text file from your sheet.  Or you can take the whole module, plug in
your specs for how you want the text file written (from the setup sheet), and run it in your
code.
Signature

Earl Kiosterud
www.smokeylake.com

   Note: Top-posting has been the norm here.
   Some folks prefer bottom-posting.
   But if you bottom-post to a reply that's
   already top-posted, the thread gets messy.
   When in Rome...
-----------------------------------------------------------------------

> You can change your windows list separator to a semicolon.
>
[quoted text clipped - 31 lines]
>>
>> Al.
Dave Peterson - 10 Aug 2007 17:38 GMT
I tried to say that with this line:

> > Earl's program may work right out of the box.

<bg>

> Although folks are free to steal code from my Text Write Program, I wanted to point out that
> it's a ready-to-use utility, if you want to run it that way.  Fill in the blanks and run
[quoted text clipped - 50 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Earl Kiosterud - 10 Aug 2007 18:25 GMT
Dave,

So you did, so you did.  I didn't notice it down there, and thought you'd stopped saying it.
Just blowing my horn! :)
Signature

Earl Kiosterud
www.smokeylake.com

-----------------------------------------------------------------------

>I tried to say that with this line:
>
[quoted text clipped - 59 lines]
>> >
>> > Dave Peterson
Dave Peterson - 10 Aug 2007 19:38 GMT
It depends on how much I copy and paste <bg>.

> Dave,
>
[quoted text clipped - 72 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.