Column expression - Extract from right side

[rsamec]

Hi, one little problem

In column expression node, i would like to extract all text from the right side of string until first blank space!

Can someone help mi with that! Is it “right” or “substr” or some combination

Thanks

[yogesh_nawale]

Hello @rsamec,

Can you provide some sort of demo example and the expected output?

Thanks

[gonhaddock]

Hello @rsamec
You can test with the following code; you will get the remaining characters beyond the last occurrence of a space character:

regexReplace(stripEnd(column("text")), ".*\\s+(.*)", "$1")

BR

[yogesh_nawale]

Hello @rsamec,

If you are looking to get right side characters from last occurrence of a space character then there are multiple ways

1. Using right()

2. Using substr()

You will get output as follows

Regards, Yogesh

[rsamec]

I used this code and it works thank you

[yogesh_nawale]

hey @rsamec, it is same as i did above.
If you can mark it as solution so that if anyone searches it in future, it will be visible.

Thanks and have a good day.

[rsamec]

Yes yes i know…I used your solution i will mark now