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.
Get Value ( textfield ; 12 ) returns the 12 line of text, assuming youhave returns after each line as is likely here.
Let ( DBB = Right ( Get Value ( textfield ; 12 ) ; 8 ) ;
Date ( Middle ( DBB ; 5 ; 2 ) ; Right ( DBB ; 2 ) ; Left ( DBB ; 4 ) )