Forum Discussion

Uma_Dhandpani's avatar
Uma_Dhandpani
Helper I
7 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
7 years ago

Hi,

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

JosefPrakljacic's avatar
JosefPrakljacic
Solution Sage
7 years ago

I need to tell you that I use this for N number of values and for autorefreshed data :smileyhappy:

But I don't know your data so you maybe right but in my experience this worked -> since this feature is just "guessing" the right function based on your input