Export excel file to semicolon delimited text file

  • Thread starter Thread starter capitan
  • Start date Start date
C

capitan

Hello all. We have the need to export a file from excel to a semicolon
delimited text file. Is there a way to do this from Excel directly? If
not, does anyone have any other suggestions? TIA for your help.
 
If you change your regional settings to use the semicolon as your list
separator, you can save as .csv and it should work. But this may affect other
programs, too--since it's a windows setting.

windows start button|settings|control panel|regional and language options|
regional options tab|customize button

near the bottom.

On the other hand, if you don't want to fiddle with that setting, you could use
a macro to write your file.

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


If you don't want to write your own, try Earl's program first. He has lots of
options in that program.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Export as a csv file. Open file in Notepad and replace commas with
semi-colons.
Works fine unless you have commas in your cells.

Bill

Hello all. We have the need to export a file from excel to a semicolon
delimited text file. Is there a way to do this from Excel directly? If
not, does anyone have any other suggestions? TIA for your help.
 
Bill said:
Export as a csv file. Open file in Notepad and replace commas with
semi-colons.
Works fine unless you have commas in your cells.

Bill

Hello all. We have the need to export a file from excel to a semicolon
delimited text file. Is there a way to do this from Excel directly? If
not, does anyone have any other suggestions? TIA for your help.
Click to expand...

Thanks Bill. You read my mind, because that is exactly what we are
doing with it now. My hope is to automate the process. Thanks anyway.
 
Dave said:
If you change your regional settings to use the semicolon as your list
separator, you can save as .csv and it should work. But this may affect other
programs, too--since it's a windows setting.

windows start button|settings|control panel|regional and language options|
regional options tab|customize button

near the bottom.

On the other hand, if you don't want to fiddle with that setting, you could use
a macro to write your file.

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


If you don't want to write your own, try Earl's program first. He has lots of
options in that program.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
Click to expand...

Dave,

Thanks so much! Earl's script does exactly what I'm looking for. U da
man, and keep up the great answers. Thanks again.
 
Bill,

A problem with this approach is that if semicolons are the delimiter, then
the field should have quote marks around it if a semicolon appears in the
data. The program writing the file needs to put the delimiters in, so it
knows when to add the quote marks. Otherwise, the program reading the file
can get messed up if semicolons are in the data. More at
http://www.smokeylake.com/excel/textfiles.htm.
 
Back
Top