Hey I was wondering if it is possible in a data table to trim column row values to the point where everything to the left of the dash is trimmed.
So for example I may have a row like: "First - Blue Bike" and I just want to show Blue Bike
Additionally there are a couple of odd outliers in this dataset that may be tricky like one is similar to something like this: "First - Second - Red Bike" And I just want to show Red Bike
If anyone knows how I can use trim to solve this issue, it would be greatly appreciated.
Solved! Go to Solution.
Hi @bhanney2323
Last(Split("First - Second - Red Bike", " - ")).Result
ref: http://powerappsguide.com/blog/post/text---splitting-text-by-spaces
Hi @bhanney2323
Last(Split("First - Second - Red Bike", " - ")).Result
ref: http://powerappsguide.com/blog/post/text---splitting-text-by-spaces
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
219 | |
211 | |
84 | |
57 | |
36 |