Forum Discussion
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?
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.
4 Replies
Hello Uma_Dhandpani ,
you go to the query editor and use the "add column by example feature".
In the new column you write our desired output - the tool will figure out what you want.
Please mark my post as the solution and share some kudos if it was helpful.
Hi,
I have a doubt that whether it is applicable for 'n' number of values and also for autorefresh data
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.
