Dynamically Changing Text Multiple Times Within Same String

KieranRidge

Hi all,

I usually try to figure these things out on my own, but I'm a little stumped on this one.

I'm looking to change the string below:

<SummarizeField field="Campaign" action="GroupBy" rename="Dimension" />
<SummarizeField field="Site" action="GroupBy" rename="Dimension" />
<SummarizeField field="Device Type" action="GroupBy" rename="Dimension" />

to

<SummarizeField field="Campaign" action="GroupBy" rename="Campaign" />
<SummarizeField field="Site" action="GroupBy" rename="Site" />
<SummarizeField field="Device Type" action="GroupBy" rename="Device Type" />

Basically, on each line, the rename portion will be changed from Dimension to its respective line's field portion (Campaign on first line, etc.).

On each line, I'd have to replace the string Dimension to whatever the text is in between 'field="' and the following double quotation mark after the next string, so that the first line would replace Dimension with Campaign, etc.

This possibly reguires some Regex and searching for particular strings to find which text within the greater text we are using to replace. I'm looking to solve this via a basic Formula tool because this is only one component of a greater task of dynamically rewriting XML code in the Summarize portion of a macro.

Looking forward to being educated by the brilliant people who reply to this.

Thanks,

Kieran

jdunkerley79

Ok so REGEX is your friend for this one:

REGEX_Replace([#1], "([^+]+)\+?", '<SummarizeField field="$1" action="GroupBy" rename="$1" />\r\n')

This will match each variable in you '+' separated list into the $1 variable. It can then construct the XML you need.

The result for your test is:

<SummarizeField field="Campaign" action="GroupBy" rename="Campaign" />
<SummarizeField field="Site" action="GroupBy" rename="Site" />
<SummarizeField field="Device Type" action="GroupBy" rename="Device Type" />

RenameExampleTest.yxmd