Use Script to Remove all Parts Ending With 'VR'

[oliveton]

Hello,

I want to remove all numbers in my load that end with 'VR' I want to remove the whole number, not just the VR suffix.

I've tried using "where not" (below) and I keep getting an error saying %MahleCram can't be found. But it does not work when I use its previous name XCLEVITEM either.

Does anyone have a solution?

Thank you !!!

[PabloTrevisan]

Hi Natalie,

you can try this function on the code:

where right(%MahleCram,2) <> 'VR'

But in a resident load, in this where clause only XCLEVITEM is valid.

[dapostolopoylos]

Use this:

Where

     not WildMatch(Text(PurgeChar(PurgeChar(XCLEVITEM, ' '), '-')),'*VR')

[oliveton]

Hi Pablo,

I tried this but all my parts that end with "VR" still appear.

Is there something I'm doing wrong ?