Forum Discussion
Removing a character from a column using M
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?
Hi, Anonymous
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
4 Replies
You can split by delimiter (by position) - right-click the column and look for Split Column
Apologies : by Number of Characters.
Though, confusingly, it adds a step called Split Column By Position
Hi, Anonymous
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
