Xml Parsing

[marco_puccetti]

Hello, i need to access, some XML text fields and get some values from it, is it possible?

If so, how can i do this?

Thanks

Marco

[#2]

I was thinking of the same concept as Peter prior to seeing the file (have been in a meeting the last few hours).  You can create a qvw that reads this file loads jsut the column with the xml and saves the file with just the one column.

You can then re-read the new file containing the single column and specify it contains xml - you could do this in teh same qvw or create another one so you are breaking out your tansformation process in the different qvws

[#3]

when you parse the file and specify exml, it should allow you to reference the specific fields within the laod statement

if you have or can crate a file with just the xml, it would be fairly simple to show

[marco_puccetti]

So is only possible to use string manipulation to get the data.

Thanks

Marco

[martynlloyd]

Yes Marco, there is no "field" type of XML, only a "file" type.

Take your pick from the solutions above.

Regards,

Marty.

[petter]

No it is not only possible to use string manipulation but in some cases it is easier.