For example, I have a Parent table that uses a combined text summary field for Tracking #'s of shipping crates. I want to be able to have a formula field on the parent record that will take one of the tracking #'s from the combined text field (preferably the last value added) and use that in a URL formula field to plug into the UPS,etc. tracking page.
It would be nice if the various shipping companies would take multiple comma-separated tracking numbers at once but some do and some don't so I need to limit it to just one.
Note: I have a tracking button already on each child record but I have been instructed that we need to be able to track at least one of the tracking numbers (most of the time there is only one anyways) from the parent record. Also, the length of the individual values may vary depending on the carrier company so I can't use Right(), Left(), etc. with a static length.
Example combined text field: {P2626, P3737, P9876}
Fomula field, needed value: P2626
