Unpacking data into multiple fields

[Anonymous]

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?

[Josh_Hill13]

Yes, you would have to keep this list updated with each new camaign value.

Alternatively, why not let the URL parameters and forms auto populate this for you?