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
>>
>>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?
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]