topic How to parse html <pre> tag data as tREst response into csv file in Talend Studio

How to parse html

 tag data as tREst response into csv file

Anonymous — Sat, 16 Nov 2024 06:12:10 GMT

Hi Team ,

I have an URL, through which I am fetching data(response) using tREst component and logging it into tLogRow console.

But the incoming data is in 'tab' specified format , which is under <pre> tag in the html file( I viewed it through 'inspect element')

The data in the URL is like :

The Data in URL

While I am trying to get the response in CSV/excel format , it is treating the whole record as a single column.

So, how can I organize the incoming response in a CSV file?

Please refer to the attached file for the output, I am getting.

Thanks in advance for the help.

Regards

Subhadeep

Re: How to parse html

 tag data as tREst response into csv file

David_Beaty — Sat, 30 Mar 2019 11:30:32 GMT

Hi,

You probably need to use a combination of tSplitRow and then a tExtractDelimitedFields

Write the response out to a temporary file and the read in with tFileInputDelimited.

Re: How to parse html

 tag data as tREst response into csv file

DataTeam1 — Sat, 30 Mar 2019 19:22:07 GMT

You should use tExtractDelimitedFields with "\t" as field separator to split fields.

Don't forget to give kudos when a reply is helpful and when your query is answered, please mark the topic as resolved.

Re: How to parse html

 tag data as tREst response into csv file

Anonymous — Fri, 23 Aug 2019 13:46:05 GMT

Hello
first of all, thank you for your time to help me
in fact, I want to parse XML / HTML from site https://www.cert.ssi.gouv.fr/
I'm expecting to have a table like that

ie I want to parse HTML and extract all the CERTEFs with a title and a publication date and all the VECs that it exists in each CERTEF
I do not know which component I can use and with which configuration that extracts exactly the same table

thank you for helping me

topic How to parse html <pre> tag data as tREst response into csv file in Talend Studio

How to parse html
tag data as tREst response into csv file

Re: How to parse html
tag data as tREst response into csv file

Re: How to parse html
tag data as tREst response into csv file

Re: How to parse html
tag data as tREst response into csv file