Solved: Re: Strip characters from a text input that is com...

Danny_L · ‎04-22-2021

I have two labels that I need to compare. We want to make sure the manufacturing part number on our internal label matches the manufacturing part number provided by the manufacturer. Our QR code on our internal label doesn't just contain the manufacturer part number which is my issue. It contains 8 pieces of information all comma separated. I know that what i'm looking for is always going to be after the 4th comma in the string. Is there a way to extract that info so I can do a comparison of that to the label provided by the manufacturer??

RandyHayes · ‎04-22-2021

@Danny_L

The following will give you the 4th element:

Last(FirstN(Split(yourScannedValue, ","), 4)).Result

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes
Really want to show your appreciation? Buy Me A Cup Of Coffee!

View solution in original post

RandyHayes · ‎04-22-2021

@Danny_L

The following will give you the 4th element:

Last(FirstN(Split(yourScannedValue, ","), 4)).Result

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes
Really want to show your appreciation? Buy Me A Cup Of Coffee!

Danny_L · ‎04-22-2021

Genius, it worked. Thanks!

Strip characters from a text input that is comma separated

Helpful resources

Welcome Super Users

Join us for Microsoft Power Platform Conference