I am having values like
xyz abc 123
jkl uio opop 345
wer opl A0123
Now, I want to display the values
in another column.
Can anyone help me in doing this.
I tried using String manipulation with “lastIndexOf” and it is getting the number. But I need to last string
I also tried to cut the string from Right using space but unable to find it out.
I would appreciate the help on this
This expression in String Manipulation node would do what you’re looking for:
regexReplace($column1$, ".* ", "")
$[Column]$.substring($[Column]$.lastIndexOf(" ")+1) should return what you expected.
Hi, This expression works perfectly. At the same time, I also want to have text values in another column i.e.,
jkl uio opop
could you also help me where can I find these regex expressions to write?
To have both parts in separated columns, use Regex Split and input this pattern:
(.*(?= .*$))(?: )(.*)
EDITED: The previous pattern
had a problem: The first group had a space at the end. Now the space which separates the first part and the second part (the last space) will not be caught.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.