I want the UPC Code to disappear, regardless of the position of the white space.

Now, I know there's gonna be some fun with punctuation as well in some of the less frequent case, but I'm sure I can handle that when I get to it. For now:

Main ways:
"Big Widget 1 12345 12345 1" ==> "Big Widget"
"Big Widget - 1 12345 12345 1" ==> "Big Widget - "

Occurs a few times:
"Big Widget (1 12345 12345 1)" ==> "Big Widget (1 12345 12345 1)"

Once only:
"Big Widget 1 12345 12345 1 / China" ==> "Big Widget / China"
"Big Widget Green:1 12345 12345 1" ==> "Big Widget Green:"

As noted before, the spaces within the UPC code in the field can occur anywhere; the pattern used here is just the most frequent usage.


>I see your "input" data, but what do you want as output?
>
>>Tore -- from an earlier response of mine:
>>
>>Unfortunately, there's no absolute positioning involved here that can be counted on. Since this is a free form text field, what occurs is what you might expect: there are a couple of main ways that the UPC is represented, a main exception, and a couple of special cases:
>>
>>Main ways:
>>"Big Widget 1 12345 12345 1"
>>"Big Widget - 1 12345 12345 1"
>>Occurs a few times:
>>"Big Widget (1 12345 12345 1)"
>>Once only:
>>"Big Widget 1 12345 12345 1 / China"
>>"Big Widget Green:1 12345 12345 1"
>>
>>Can't really count on anything, I'm afraid, other than that the UPC Code appears with white space.
>>
>>
>>