Hi, I need to split the content of column.
The content of my columns is for example as follows:
abc, 13, Italy
drto, kl, 15, France
asss, gft, sdt, dtf, Italy
a, Germany
I only need to keep the country.
Can someone show me how to do it?
Many thanks in advance.
Hello @monica_rosciano,
you can use String Manipulation node for this task. If country is always last information and before it you have comma + space then you can choose one of following expressions.
Extract part of string based on last comma found:
substr( $column1$, lastIndexOfChar($column1$, ',') + 2)
Or similar approach only using regular expression:
regexReplace( $column1$, ".*,\\s(.*)" , "$1")
Br,
Ivan
2 Likes
Dear Ivan,
thank you for your suggestion.
1 Like
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.