Issue reading XML using tfileInputXml

One Star

Issue reading XML using tfileInputXml

Having issue reaching data from XML since some of the data in XML doesnt have elements, attached sample XML , in which the highlighted data not present inside an element , when i use tfileInputXml , that particular data is not been captured , any suggestion to reach this data
Community Manager

Re: Issue reading XML using tfileInputXml

Hi
The CDATA section is unparsed character data in a XML file, it is not a element or an attribute, can not be parsed by XML parser. If you want to read data from this section, I will suggest you to use tFileInputRegex component with regular expression.
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Introduction to Talend Open Studio for Data Quality

Find out about Talend Open Studio for Data Quality

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read