Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cross-Checking data with XML Help;

Status
Not open for further replies.

catabywarmbloods

Technical User
Jun 15, 2012
1
AU
Hi Guys,

A rough background: basically we are working with XML's and trying to cross-check the data within those XML's to look for any possible "errors" that may be coming up through when the information has been data entered. What I'm after, is trying to cross-check things within the XML, such as: If X field is blank, then Y field must be blank and Z field must have 'a value' within it (but not a limited value) - then you need to flag that document to be checked.

As an example:
Name: John Smith
Age:
Code: Years
Deceased: No
Age Approx: No

I want this XML to be flagged because the "Code" has been entered with a value, therefore it should have an age value as well. However, an XML with the following information:

Name: John Smith
Age:
Code:
Deceased: Yes
Age Approx: No

I don't want that XML flagged due to the Age being blank, because the deceased tag is a Yes (and therefore no Age information will be present).

Is there a program I can use/download that will allow me to put in a, "if these tags have no value, then this field *should* have *a* value" and do a search over thousands of XML's?

If I make no sense, please let me know and I will try and break it down a little further as well.

Cheers.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top