Removing a character from a column using M

[water-guy-5]

Here I have rainfall data. Sometimes the precipitation will have an "s" at the end of the value which is preventing me from converting the column to value type. Is there any function I can use to remove these. 

Info that might help:
- the max number of characters in the column is 4 (well besides the ones with 's'). So it's NUMBER, DECIMAL, NUMBER, NUMBER and sometimes "s". Is there some sort of way to just say shorten the column from left to right and make it 4 characters? Can I split it by a delimiter? 

[v-easonf-msft · Accepted solution]

Hi, @water-guy-5 

Instead of splitting it by number of Characters, you can also try replacing all 's' characters with '' characters in the column to removing the character 's'.

Best Regards,
Community Support Team _ Eason

[HotChilli]

Apologies : by Number of Characters.

Though, confusingly, it adds a step called Split Column By Position

[water-guy-5]

Duh!!!! Thank you. It's a Friday and my brain is giving out on me...I appreciate the help.

[HotChilli]

You can split by delimiter (by position) - right-click the column and look for Split Column