Extract Text from an imported Field to other fields...
I have a field that I am importing from another sql database that is called 'plan'. Within this field is a string that varies in length, but the structure is the same.
Here's an example:
Each break (except for the last one) ends in a brace (}). Within that the values that are there are separated by a pipe. I would like to try to extract each packet (ending in the brace) into separate fields. Like this:
I've thought about creating multiple fields that extract the 1st, 2nd, 3rd, et al.
Is there a better way to do this?