Forum Discussion

Uma_Dhandpani's avatar
Uma_Dhandpani
Helper I
6 years ago
Solved

Function to trim the values

Hi, How to trim certain values in given column? For Example, '22305 - Sales and Services' this is my value but I want the report to display as 'Sales and Services'. How to trim certain characters?...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    Uma_Dhandpani ,

     

    You can also click edit queries-> Transform-> Split Column by delimiter and input the custom delimiter "-" like below:

     

     

    Then remove the useless columns in the splited columns:

     

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Uma_Dhandpani's avatar
Uma_Dhandpani
Helper I
6 years ago

Hi,

I have a doubt that whether it is applicable for 'n' number of values and also for autorefresh data

v-yuta-msft's avatar
v-yuta-msft
Community Support
6 years ago

Uma_Dhandpani ,

 

You can also click edit queries-> Transform-> Split Column by delimiter and input the custom delimiter "-" like below:

 

 

Then remove the useless columns in the splited columns:

 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.