Unanswered

Remove all commas at the end of string.

(0) Share

Report

Posted on by colbyturybury

363

I know of TrimEnds but it appears to only work with blank spaces. Is there a way dynamically remove commas a the end of a string whether that be 1, 2, 3, 50 commas?

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

WarrenBelz 153,034 Most Valuable Professional on at

Like (1)

Report
Hi @colbyturybury ,

For all commas

Substitute( YourString, ",", "" )

or for at the end

If( Right(YourString,1) = ",", Left( YourString, Len(YourString) - 1 ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
colbyturybury 363 on at

Like (0)

Report

The number of characters would need to be dynamic. Sometime there could be 1 comma other times there could be 5 commas

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report
@colbyturybury ,

You would need to hard-code to the maximum expected

If( Right( YourString, 5 ) = ",,,,,", Left( YourString, Len(YourString) - 5 ), Right( YourString, 4 ) = ",,,,", Left( YourString, Len(YourString) - 4 ), Right( YourString, 3 ) = ",,,,", Left( YourString, Len(YourString) - 3 ), Right( YourString, 2 ) = ",,", Left( YourString, Len(YourString) - 2 ), Right( YourString, 1 ) = ",", Left( YourString, Len(YourString) - 1 ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
colbyturybury 363 on at

Like (0)

Report

Could this be simplified with a "With" statement?

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

@colbyturybury ,

With does nothing more than set a Temporary Variable - not relevant here. I actually tried a ForAll(Sequence()), but it was not suitable for the task.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report
@colbyturybury ,

OK - went another direction - this should work

First( Filter( ForAll( Sequence( Len(YourString), 0 ), Left( YourString.Text, Len(YourString) - Value ) ), !(EndsWith( Value, "," )) ) ).Value

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
colbyturybury 363 on at

Like (0)

Report

Just what I needed. I never would have figured this out. Thank you so much for your help!!!

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

@colbyturybury ,

Gald to help - if you have not already, take a moment to understand what is happening with the code - it will help you understand (in particular) what ForAll() does (which is not a loop like most people believe)

Was this reply helpful? Yes No