Skip to main content
Question

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

  • April 7, 2023
  • 3 replies
  • 5 views

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+58
  • Evangelist
  • 932 replies
  • 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
  • 21 replies
  • April 7, 2023

Perfect! Very easy like that :-)

Thank you.


hkingsbury
Celebrity
Forum|alt.badge.img+63
  • Celebrity
  • 1620 replies
  • April 10, 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

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