web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Trimming column rows w...

Power Apps

Answered

Trimming column rows where there is a dash

(0) Share

Report

Report

Posted on by bhanney2323

237

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.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @bhanney2323

Last(Split("First - Second - Red Bike", " - ")).Result

ref: http://powerappsguide.com/blog/post/text---splitting-text-by-spaces

Was this reply helpful? Yes No

Join the conversation