How to set default delimiter for text files...

  • Thread starter Thread starter GG
  • Start date Start date
G

GG

Hello,

Database produces output files as text delimited files with CSV extension.
Problem is that different versions of ms excel has different default
delimiter: comma or semicolon.
How to configure ms-excel: default field separator (delimiter), to be the
same on all workstations
opening these files ? Open must be full automatic - just by clicking CSV
file in the explorer, users
are not a gurus..

Thanks and regards,
GG
 
Hello,

Database produces output files as text delimited files with CSV extension.
Problem is that different versions of ms excel has different default
delimiter: comma or semicolon.
How to configure ms-excel: default field separator (delimiter), to be the
same on all workstations
opening these files ? Open must be full automatic - just by clicking CSV
file in the explorer, users
are not a gurus..

Thanks and regards,
GG
Click to expand...

..csv files should open automatically (no import dialog) in Excel when
they are clicked in Explorer. Your system may not be set to use Excel
for these files.

Try copying & pasting this to an empty text file named excelcsv.reg;
first verify (and correct, if necessary) the pathname to Excel.exe.
Be sure to use the double backslashes and leave the backslashes in
front of the quote marks. (It's a C/C++ thing) then double-click the
file to merge it into your registry:



Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\.csv]
@="Excel.CSV"

[HKEY_CLASSES_ROOT\.csv\Excel.CSV]

[HKEY_CLASSES_ROOT\.csv\Excel.CSV\ShellNew]

[HKEY_CLASSES_ROOT\Excel.CSV]
@="Microsoft Excel Comma Separated Values File"

[HKEY_CLASSES_ROOT\Excel.CSV\CLSID]
@="{00020820-0000-0000-C000-000000000046}"

[HKEY_CLASSES_ROOT\Excel.CSV\shell]
@="Open"

[HKEY_CLASSES_ROOT\Excel.CSV\shell\Open]

[HKEY_CLASSES_ROOT\Excel.CSV\shell\Open\command]
@="\"C:\\Program Files\\Microsoft Office\\Office\\EXCEL.EXE\" /e"

[HKEY_CLASSES_ROOT\Excel.CSV\shell\Open\ddeexec]
@="[open(\"%1\")]"

[HKEY_CLASSES_ROOT\Excel.CSV\shell\Open\ddeexec\application]
@="Excel"

[HKEY_CLASSES_ROOT\Excel.CSV\shell\Open\ddeexec\topic]
@="system"

[HKEY_CLASSES_ROOT\Excel.CSV\shell\Print]

[HKEY_CLASSES_ROOT\Excel.CSV\shell\Print\command]
@="\"C:\\Program Files\\Microsoft Office\\Office\\EXCEL.EXE\" /e"

[HKEY_CLASSES_ROOT\Excel.CSV\shell\Print\ddeexec]
@="[open(\"%1\")][print()][close()]"

[HKEY_CLASSES_ROOT\Excel.CSV\shell\Print\ddeexec\application]
@="Excel"

[HKEY_CLASSES_ROOT\Excel.CSV\shell\Print\ddeexec\ifexec]
@="[open(\"%1\")][print()][quit()]"

[HKEY_CLASSES_ROOT\Excel.CSV\shell\Print\ddeexec\topic]
@="system"

Mike Argy
Custom Office Solutions
and Windows/UNIX applications

Please post on-topic responses to the newsgroup

To e-mail me, remove nospam from the address in the headers
 
I think that this is a windows regional settings issue.

Windows start button|settings|control panel|regional settings
Number tab|list separator

Make sure your setting matches your data.
 
Back
Top