String manipulation with exceptions

**Apel** · 07-23-2009, 01:01 PM

I have a macro that loops through a column of text and removes all text after a hyphen. Example: AU9929-PK becomes AU9929. I need to set up some exceptions that when it processes certain text it does not truncate it. Example: AU9929-ASST stays as AU9929-ASST. So far there are twelve exceptions but this could increase.

Note: The list which includes shop number, description, sku, sku description, quantity, unit price and more is sorted in a particular order as other operations are performed on it that requires it be in a specific order.

**bhofsetz** · 07-23-2009, 01:11 PM

Post the loop that you are currently using to truncate after the hyphen and we can give suggestions to modify your existing code to accomodate your exceptions?

**Apel** · 07-23-2009, 01:43 PM

Here is the code.

Please Login or Register  to view this content.

**bhofsetz** · 07-23-2009, 01:59 PM

In this If statement you can test for your exceptions and then NOT trim your SKU accordingly.

Please Login or Register  to view this content.

You will need to add a check for each of your exceptions.

Please Login or Register  to view this content.

which can get cumbersome as your number of excpetions increases. You may want to switch to using a Seclect Case statement to make this a little easier to manage as your exceptions change, etc.

HTH