+5
Good day FME'ers,
I have a field containing string values which I would like to split on multiple characters. Each string contains one of more of "and", "&" and "," e.g. WORKSHOP AND PREMISES or SHOP, OFFICE AND PREMISES.
Is there a way to specify multiple characters in the delimiter or string row? The option for conditional values would be ideal here.
Thanks
Best answer by takashi
View original
+17
Hi, firstly replace all the possible delimiters with an identical delimiter string (e.g. "__delim__") using the StringReplacer.
You can then use the AttributeSplitter to split the resulting string using "__delim__" as delimiter string.
+17
Hi, firstly replace all the possible delimiters with an identical delimiter string (e.g. "__delim__") using the StringReplacer.
You can then use the AttributeSplitter to split the resulting string using "__delim__" as delimiter string.
This regex may be better.
\\sAND\\s|&|,
+5
Thanks Takashi, Works a treat. It would still be nice to have this option in a single transformer though. Perhaps a list of values to separate on or a conditional using regex. E.g. IF \\d\\s ELSE ,
+17
Thanks Takashi, Works a treat. It would still be nice to have this option in a single transformer though. Perhaps a list of values to separate on or a conditional using regex. E.g. IF \\d\\s ELSE ,
+3
it is possible to use wordboundaries.
Tcl flavor in fme uses \\y
so \\yAND\\y
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
