Converting data to .csv format for loading

[yxez]

Hi Friends,

We use Oracle and Mssql databases, and often times i'm loading data
from/to the 2 databases. I often convert data to .csv format to be
loadable to both database. I often used comma (,) sapated and
optionally enclosed by d'quote(").
My problem is, I often encoutered (") on one of the columns values
like addresses and it will mis-aligned the column positioning thus
turning it to bad data. How do i deal with this problem?

Thanks a again,

[gandolf989]

Have you tried using the tilde, ~?

[yxez]

yes dear...but still i found this ~ existing in the columns fields values. I wonder how this dang encoders be able to hit all the keys
in the keyboard? Any special character i can use? which
is not found on the keyboard?


Thanks

[DaPi]

Have a look at \windows\system32\charmap.exe - it gives all the keystrokes for special characters not on the keyboard. E.g. Alt-0182 gives ¶
You'll have to experiment to see which are accepted.

[yxez]

Thanks dear...i will just the one u just have just said