Answered

Drop Meaningless Characters from BarCode Reader

(0) Share

Report

Posted on by bgeorge76

I have an app that I've been working on enhancing with the ability to use the Barcode Reader to read product numbers and enter them in to a text input field. I have the basics of this function working by assigning the following:

barCoilID: OnScan.Set(varCoilID, First(barCoilID.Barcodes).Value)
TextInput: Default.If(varCoilID = "", Parent.Default, varCoilID) (the text input will only accept numbers)

This works as intended however, our computer system puts a leading "s" in the barcode, which means nothing to our users. The product ID as a format of ######. I can use a Right(varCoilID, 6) in the Default property but I've found a few products that only have 5 digits. It's rare for that to happen, but I want to take as much error out of this as possible.

Does anyone know a way to just drop the "s" from the scan without using a Right Function? I've tried using a Substitute function (Substitute(varCoilID, "s", "") in both the OnScan and Default properties and it doesn't seem to work. Any ideas would be greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @bgeorge76,

The Substitute function should work - please keep in mind that this is case sensitive and will remove all occurrences within the scanned value.

//Barcode reader OnScan Set( varCoilID, Substitute( First(Self.Barcodes).Value, //Make sure this is the correct case "s", "" ) )

Alternatively you could use the following when s can occur multiple times but only the first one needs to be removed.

Set( varCoilID, With( { wBarCode: First(Self.Barcodes).Value }, Right( wBarCode, //Should s always occur as a prefix, replace the Find() function with 1 Len(wBarCode) - Find("s", wBarCode) ) ) )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
bgeorge76 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Both of those looked promising, but neither worked. Both returned errors of unexpected values.

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@bgeorge76 my apologies, I had 1 closing bracket too many.

I adjusted my initial comment accordingly. Would it be possible to try again?

Was this reply helpful? Yes No
bgeorge76 14 on at

Like
a
(0)

Report
Copy link

Link copied!

I just found the same thing. Tried both routines and got the same error that s##### could not be converted to a number.

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@bgeorge76 I am unfortunately not able to recreate that error. Where does this error exactly occur since we don't do any numeric conversions in the code mentioned above?

Was this reply helpful? Yes No
bgeorge76 14 on at

Like
a
(1)

Report
Copy link

Link copied!

Nevermind, I found the issue. It was a case sensitive error on my part. The barcode was returning a uppercase S, not a lowercase and I overlooked it. Your first example works perfectly. Thank you so much!

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

That indeed explains the error, thanks for the update!

Glad I was able to help! 😊

Was this reply helpful? Yes No