XML Parsing issue in splunk and needs to correlate the events

[amarababu_katar]

Hi Team,

Huge XML files are loading into Splunk and based on the xml we needs to fetch the number values and sum it display in splunk dashboard.
From the screen shot each line treated as one event in splunk and from those events i needs to extract name field and extracting number which is before the japan word(which is in light greeen color).
i'm not able to correlate noted screen shot, please help how to extract and correlate the events from the screen shot.

i'm attaching xml splunk event screen shot.

[to4kawa]

サニタイズしたログの提示をお願いします。

Please provide sanitized logs.