1 Reply Latest reply on Dec 23, 2011 10:21 AM by philmodjunk

    Using a barcode scanner to enter results in multiple fields

    MatthewKerns

      Title

      Using a barcode scanner to enter results in multiple fields

      Post

      I am trying to use a barcode scanner within Filemaker Pro to enter various pieces of information into various fields.

       

      When I scan the 2d barcode on the back of a customer's liscence, the resulting text dump looks like this:

       

      @

      ANSI 6360530102DL00390188ZT02270017DLDAQ051278739
      DAAFIRSTNAME MIDDLENAME LASTNAME
      DAG123 MAIN STREET
      DAH
      DAICHATTANOOGA
      DAJTN
      DAK37404
      DARID
      DAS
      DAT
      DBA20150221
      DBB19550221
      DBC1
      DBD20090406
      DBHN
      DBKON FILE
      DAU600
      DAYBRO
      DBG

      ZTZTA5600109096

       

      I know what most of this would correspond to in my database, but I have no idea how to parse ou the info I need to various fields.  For instance, how do I take DBB19550221 and add that to the customer_birthday field on the customer table?

       

      Thanks in advance for any advice.