Forum Discussion

DamienJ's avatar
DamienJ
Frequent Visitor
9 years ago
Solved

Removing A Single Character From A String (If It Exists)

Hi   I am populating a dashboard using a third party CSV containing transactional data.  Part of each row of data includes a string referring to what the transaction is, for example:   DIRECT DEB...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi DamienJ,

     

    Based on my test, you should be able to use the formula below to create a new column in your table in your scenario. :smileyhappy:

    Column = SUBSTITUTE(Table1[Column1],"Â","")

    Remark: You'll need to replace Table1[Column1] with your real table name and column name.

     

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi DamienJ,

 

Based on my test, you should be able to use the formula below to create a new column in your table in your scenario. :smileyhappy:

Column = SUBSTITUTE(Table1[Column1],"Â","")

Remark: You'll need to replace Table1[Column1] with your real table name and column name.

 

 

Regards