Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Oct 2002
    Posts
    114
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Clean text to only in set [A..Z0..9] (2000/sp3)

    I'm importing a part list from an excel speadsheet... this part list is in complete shambles.

    I've got most of the database done, and am implementing various sorting and searching mechanisms. My only glitch is that these part numbers sometimes have spaces, dashes, slashes, underscores, and all sorts of other junk that I want to ignore. All I want to search on is the data within the set [A..Z0..9].

    I have a couple options:

    (1) import the part numbers and strip the bad characters as it is imported
    (2) import the part numbers and generate a secondary item in the table through an update query with the desired data

    Either way, I need a routine that goes and strips characters outside the set. Can't seem to find any built-in functions...

    any ideas?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Clean text to only in set [A..Z0..9] (2000/sp3)

    You can do either in a query. Use (for example) this CleanString function.

Posting Permissions

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