How to separate the XML data in particular field

[Anonymous]

Hi All,

  I have field called  Information in the database and in that field the XML Data are load, Now i want to separate  the XML data in the field information.

EX  XML Data: name ; address, city, state in the Field (Information) in the  database. can nay one help on this.

Thanks & regards,

Sivakumar

[Gysbert_Wassenaar · Accepted solution]

Perhaps you can use the FROM_FIELD load option. See this discussion: Re: Re: How to extract data from xml stored in a database. If you don't manage to get that working you may have to use the textbetween() function. See xml data handling with from_field

[ashfaq_haseeb]

Hi,

have a look at attached application.

Regards

ASHFAQ