cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
satishkumark
Helper I
Helper I

Trim or Remove last Position of a String

Hi All,

I have collection(CatMaster) in that one of the Column(Tool) which is in the form of Table as show in  below Screenshot.

I have extracted table data in the of form String by using Concat Function and displayed into a gallery using Label control.

Collection Table Data:

satishkumark_1-1612789908640.png

 

Formula: Concat(ThisItem.Tool, Value &",") //"Text property of a Label (ToolsLbl) "

Output of Concat Function and displayed in to a label

satishkumark_0-1612789611802.png

Now I need to Remove or Trim Comma(,) at last position of a String and displayed into a same Label.

Any help would be greatly appreciated.

 

Regards,

Satish.

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
JR-BejeweledOne
Super User
Super User

Here is the information you need.   Look in the 'Trimming the End' section

 

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-concatenate



If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.

View solution in original post

satishkumark
Helper I
Helper I

Hi JR,

Thank you very much.

It's Working .

I have used Left  and Concat functions to trim End

Formula: Left( Concat( ThisItem.Tool, Value & ", " ), Len( Concat( ThisItem.Tool, Value & ", " ) ) - 2)

 

Satish

View solution in original post

2 REPLIES 2
JR-BejeweledOne
Super User
Super User

Here is the information you need.   Look in the 'Trimming the End' section

 

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-concatenate



If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.

View solution in original post

satishkumark
Helper I
Helper I

Hi JR,

Thank you very much.

It's Working .

I have used Left  and Concat functions to trim End

Formula: Left( Concat( ThisItem.Tool, Value & ", " ), Len( Concat( ThisItem.Tool, Value & ", " ) ) - 2)

 

Satish

View solution in original post

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (3,103)