Table 1
Table 2
Solved
Hello, Can please someone let me know how to remove all extra characters form values in column. More specifically how I can get Table two from Table 1. FYI, I am using FME2022.
Best answer by ebygomm
jkh wrote:
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
+39- Influencer
You could use a string searcher with the following regex
.+(?=\s\()Which will match everything that occurs before a space and opening bracket
ebygomm wrote:
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).
+39- Influencer
- Best Answer
jkh wrote:
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
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.