Copy link to clipboard
Copied
Hi all,
I have an issue with REGEX on cleansing options:
There is a custom field that concatenate several fields, this text is an example: "XTREM SMOKE - 20X200 cm. BP2020L"
I want to catch the "X" in green but not the red one. I typed: "REGEX:X(?=\d)= x ;" the expected output was: "XTREM SMOKE - 20 x 200 cm. BP2020L" but is catching nothing.
I've tried other regular expressions and I realized that the character classes and the look ahead/behind constructions are not working.
Any idea?
PS: on InDesign find/replace the expression is working. Only fails for the Cleansing options on EasyCatalog.
Copy link to clipboard
Copied
You should ask the EasyCatalog people.
Copy link to clipboard
Copied
Hi Jose,
When using EasyCatalog cleansing options, you have to remember when you are using "=", its the point where you are saying I want something changed to something else.
eg. green=red
In this instance, the cleansing option in EasyCatalog would change the word green to red anywhere in the data.
What if the data had green=cool as text and you wanted to change that to just say red?
green=cool=red will not work.
So Easycatalog wants you to use "==" so it knows where something is been changed to something else.
green==cool=red will work.
Now to your problem if you haven't guessed at all....
REGEX:X(?=\d)= x ; should be REGEX:X(?==\d)= x ;
Hope that helps.
You can find more information about REGEX/REGEXV2 at my EasyCatalog Support Site.
https://cunka.com/easycatalog/myEasyCatalog.html#_using_regular_expressions
Cheers
Brian
Get ready! An upgraded Adobe Community experience is coming in January.
Learn more