Question

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

The data that I have is like the following:

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

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

Userlevel 4

+36

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

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

HTML_tags

Perfect! Very easy like that :-)

Thank you.

Userlevel 5

+29

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

Without_HTML_tags Original 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!

Sign up