topic Re: Add a linebreak after each tag close in Talend Studio

Add a linebreak after each tag close

JavierP2 — Sat, 16 Nov 2024 02:32:32 GMT

Hi there community!

I'm thinking how to manage the following scenario, I really don't know what's needed, hope you can help me:

Issue:

I have xml files like this one (all the tags in 1 line):

Due the endprogram rules I do need to add (space break) after each tag to look as this one:

Do you think is there any way to achieve this? I will need to do it for many different files that will appear on a SFTP.

Thanks a lot!

Re: Add a linebreak after each tag close

TRF — Thu, 30 Apr 2020 18:40:53 GMT

row1.string.replaceAll(">", >\n") may help

Re: Add a linebreak after each tag close

JavierP2 — Thu, 30 Apr 2020 18:42:25 GMT

Thanks for the answer.

Where can I put that? into a tFileList?

Re: Add a linebreak after each tag close

TRF — Thu, 30 Apr 2020 18:49:11 GMT

No, tFileList is there to get file list from a folder.
Here you want to change a field value, so you can use tMap, tJavaRow or tJavaFlex component to achieve this.

Re: Add a linebreak after each tag close

JavierP2 — Thu, 30 Apr 2020 19:09:08 GMT

Thanks for the answer,

I've tried but had an error, I suppose I have to convert the xml to a String?

Re: Add a linebreak after each tag close

TRF — Thu, 30 Apr 2020 19:55:17 GMT

If the content is into a file, you need to read it, then change the content as explained and rewrite it.
You should share your job design for a better understanding if your usecase.

Re: Add a linebreak after each tag close

JavierP2 — Thu, 30 Apr 2020 20:09:09 GMT

Hi,

I've solved it in other manual way, I think it would be easier.

Thanks a lot for your help.