XML PArse

[shrey3a]

Gurus,

Initially we were getting the XML string in below format <msg><trans><updateRow>
<col name=" SAMPLE "><char>232100905></char></col>
<col name=" ID_NO "><char>232100905></char></col>
</updateRow></trans></msg>

and I was able to parse it correctly by below method

/msg/trans/updateRow/col[@name='SAMPLE']/*/text()
/msg/trans/updateRow/col[@name='ID_NO']/*/text()

Now the message format is changed to

<msg><trans><updateRow>
<col name=" SAMPLE "><char><afterVal>232100905></afterVal></char></col>
<col name=" ID_NO "><char><afterVal>232100905></afterVal></char></col>
</updateRow></trans></msg>

I tried the below options to parse but nothing works

/msg/trans/updateRow/col[@name='SAMPLE']/afterVal/*/text()
/msg/trans/updateRow/col[@name='SAMPLE']/afterVal/text()
/msg/trans/updateRow/col[@name='SAMPLE']/char/afterVal/*/text()
/msg/trans/updateRow/col[@name='SOCIAL_SECURITY_NR'/SAMPLE]/*/text()

I tried all options as above....

Regards,

[belaruska]

can you tell which solution worked for you?

[eostic]

This looks like Event Publisher XML..... the char element is missing from two of the xpaths, and where it's included, there's an extra *...

This should have worked:

/msg/trans/updateRow/col[@name='SAMPLE']/char/afterVal/text()

Ernie