scan and search only a part of the barcode

[BUWANEKA]

hi, there is a 33 digits barcode in printed material. data base has  first 18 digits only. I need to scan barcode and search from database with ignoring last 15 digits.  

eg-

Bar code = 010503238401995317240621104456480  last 15 digits are variables, I only have first 18 digits in my database(eg- 010503238401995317), with scanning full 33 digits barcode need to find data from database, without considering last 15 digits

need help thanks 

[lynchk21]

Create a virtual column that equals to LEFT([_thisRow].[Scanned Column],18) and then use that column to search the database

[BUWANEKA]

hi, thanks for supporting me,  

33 digit barcodes coming as printed material, my app is a data searching app, need to scan barcode and get some relevant data through my app. need to ignore last 15 digits at printed barcode.

[lynchk21]

Yes. So have your column used for scanning. Have a virtual column that gets the left 18 digits from the scanned column. LEFT([_thisRow].[Scanned Column],18). Then use the virtual column that have the 18 digits to get the relevant data from the app

[BUWANEKA]

Thank for help me, 

this is my interface

 when I scan my barcode to searching area ,it does not search because it has 33 digits, as below screen shot 

after I removing last 15 digits , it can search as below,

I think you can understand my problem and help me to sort out it,

thanks

[lynchk21]

I do not believe you can alter the search bar to accomplish what you need.

A workaround would be to create a table with a scan column, then have a virtual column LEFT([_thisRow].[Scanned Column],18) to get the 18 digit code, and then use a LINKTOROW() or LINKTOFILTEREDVIEW() to pull up the appropriate product.