Skip to main content
Question

How can I substract the strings, including column names, I need from one cell?


Forum|alt.badge.img

The data that I have is like the following:

image 

I would like to substract the information within the brackets, so I get the following result:

image.png 

Can anyone help me how I can achieve this within my workbench?

3 replies

geomancer
Evangelist
Forum|alt.badge.img+50
  • Evangelist
  • April 7, 2023

Update: You don't even need to add the HTML tags, using the HTMLExtractor on the original data is enough!

Without_HTML_tagsOriginal answer: One very quick way: enclose the value of REMARK in HTML tags, and use HTMLExtractor.

HTML_tags


Forum|alt.badge.img
  • Author
  • April 7, 2023

Perfect! Very easy like that :-)

Thank you.


hkingsbury
Celebrity
Forum|alt.badge.img+55
  • Celebrity
  • April 10, 2023
geomancer wrote:

Update: You don't even need to add the HTML tags, using the HTMLExtractor on the original data is enough!

Without_HTML_tagsOriginal answer: One very quick way: enclose the value of REMARK in HTML tags, and use HTMLExtractor.

HTML_tags

Thats a great solution, I was thinking StringSearchers with some Regex but this is much cleaner!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings