XML field in the table how to validate?

[Anonymous]

Hi there,

I'm using Talend 5.6 open studio and MySQL as database.  I need to validate the date and the price if it's valid or not.  I have an xml field in the table and need to extract it to load to different columns.  Because I have invalid dates and price, I would like to validate it if it's valid or not rather than excluding these records.  How can I do that in Talend?

Thank you,

Melissa

[nfz11]

Select your data from the table, parse the XML of the column, validate with your rule, write the parsed data back to the database.

tDBinput -> tExtractXMLFields -> tDTDValidation, tXSDValidator or tJavaRow if your validation logic is not expressed in a schema -> tDBRow