Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 :
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
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.
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.
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.
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