Skip to main content

Table 1Table 1 

Table 2

Table 2

You could use a string searcher with the following regex

.+(?=\s\()

Which will match everything that occurs before a space and opening bracket


You could use a string searcher with the following regex

.+(?=\s\()

Which will match everything that occurs before a space and opening bracket

Hi @ebygomm thanks for your answer. I used a string searcher with the above regex on my real dataset, but it filtered the data into two ports, those rows contain the regex and rows not contain the regex. However, I used a AttributeSplitter and split the values based on ( character (First part of a parentheses).


Hi @ebygomm thanks for your answer. I used a string searcher with the above regex on my real dataset, but it filtered the data into two ports, those rows contain the regex and rows not contain the regex. However, I used a AttributeSplitter and split the values based on ( character (First part of a parentheses).

After the string searcher you just need to send both matched and unmatched ports to the same place

imageYou could also instead use a StringReplacer and replace everything that occurs from the bracket and beyond with nothing

image


Reply