4 Replies Latest reply on May 31, 2013 7:13 AM by philmodjunk

    Extract Text from an imported Field to other fields...

    GeoffreyMartin

      Title

      Extract Text from an imported Field to other fields...

      Post

           Hello,

           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:

           25J|N|2|412|2|494}A13|N|1|413}A15|N|2|415}BOF|N|2|416}A17|N|1|417}A18|N|1|418}A20|N|1|420}M30|N|1|SDMA}MA|N|1|MA1|1|MA5|1|MA4

           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:

           25J|N|2|412|2|494

           A13|N|1|413

           A15|N|2|415

           BOF|N|2|416

           A17|N|1|417

           A18|N|1|418

           A20|N|1|420

           M30|N|1|SDMA

           MA|N|1|MA1|1|MA5|1|MA4

           I've thought about creating multiple fields that extract the 1st, 2nd, 3rd, et al.  

           Is there a better way to do this?