Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !!!
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.
Use this:
Where
not WildMatch(Text(PurgeChar(PurgeChar(XCLEVITEM, ' '), '-')),'*VR')
Hi Pablo,
I tried this but all my parts that end with "VR" still appear.
Is there something I'm doing wrong ?