Paarse

[Simon1187]

Hi everyone!

I am trying to get the last part after the last space. Could you please help me with that? 

Thanks, Simon

[MarqueeCrew · Accepted solution]

@Simon1187 ,

 you might want to play with a regular expression.  But I'll show you another way.  

countwords([field]) will get you the number of words.  If you subtract one from that result you can get the last word as:

 getword(countwords([field])-1)

 or 

regex_replace([field],".*\s(.*)",'$1')

 cheers,

 mark