I would like to be able to take data from a bar code or QR code and split it up to populate multiple fields in a survey. For example, QR codes on hunting licenses contain info on hunter first and last name and license #.
1798765432139 4ELWYOMING SPORTSMAN 112345678910
The information I would need to extract is the first 11 characters, which is the license # (17987654321), the following two characters are the hunt area (39), first name is Wyoming and last name is Sportsman.
I understand that I can use the substr() function to extract text at known positions, but this would not be sufficient to extract hunter names. It would be great to have more flexibility for extracting text, similar to how text can be extracted in Excel using the functions such as FIND, LEFT, RIGHT, MID, etc.
Thank you for submitting this idea! It is currently Under Consideration to possibly be included in a future release.
When voting for this idea, please consider leaving a comment to share your perspectives on it. We would like to know what other projects or workflows this functionality would improve.
I would like this capability for parsing an email address of the survey form users.
Parse the first name and last name from:
John.Doe @ domain.com
to "John Doe"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.