AnsweredAssumed Answered

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

Question asked by GeoffreyMartin on May 29, 2013
Latest reply on May 31, 2013 by philmodjunk

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?

      

      

Outcomes