![]() |
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 |
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