Using a barcode scanner to enter results in multiple fields
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:
DAAFIRSTNAME MIDDLENAME LASTNAME
DAG123 MAIN STREET
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.