Remove everything after last space

[Sshasnk]

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

[AngelosPachis · Accepted solution]

Hi @Sshasnk ,

You can try parsing with regex and using the expression

(.*)\s

Hope that helps,

Angelos