cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
beckster87
Frequent Visitor

Check Scan input and delete special characters

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

1 ACCEPTED SOLUTION

Accepted Solutions
Nogueira1306
Super User
Super User

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!

View solution in original post

1 REPLY 1
Nogueira1306
Super User
Super User

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!

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

<
Users online (3,460)