XML quote remove

[shrey3a]

Hi,

I'm getting the row wise i/p as XML string

<main><a>ABC </a><b>DEF</b> </main>
<main><a>GHI</a><b>JKL</b> </main>

need to break in to format as below

ABC DEF
GHI JKL

Basically to remove the XML embedding i.e. <> </>


Regards,
Munish

[Sainath.Srinivasan]

2 Options
1.) Describe the whole record as one field and perform operations to extract the required area - something like
Field(Field(Full_Record,'>', 2), '<', 1)
2.) Use XML Reader to to scan through the messages and produce the data.