Converting data to .csv format for loading
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,
Have you tried using the tilde, ~?
this space intentionally left blank
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?
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.
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
Thanks dear...i will just the one u just have just said
Click Here to Expand Forum to Full Width