Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2005
    Location
    Minnesota
    Posts
    42

    Unanswered: Getting rid of parantheses using replace

    I posted this in the tek tips forum. I haven't been able to get it resolved. The thread is thread705-1277401. I am trying to get rid of all parantheses in the field that I am running it against.

    I cannot get my code to work. I am fairly new to visual basic. I just want to remove the parentheses out of about 25,000 fields from a query that I am basing off of a warehouse table. See thread705-1277401 for full explanation. Some of the records have parentheses and some don’t. I am creating a function and placing it in the query and I cannot get it to work.

    I want these results:
    2604-(26X03) should be 2604-26X03
    4610-(96719) should be 4610-96719
    5618-(5025) should be 5618-5025
    2103-(95108) should be 2103-95108
    5622-12 should be 5622-12 (unchanged)
    5628-3 should be 5628-3 (unchanged)
    4402-881 should be 4402-881 (unchanged)
    Attached Files Attached Files

  2. #2
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    Can't you do an update query?
    iif(\(,"","")
    iif(\),"","")
    Ryan
    My Blog

  3. #3
    Join Date
    Apr 2005
    Location
    Minnesota
    Posts
    42
    Ryan,

    A programmer in another forum figured it out. The other modules that I had in it were creating problems. More specifically, Module 3, Module 5 and the OIM module are causing the problems.

  4. #4
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    oh ok, I didn't look at your database.
    Ryan
    My Blog

  5. #5
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Nevermind - thought went away.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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