SqlDbx Forum

garbuya

Member

Is it possible to change a delimiter while exporting file?

Is it possible to change a delimiter when you do Copy Special or export to EXCEL ?

The default is comma delimited with literal in quotes.
If your columns contains text with apostrophies then output will look like this:
'O'Hare' , 'Airport'
Extra tick in the middle drives some programs (including EXCEL) nuts! It messes up all columns! Everything is shifted!

The safest way is to export with TAB delimiter and not use quotes for the text columns. Many SQL tools allows this option, but I cannot find it in SqlDbx.

Is it possible to have such option? Having ability to change delimiters and surrounded chars would be a great improvement!

sqldbxhelp

Administrator

Re: Is it possible to change a delimiter while exporting file?

First, direct export to Excel is not affected by any apostrophes. It can't. It does not use any delimiters.
Second, delimiters and quoting can be changed in Tools->Options->Import/Export .