Check Scan input and delete special characters

[beckster87]

Hi, everyone,

I have a problem that I can't get any further. I have a form where you can enter the text manually as well as using the scan function can enter. When scanning the barcode, I always get a special character ($) as the first character. Now I want a function that checks when entering text (Scan Value) whether the first character is a special character ($) If yes (true), the special character should be deleted.

This is the formula I use to transfer the scan value to the input field:

If(
!IsBlank(BarcodeScanner3.Value);
BarcodeScanner3.Value;
Parent.Default
)
I Hope someone can help me

[Nogueira1306 · Accepted solution]

If(
!IsBlank(BarcodeScanner3.Value);
Substitute(BarcodeScanner3.Value,"$","");
Parent.Default
)

https://docs.microsoft.com/pt-pt/powerapps/maker/canvas-apps/functions/function-replace-substitute

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

My website!