Options

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

User118722User118722 Member Posts: 3 Contributor I
in Help
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! 


Tagged:

Answers

  • Options
    kaymankayman Member Posts: 662 Unicorn
    ^(abcd).*$ and replace with $1
    Read as start from the beginning (^) , grab what you need, ignore everything else till the end ($) 
  • Options
    User118722User118722 Member Posts: 3 Contributor I
    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. 
  • Options
    kaymankayman Member Posts: 662 Unicorn
    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? 
Sign In or Register to comment.