LabVIEW

Search information on XML

Hello,

I have the following XML:

<soap:Envelope xmlns:soap="http:OcultURL">

<soap:Header/>

<soap:Body>

<ns1:OUTPUT_DATA xmlns:ns1="http:OcultURL">

<OUTPUTList>

<OUTPUT>

<SalesOrderNumber/>

<SalesOrderItem/>

<OrderNumber/>

<WBSElement/>

<MaterialNumber>32478155</MaterialNumber>

<AlternativeBOM>01</AlternativeBOM>

<Plant>0</Plant>

<Usage>1</Usage>

<Status>01</Status>

<ChangeNumber/>

<MaterialList>

<Material>

<ItemNumber>0730</ItemNumber>

<Category>L</Category>

<Component>43731</Component>

<Quantity>1.000 </Quantity>

<UnitOfMeasure>UN</UnitOfMeasure>

<SortString/>

<RelevantToCosting>X</RelevantToCosting>

</Material>

<Material>

<ItemNumber>0740</ItemNumber>

<Category>L</Category>

<Component>5367137</Component>

<Quantity>1.000 </Quantity>

<UnitOfMeasure>UN</UnitOfMeasure>

<SortString/>

<RelevantToCosting>X</RelevantToCosting>

</Material>

<Material>

<ItemNumber>1500</ItemNumber>

<Category>L</Category>

<Component>573123</Component>

<Quantity>1.000 </Quantity>

<UnitOfMeasure>UN</UnitOfMeasure>

<SortString/>

<RelevantToCosting>X</RelevantToCosting>

</Material>

<Material>

<ItemNumber>1550</ItemNumber>

<Category>L</Category>

<Component>1234374</Component>

<Quantity>1.000 </Quantity>

<UnitOfMeasure>UN</UnitOfMeasure>

<SortString/>

<RelevantToCosting>X</RelevantToCosting>

<CadIndicator>X</CadIndicator>

</Material>

<Material>

<ItemNumber>1551</ItemNumber>

<Category>L</Category>

<Component>123456</Component>

<Quantity>1.000 </Quantity>

<UnitOfMeasure>UN</UnitOfMeasure>

<SortString/>

<RelevantToCosting>X</RelevantToCosting>

<CadIndicator>X</CadIndicator>

</Material>

<DocumentList/>

<ClassList/>

<TextList>

<Text>

<ItemNumber>0009</ItemNumber>

<Category>T</Category>

<Quantity>1.000 </Quantity>

<UnitOfMeasure>ST</UnitOfMeasure>

<SortString/>

<ReferencePoint/>

<InputText1>* * * ACESS DENIED * * *</InputText1>

<InputText2/>

</Text>

<Text>

<ItemNumber>1499</ItemNumber>

<Category>T</Category>

<Quantity>1.000 </Quantity>

<UnitOfMeasure>CJ</UnitOfMeasure>

<SortString/>

<ReferencePoint/>

<InputText1>* * * OCULT INFORMATION * * *</InputText1>

<InputText2/>

</Text>

<Text>

<ItemNumber>2199</ItemNumber>

<Category>T</Category>

<Quantity>1.000 </Quantity>

<UnitOfMeasure>CJ</UnitOfMeasure>

<SortString/>

<ReferencePoint/>

<InputText1>* * * TEST NUMBER 2 * * *</InputText1>

<InputText2/>

</Text>

<Text>

<ItemNumber>2599</ItemNumber>

<Category>T</Category>

<Quantity>1.000 </Quantity>

<UnitOfMeasure>CJ</UnitOfMeasure>

<SortString/>

<ReferencePoint/>

<InputText1>* * * TEXT TEST * * *</InputText1>

<InputText2/>

</Text>

</Text>

</TextList>

</MaterialList>

<PlantAssignmentList/>

</OUTPUT>

</OUTPUTList>

<ErrorList/>

</ns1:OUTPUT_DATA>

</soap:Body>

</soap:Envelope>

I need to find the ItemNumber of InputText1 = * * * OCULT INFORMATION * * *
After that I need to check in MaterialList which Material corresponds to the digits. Ex: If ItemNumber of * * * OCULT INFORMATION * * * is 1499, I need to find the Materials that have ItemNumber of the same "Family", in this case: 1500, 1550, 1551

Can you help me to do that? I'm having a hard time with this

Message 1 of 4

(209 Views)

LabVIEW has some good XML parsing VI's

But when I try to paste your XML into XML Notepad I get this error:

I don't really have the time to figure that out.

========================
=== Engineer Ambiguously ===
========================

Message 2 of 4

(187 Views)

Author

I'm sorry, i forgot to remove an tag that no needed

Here is the corrected XML

<soap:Envelope xmlns:soap="http:OcultURL">

<soap:Header/>

<soap:Body>

<ns1:OUTPUT_DATA xmlns:ns1="http:OcultURL">

<OUTPUTList>

<OUTPUT>

<SalesOrderNumber/>

<SalesOrderItem/>

<OrderNumber/>

<WBSElement/>

<MaterialNumber>32478155</MaterialNumber>

<AlternativeBOM>01</AlternativeBOM>

<Plant>0</Plant>

<Usage>1</Usage>

<Status>01</Status>

<ChangeNumber/>

<MaterialList>

<Material>

<ItemNumber>0730</ItemNumber>

<Category>L</Category>

<Component>43731</Component>

<Quantity>1.000 </Quantity>

<UnitOfMeasure>UN</UnitOfMeasure>

<SortString/>

<RelevantToCosting>X</RelevantToCosting>

</Material>

<Material>

<ItemNumber>0740</ItemNumber>

<Category>L</Category>

<Component>5367137</Component>

<Quantity>1.000 </Quantity>

<UnitOfMeasure>UN</UnitOfMeasure>

<SortString/>

<RelevantToCosting>X</RelevantToCosting>

</Material>

<Material>

<ItemNumber>1500</ItemNumber>

<Category>L</Category>

<Component>573123</Component>

<Quantity>1.000 </Quantity>

<UnitOfMeasure>UN</UnitOfMeasure>

<SortString/>

<RelevantToCosting>X</RelevantToCosting>

</Material>

<Material>

<ItemNumber>1550</ItemNumber>

<Category>L</Category>

<Component>1234374</Component>

<Quantity>1.000 </Quantity>

<UnitOfMeasure>UN</UnitOfMeasure>

<SortString/>

<RelevantToCosting>X</RelevantToCosting>

<CadIndicator>X</CadIndicator>

</Material>

<Material>

<ItemNumber>1551</ItemNumber>

<Category>L</Category>

<Component>123456</Component>

<Quantity>1.000 </Quantity>

<UnitOfMeasure>UN</UnitOfMeasure>

<SortString/>

<RelevantToCosting>X</RelevantToCosting>

<CadIndicator>X</CadIndicator>

</Material>

<DocumentList/>

<ClassList/>

<TextList>

<Text>

<ItemNumber>0009</ItemNumber>

<Category>T</Category>

<Quantity>1.000 </Quantity>

<UnitOfMeasure>ST</UnitOfMeasure>

<SortString/>

<ReferencePoint/>

<InputText1>* * * ACESS DENIED * * *</InputText1>

<InputText2/>

</Text>

<Text>

<ItemNumber>1499</ItemNumber>

<Category>T</Category>

<Quantity>1.000 </Quantity>

<UnitOfMeasure>CJ</UnitOfMeasure>

<SortString/>

<ReferencePoint/>

<InputText1>* * * OCULT INFORMATION * * *</InputText1>

<InputText2/>

</Text>

<Text>

<ItemNumber>2199</ItemNumber>

<Category>T</Category>

<Quantity>1.000 </Quantity>

<UnitOfMeasure>CJ</UnitOfMeasure>

<SortString/>

<ReferencePoint/>

<InputText1>* * * TEST NUMBER 2 * * *</InputText1>

<InputText2/>

</Text>

<Text>

<ItemNumber>2599</ItemNumber>

<Category>T</Category>

<Quantity>1.000 </Quantity>

<UnitOfMeasure>CJ</UnitOfMeasure>

<SortString/>

<ReferencePoint/>

<InputText1>* * * TEXT TEST * * *</InputText1>

<InputText2/>

</Text>

</TextList>

</MaterialList>

<PlantAssignmentList/>

</OUTPUT>

</OUTPUTList>

<ErrorList/>

</ns1:OUTPUT_DATA>

</soap:Body>

</soap:Envelope>

Message 3 of 4

(145 Views)

Author

Thank you for help, i get it the solution.

Message 4 of 4

(137 Views)

What do you need our team of experts to assist you with?

Request a quote Find the right product Place an order Get support on a product

How can we help?

Please enter your information below and we'll be intouch soon.

This field is required

This field is required

This field is required

This field is required

Preferred communication method

Email Phone call

What do you need our team of experts to assist you with?

Request a quote Find the right product Place an order Get support on a product