Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

How to remove characters from end of string using regular expression within Replace operator?

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!

Find more posts tagged with

AI Studio

RegEx

Replace

Accepted answers

All comments

kayman

^(abcd).*$ and replace with $1
Read as start from the beginning (^) , grab what you need, ignore everything else till the end ($)

User118722

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.

kayman

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?