Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post

    Removing a double quote from a string (XP)

    I have a csv file from SAP that contains commas in a field so it wraps the field in double quotes - "street addresss, building". when I import this into Access I end up with two fields - "street address and building".
    I can handle shifting the contents of the fields to the correct column but how do I test for and remove a double quote from a string - instr(strAdddres, """) doesn't work!

  2. #2
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Removing a double quote from a string (XP)

    I think I just worked it out - chr(34), I'll test it out and repost

Posting Permissions

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