Results 1 to 2 of 2

Thread: format file

  1. #1
    Join Date
    Jan 2004
    Posts
    1

    Unanswered: format file

    What are format files and how do they help us in Bulk Load????
    I referred to many issues send to the forum but could not get sufficient information on this.

    My main issue is to bulk insert from a .CSV file in hte following format

    12,23,"blrnnr","Address",45677,"bangalore"........ .....68 columns

    After bulk insert I am getting the double qoutes also into the table.
    Now my problem is, How do I remove these double qoutes?
    I don't want to use replace() to remove these quotes!!!!!!
    I have attached a Screen Shot to describe this issue with this mail

    Any information is appretiated regarding this issue.

    Thanking you
    Naveen

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401

    Re: format file

    Originally posted by blrnnr
    What are format files and how do they help us in Bulk Load????
    I referred to many issues send to the forum but could not get sufficient information on this.

    My main issue is to bulk insert from a .CSV file in hte following format

    12,23,"blrnnr","Address",45677,"bangalore"........ .....68 columns

    After bulk insert I am getting the double qoutes also into the table.
    Now my problem is, How do I remove these double qoutes?
    I don't want to use replace() to remove these quotes!!!!!!
    I have attached a Screen Shot to describe this issue with this mail

    Any information is appretiated regarding this issue.

    Thanking you
    Naveen
    Read This
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

Posting Permissions

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