How to remove characters from end of string using regular expression within Replace operator?
User118722
New Altair Community Member
Hi,
I'm trying to remove certain characters from the end of string in a text field using Replace operator, for example,
Current value: abcd(xxx)
Desired value: abcd
In the replace operator, I use the following regular expression to locate strings end with (xxx), but what should I put in as Replacement?
(.*)(?:abc)(.*)
Thank you!
I'm trying to remove certain characters from the end of string in a text field using Replace operator, for example,
Current value: abcd(xxx)
Desired value: abcd
In the replace operator, I use the following regular expression to locate strings end with (xxx), but what should I put in as Replacement?
(.*)(?:abc)(.*)
Thank you!
1
Answers
-
^(abcd).*$ and replace with $1
Read as start from the beginning (^) , grab what you need, ignore everything else till the end ($)3 -
This solution did not work for me. And sorry I wasn't clear on my example. Current value is a not a fixed string - it may contain all kinds of combinations with characters, space and/or symbols, the characters I would like to get rid of is a fixed set of characters within in parenthesis, which always show up at the end of current value. My desired value would be the current value excluding the parenthesis and the content in it.1
-
So like your original regex then? You just need to replace with $1$2 then, this would strip your ABC.
But your example is very confusing so I may misunderstand you. Do you have a more real live example?1
