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 rem...
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
Apologies : by Number of Characters.
Though, confusingly, it adds a step called Split Column By Position
Duh!!!! Thank you. It's a Friday and my brain is giving out on me...I appreciate the help.