hi Agnes,

I think that your solution is by far the most elegant

ps: the doc is here http://msdn.microsoft.com/library/default.asp?URL=/library/en-us/dnclinic/html/scripting051099.asp
(you search ms for beefs and it is one at the top )


>James,
>
>normaly there is nothing more than those line. Naturally you will not instantiate Regexp in a function over and over.
>
>The scripting must be installed and not restricted. There is an other way via JScript that you can go.
>
>You can use in REPLACE. And the code also remove TAB characters. (One never know how entered the code.)
>
>I've startet with RegExp blind by some code (message#792332) an have later demystified it. ::) It's worth it.
>
>Agnes
>>Of course, yes that's a typo. (tyop?) It should have been removed there as well.
>>
>>I have not yet had a chance to look at your solution; I've got something to learn about regular expression before I can understand. Can I assume that the CREATEOBJECT line will always work, or must I include something when I install my application to make it work?
>>
>>Jim
>>
>>
>>>James,
>>>
>>>in addition to my former message:
>>>

>>>loRegExp = CREATEOBJECT('VBScript.RegExp')
>>>
>>>
>>>lcUPC=ALLTRIM(cUPC)
>>>
>>>lcTemp = ''
>>>FOR lnloop = LEN(lcUPC)+1 TO 1 STEP -1
>>> lcUPC = STUFF(lcUPC,lnloop,0,'\s*')
>>>ENDFOR &&lnLoop
>>>
>>>loRegExp.PATTERN    = lcUPC
>>>
>>>lcPart = loRegExp.REPLACE(cPart,'')
>>>
>>>

>>>
>>>The only thing not included is:
>>>>Occurs a few times:
>>>>"Big Widget (1 12345 12345 1)" ==> "Big Widget (1 12345 12345 1)"
>>>but this is a typo isn't it?
>>>
>>>Agnes
>>>>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?