Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Oct 2002
    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
    Thanked 31 Times in 31 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