1 Reply Latest reply on Jun 5, 2014 7:31 AM by Josh Hill

    Unpacking data into multiple fields

      We are populating a custom field with some complex data that tells us a lot about where that lead has come from which populates into MKTO with a + seperating each part of the data so that we can split it out in Excel. The data looks like this:
      Samepage-signup+web-SPIO+organic+SIOB-dac+NA+NA+May 10, 2014

      I want to split some of that information across several MKTO fields and am looking at a smart campaign which looks like this:

      However we would need to use this everywhere we have data entering MKTO and update it everytime we have a new way for leads entering MKTO.

      Is there a logic I could use to automatically unpack the data across the required MKTO fields?