AnsweredAssumed Answered

Using a barcode scanner to enter results in multiple fields

Question asked by MatthewKerns on Dec 23, 2011
Latest reply on Dec 23, 2011 by philmodjunk

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.

Outcomes