Parsing variable length text strings from barcode data

Idea created by beckyfuda on Dec 1, 2017
    Under Consideration
    Score40
    • jung.kim@dec.ny.gov_nysdec
    • mingzhang
    • beckyfuda
    • jrflannery

    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.