idea Parsing variable length text strings from barcode data in ArcGIS Survey123 Ideas

Parsing variable length text strings from barcode data

RebeccaFuda — Fri, 01 Dec 2017 19:44:12 GMT

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.

Re: Parsing variable length text strings from barcode data

ScottPrindle — Mon, 26 Feb 2018 19:23:34 GMT

Hello Rebecca,

Thank you for submitting this idea! It is currently Under Consideration to possibly be included in a future release.

Others,

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.

Thanks,

Scott

Re: Parsing variable length text strings from barcode data

IsmaelChivite — Tue, 14 Aug 2018 15:00:22 GMT

This functionality is ready for testing now in the Survey123 Early Adopter Program. Specifically look for the Custom pulldata() JavaScript Functions announcement. Essentially, you can pass your barcode string into your own JavaScript function and then output the parsed string so you can use that in a calculation.

Re: Parsing variable length text strings from barcode data

JoeFlannery — Mon, 20 Aug 2018 20:54:49 GMT

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"

Re: Parsing variable length text strings from barcode data - Status changed to: Implemented

JamesTedrick — Fri, 26 Mar 2021 20:12:27 GMT

To note, custom JavaScript functions (which would allow for the text parsing described) were released in the 3.10 release