topic [resolved] Open XML files and modify content in Talend Studio

[resolved] Open XML files and modify content

Anonymous — Mon, 19 Aug 2013 08:55:54 GMT

Hi all,
I want to open a group of xml files that are in a specific folder one by one. I want to modify a line inside each of them
and then save them.
How can i perform that?

Regards

Re: [resolved] Open XML files and modify content

Anonymous — Mon, 19 Aug 2013 09:58:38 GMT

Hi,
You can use tfilelist to get these xml files where are in a specific folder one by one and then edit your xml in output file.
The work flow should be: tfilelist-->tfileinputxml-->tAdvancedFileOutputXML.
See my screenshots
Best regards
Sabrina

Re: [resolved] Open XML files and modify content

Anonymous — Mon, 19 Aug 2013 15:53:38 GMT

thank,
but i am affraid it could not help.
My problem is that i want to change the string "<?xml version="1.1" encoding="UTF-8"?>" to
"<?xml version="1.0" encoding="UTF-8"?>" at the header of the xml file.
Where can i see this string in order to change it?
Regards

Re: [resolved] Open XML files and modify content

Anonymous — Mon, 19 Aug 2013 16:09:00 GMT

thank,
but i am affraid it could not help.
My problem is that i want to change the string "<?xml version="1.1" encoding="UTF-8"?>" to
"<?xml version="1.0" encoding="UTF-8"?>" at the header of the xml file.
Where can i see this string in order to change it?
Regards

Hi
Use a tFileList to iterate each XML file, and use a tFileInputFullRow to read the XML line by line, link it to a tReplace to replace version="1.1" with version="1.0", and regenarate the XML file in another folder, please see my screenshots for details.
Shong

Re: [resolved] Open XML files and modify content

Anonymous — Wed, 28 Aug 2013 09:09:39 GMT

Thank you shong
it helped me !
Regards

Re: [resolved] Open XML files and modify content

Anonymous — Wed, 02 Apr 2014 08:03:20 GMT

Is this approach also recommend for replacing single values in XML elements?

Re: [resolved] Open XML files and modify content

Anonymous — Wed, 02 Apr 2014 08:16:37 GMT

Hi ohofrichter,
What's your XML structure? Could you set an example for your case with input and expected output values so that we can see if this approach is suitable for you.
Best regards
Sabrina

Re: [resolved] Open XML files and modify content

Anonymous — Wed, 02 Apr 2014 08:27:54 GMT

Another problem: how to replace particular lines based on an external lookup?
Example:
<NodeA>
<NodeB key="Text1">0099</Wert>
<NodeB key="Text2">0100</Wert>
</NodeA>
lookup table:
0099;0100
Only in the line with key="Text1" 0099 has to be replaced by 0100.
The lookup table shall only contain the numerals.
In the attached screenshot you can see the job I created for this requirement. Can I configure component tFileInputFullRow to handle only particular lines? Or is there another solution for such an requirement?