Hi @msireesha
You would need to adapt the code to your needs - what exactly are you trying to do - what I suggested is to replace the label/column that displays the value with this code that removes the characters.
I'm unsure about your use of setting a variable here, what was the intended purpose? It looks like you are scanning a barcode, but then in your code you are trying to compare whether the scanned barcode value is the same as the cleaned version from the lookup, so your searcitem would end up being a true/false value, not a lookup..
If I were doing this myself I would just change that LookUp you are doing because you are comparing the clean string to the existing value which won't complete a lookup - you need to add a column temporarily to the datasource using the AddColumns function to create a new clean barcode to check, like this:
Set(
searcitem,
LookUp(
AddColumns(
'GLOBUS_APP.T2550_PART_CONTROL_NUMBER',
"cleanBarcode",
Concat(
Split(
C2550_UDI_HRF,
""
),
If(
IsMatch(
Value,
"[A-Za-z0-9]"
),
Value
)
)
),
cleanBarcode = BarcodeScanner2.Text
)
)
