Parse data from the middle of a text string
I am setting up bar coding in an app where I will scan a QR code. The code has the following string of information. I need to put the model number in one field and the serial number in another. I can ...
Forum Discussion
Hi Joey,
I did some experimenting with formula text fields using the Left and Right functions and came up with something that might work for you. It might not be the most elegant solution, but it does work.
The solution utilizes 4 fields including the the field which contains the string we want to parse and 3 other fields to store the parsed values. (You will want to hide the Trimmed Serial String field from end users and exclude it from reports and filtering.)
Create three formula text fields as follows:
I did some experimenting with formula text fields using the Left and Right functions and came up with something that might work for you. It might not be the most elegant solution, but it does work.
The solution utilizes 4 fields including the the field which contains the string we want to parse and 3 other fields to store the parsed values. (You will want to hide the Trimmed Serial String field from end users and exclude it from reports and filtering.)
Create three formula text fields as follows:
- [Model Number] enter this formula: Right([Source String], "=;")
- enter this formula: Left([Source String], "&;")
- [Serial Number] enter this formula: Right(, "=")
That worked, thanks. I will have to develop more "what ifs" for other equipment but this worked for ours.