I have created a regular expression such that anything containing the text "self employed" is replace by Self Employed, stripping out extraneous data
eg self employed artist becomes Self Employed
What I now need is an expression that makes anything not containing "self employed" is replaced by blank
Additionally I need to do this for other strings, such as "self-employed" and "freelance". I can do the first part by adding to the values to match on, but would also need to add to the not containing as an AND
Thanks folks
1 Comment
W
Wayne Pozzar
said
over 7 years ago
Dictionaries are run in order so first you should replace the ones you want with Self Employed and then replace anything that is NOT Self Employed with BLANK
Replacement Value: Self Employed Value to Match: .*self employed.*
Replacement Value: -BLANK- Value to Match: ^(?!(Self Employed)$).*
Mark Lay
Hi,
I have created a regular expression such that anything containing the text "self employed" is replace by Self Employed, stripping out extraneous data
eg self employed artist becomes Self Employed
What I now need is an expression that makes anything not containing "self employed" is replaced by blank
Additionally I need to do this for other strings, such as "self-employed" and "freelance". I can do the first part by adding to the values to match on, but would also need to add to the not containing as an AND
Thanks folks