Exporting XML Fields

sagil23995776

27-08-2017

Hi,

Is it possible by any way to export an XML field value to a .csv through a workflow?

for example if I wish to export emails subject lines to a file.

Thanks,

Sagi

View Entire Topic

sagil23995776

28-08-2017

Hi,

At the end I've managed to get the subject line into a variable by doing this:

instance.vars.subjLine = sqlGetString("select substring(dl.mdata,position('<subject><![CDATA[' in dl.mdata)+18,position(']]></subject>' in dl.mdata)-position('<subject><![CDATA[' in dl.mdata)-18 ) from nmsdelivery dl where sInternalName='DM12345'")

So now I can write it into a file.

Thanks,

Sagi