Skip to main content
Solved

Hi experts, I'd like to extract text that is within the brackets or trim characters left of the bracket. The length of characters is varied. e.g C213 (Sturt Hwy) -> Sturt Hwy apprecialte your help

  • September 23, 2020
  • 2 replies
  • 132 views

Hi experts, I'd like to extract text that is within the brackets or trim characters left of the bracket. The length of characters is varied. e.g C213 (Sturt Hwy) -> Sturt Hwy apprecialte your help

Best answer by redgeographics

Assuming it's always a single occurance of a text between brackets you can use a StringReplacer to replace the regex ^.*\\(|\\).*$ with an empty string

Screenshot 2020-09-23 at 09.28.26

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

redgeographics
Celebrity
Forum|alt.badge.img+59
  • Celebrity
  • 3700 replies
  • Best Answer
  • September 23, 2020

Assuming it's always a single occurance of a text between brackets you can use a StringReplacer to replace the regex ^.*\\(|\\).*$ with an empty string

Screenshot 2020-09-23 at 09.28.26


  • Author
  • 6 replies
  • September 23, 2020

Assuming it's always a single occurance of a text between brackets you can use a StringReplacer to replace the regex ^.*\\(|\\).*$ with an empty string

Screenshot 2020-09-23 at 09.28.26

Thanks so much! worked well..............