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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

Top Solution Authors
Top Kudoed Authors
Users online (85,554)