AnsweredAssumed Answered

Can we convert csv containing xml format data into an excel/csv with only column names and data against each column in test script?

Question asked by preetioc on Dec 20, 2018
Latest reply on Dec 20, 2018 by MarcyNunns

I have created a test script. This has 9 steps. In 8 steps a .txt file gets created as output and each .txt file has xml data.

Last step has result of all 8 steps stored in a csv file which has the xml data .

The above data is extracted from Sybase DB.

So,  when I run the ITR the result is stored in csv file and the stored result contains xml data in it. Can we convert csv containing xml format data into an excel/csv with only column names and data against each column in test script?

I have more than 100 columns..

I want to convert such csv file (attached)  in excel table format. I want to remove tags/ xml format .

Outcomes