ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   delimiter sign in csv files (https://www.excelbanter.com/excel-programming/399928-delimiter-sign-csv-files.html)

shark102

delimiter sign in csv files
 
hello

when I save as csv columns get separated with commas. what do i need to do
to force';' - semicolon as delimiter sign regardless of computers regional
settings?

thanks

Dave Peterson

delimiter sign in csv files
 
I think you'll have to take control over how you export the data if you really
want to ignore that windows setting.

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.

shark102 wrote:

hello

when I save as csv columns get separated with commas. what do i need to do
to force';' - semicolon as delimiter sign regardless of computers regional
settings?

thanks


--

Dave Peterson


All times are GMT +1. The time now is 11:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com