Table 1
Table 2
Table 1
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
You could also instead use a StringReplacer and replace everything that occurs from the bracket and beyond with nothing