I have a column and I have to remove everything which comes after the last space. below is the example
Input:
name |
Bill, jake USA |
Bob P, Jacob LN |
Smit row, emily TKY |
Right, IAN Uk |
Billy , Bob IND |
Output:
name |
Bill, jake |
Bob P, Jacob |
Smit row, emily |
Right, IAN |
Billy , Bob |
Removed everything after last space
Solved! Go to Solution.
Hi @Sshasnk ,
You can try parsing with regex and using the expression
(.*)\s
Hope that helps,
Angelos