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

[Anonymous]

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

[David_Beaty]

Hi,

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

Or

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

[DataTeam1 · Accepted solution]

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.

[Anonymous]

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

[Anonymous]

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