PC Review


Reply
Thread Tools Rate Thread

delimiter sign in csv files

 
 
=?Utf-8?B?c2hhcmsxMDI=?=
Guest
Posts: n/a
 
      24th Oct 2007
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
 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      24th Oct 2007
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
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing TXT files with delimiter Alaska Ken Microsoft Access Reports 1 23rd Apr 2010 11:17 PM
Delimiter in CSV files =?Utf-8?B?TEFG?= Microsoft Excel Misc 5 12th Jun 2007 11:02 PM
Please define field delimiter and record delimiter in sorting A-Z. =?Utf-8?B?YW5nZWxmYWNl?= Microsoft Word Document Management 2 4th Oct 2004 10:43 PM
Delimiter forExcel Files =?Utf-8?B?RGVsaW1pdA==?= Microsoft Excel Worksheet Functions 1 14th Sep 2004 06:35 AM
How to set default delimiter for text files... GG Microsoft Excel Discussion 2 8th Jul 2004 08:02 PM


Features
 

Advertising
 

Newsgroups
 


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