Thread: Text to Columns

I need to create a report that I can automate for daily consumption. Note, I have an equation that returns these URL text in a column (right now it's just pasted into this sample report).

a) http://www.site.com/newuser/vsi/?wsw...n=invitefriend

b) http://www.site.com/newuser/?wtm_sou..._keyword=flirt chat room&wtm_network=Content&wtm_placement=www.fastflirting.com&gclid=CIG9iKyb_58CFQtx5Qodjkyxmg


I'm looking to automatically return them in different columns if they exist.

Source --
a) return text after source= and until & (woom)
b) return the text after wtm_source= and until & (google)

Medium -- same
Campaign -- same

If the link has a /?wtm it will have the following values in it and each will start with wtm.

Adgroup -- return text after wtm_adgroup= and until & (flirtchat)
Keyword
Network
Placement