Skip to main content
Question

Parse data from the middle of a text string

  • June 20, 2019
  • 0 replies
  • 79 views
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 get part of this to work but sure there may be a better way.

Here is the text string from the scan and is always the same for our equipment. I will probably have to setup some other rules for other vendors. I am using an Equipment Manufacturer drop down so I will be able to use that as a trigger for future rules as this expands and I test other bar codes.

https://qr.hussmann.com?serialNumber=MY18D023685&modelNumber=IM4SL12

      Forum|alt.badge.img+2
      • JeffRichey
      • Registered
      • June 20, 2019
      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:

      1. [Model Number]  enter this formula: Right([Source String], "=;")
      2. enter this formula: Left([Source String], "&;")
      3. [Serial Number] enter this formula: Right(, "=")


      Terms & ConditionsAccessibility statement