Thanks So much for your help , the above solution works perfectly ,
similarly i have another content in XML , where one of its attribute has value in below format
subparty = [{"name":"SUKUNIMI -11073533 ETUNIMI -11073533","id":"300576-456P","Code":"507808;test bank1","bNumber":"234234234234"},{"name":"TESTIYKS ACECGGHD","id":"010140-463P","Code":"529108;test bank2","bNumber":"324234234234"},{"name":"ARAHPE AÄLKOSKEÅÅÅ","id":"010153-111P","Code":"512404;test bank3","bNumber":"234234234234"}]
i would like to count all the subparty ,in above example we have 4 subparty
and i need to store the values in a table with different columns like as below
name1=SUKUNIMI -11073533 ETUNIMI -11073533
id1=300576-456P
Code1=507808;test bank1
bNumber1=234234234234
name2=TESTIYKS ACECGGHD
id2=010140-463P
Code1=529108;test bank2
bNumber2=324234234234
and so on ...
... View more