Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    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

v-easonf-msft's avatar
v-easonf-msft
Community Support
4 years ago

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