Converting data to .csv format for loading
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Converting data to .csv format for loading

  1. #1
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681

    Converting data to .csv format for loading

    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,

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,021
    Have you tried using the tilde, ~?
    this space intentionally left blank

  3. #3
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    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

  4. #4
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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

  5. #5
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    Thanks dear...i will just the one u just have just said

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width