I want to search by extracting only a part of the scanned text string

I have a column in my table with a unique code value of 8 digits.
However, when I scan the QR code, it scans with a longer string.
The string I’m looking for is part of the scanned string (8 digits).
Is there a way to extract the scanned value and find one that matches the value in my column?
Thank you.

Worth visiting another post recently thrown by other member.


Thank you for your answer.
I analyzed your sample app and solved the problem!!