How to detete ending blanks in a column

[joangarcia]

I need substitute blanks by "" (nothing), but only at the end of the field "client"

If I use <replace Values> "  " by "" It removes blanks between words too.

Any idea please?

[v-yuta-msft · Accepted solution]

Hi joangarcia,

Click Query Editor-> Add Column-> Custom Column, then input M code below:

[Custom] = each if [Column1] = "client " then "client" else [Column1]

 

Regards,

Jimmy Tao