Forum Discussion

Deleted's avatar
Deleted
May 08, 2020

Barcode Scanner data entry

Good afternoon, I am attempting to use a Zebra bar-code scanner to use for data entry. I need to separate and remove some information that the scanner adds into the information.   the tag will sca...
excel
Formulas and Functions
mtarler's avatar
mtarler
Silver Contributor
May 08, 2020

maybe it was a cut and paste error but this formula isn't correct:
=MID(A2,FIND("P",A2,1),FIND(10,A2)-FIND("P"A2,))
maybe try:
=MID(A2,FIND("P",A2,1),FIND("10",A2)-FIND("P",A2,1))

 

btw, if you know it will always scan in starting as 240P then why not replace all the FIND("P"... with a fix number?

    • mtarler's avatar
      mtarler
      Silver Contributor
      May 08, 2020

      oh wait, if you know that the part after the "10" is 7 digits long (based on the 2nd formula) then you can use:
      =iferror(MID(A2,FIND("P",B2,1),LEN(B2)-8-FIND("P",B2,1)),"")
      that said I see line 14 doesn't have a "P". was that a mistake or another problem to deal with?

       

      and if you can't assume "10" is followed by 7 digits then you can use:

      =IFERROR(MID(B2,FIND("P",B2,1),FIND("10",B2,FIND("-",B2))-FIND("P",B2,1)),"")

      • Deleted's avatar
        Deleted
        May 11, 2020

        good afternoon all,

        =MID(A3,4,FIND("10",A3,FIND("-", A3))-4) is what I have inputted and seems to work with the variations of number combinations that I will be imputing. Thanks to everyone for the help!! I really appreciate it! mtarler wsantos 

         

        I will be saving these for other references! I know they will come in handy. 

  • Deleted's avatar
    Deleted
    May 08, 2020

    mtarler 

     

    Hi Matt,

    That worked partially, but it is still not giving the response that I am looking for. I have attached the spreadsheet with test data. I am not sure if I can do fixed number because the information varies so much. Do you have any thoughts on improving? 

Resources