Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2011
    Posts
    1

    Unanswered: Trouble with removing [ character

    please help

    I have a column that has 1000s of records in it. Some of them contain [ ] around text that I need to remove EX: [A/T]

    I need it to read A/T not [A/T] for whatever records are affected.

    I tried search and replace. that was able to remove the ] from all records, however when I try to search [ all I get is an error saying

    "The Pattern String is Invalid".

    I guess i will have to make a query of some sort to remove the [ from the records, however i am not sure how to do so.

    Could someone please kindly point me in the right direction. I am not overly familiar with MS Access or its syntax/

    thanks

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    In a query, you should try:
    Code:
    Replace(Replace([SomeField], "[", ""), "]", "") AS SomeAlias
    Have a nice day!

Posting Permissions

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