Parsing XML

Tommy_Alterax

Hi Guys,

I am parsing XML data however, out of approximately 2.1Mill rows of data around 147k rows are blank for the variable I am looking to Parse. No idea why.

When I take this down to 1 trade and look at it individually , the data I need is there but comes out as a Blank . I am not sure what is different  -

Here is an example of my XML and I am looking for the value after SpotWholesale (4th line down below) i.e 22329 --- Is it possible to extract this using regex ? 

><SpotWholesale xmlns="RateCompositionInfo"><Value>22329</Value><State>Entered</State><CalculationMethod xsi:nil="true" /></SpotWholesale><SpotMarkup xmlns="RateCompositionInfo"><Value>0</Value><State>Calculated</State><CalculationMethod>SpotValues</CalculationMethod></SpotMarkup><SpotQuote xmlns="RateCompositionInfo"><Value>22429</Value><State>Entered</State><CalculationMethod xsi:nil="true" /></SpotQuote><ForwardWholesalePoints xmlns="RateCompositionInfo"><Value>-2</Value><State>Calculated</State>

Emmanuel_G

@Tommy_Alterax 

I don't know if I really capture the point. But you can get this value just by parsing your xml with parser and specify the element from which you want to extract data (SpotWholesale in your case) as below.

Note that when you specify specific child element, it's case sensitive.

Let me know if it was what you wanted.

   

XML.yxmd