Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2011
    Location
    WA, US
    Posts
    5

    Unanswered: Removing "/" and "** from string field

    Morning all

    I'm a newbie to Access and am finding it difficult to remove specified characters from a text field. The field contains primarily numeric data where "/" and "*" have been added to some of the numeric values to denote a comment of some kind. I need to remove the / and * (or any combination of / and *) so I can use the numeric base for a calculation (e.g. divide by 1000).

    70
    700/
    7000/*
    7*
    700*/

    Any help would be appreciated.

  2. #2
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    995
    Provided Answers: 2
    You can use the Replace function in a query to display the data without those characters:
    Replace(Replace([FieldName], "*", ""), "/", "")
    10% of magic is knowing something that no-one else does. The rest is misdirection.

  3. #3
    Join Date
    Jun 2011
    Location
    WA, US
    Posts
    5
    Worked very well, thank you!

    Got rid of the unnecessary and allowed me to calculate the "isnumeric". I didn't realize I had some other stray text in the records and it worked out perfectly.

  4. #4
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    995
    Provided Answers: 2
    Happy to help - glad it worked!
    10% of magic is knowing something that no-one else does. The rest is misdirection.

Posting Permissions

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