How to change a column value in csv dynamically

Question

I have a CSV file like below

SoftwareID,SoftwareDescription,SoftwareName,SoftwareVersion,SoftwareLifeCycleStage,SoftwareCodeBase,SoftwareTags,SoftwareSeverity
TestSoftware,This is Test Sample,AutoTestSoftware11,1,Concept,Large,java,Medium
TestSoftware,This is Test Sample,AutoTestSoftware12,1,End of Life,Very Large,java,High
TestSoftware,This is Test Sample,AutoTestSoftware13,1,Concept,Large,java,Low
TestSoftware,This is Test Sample,AutoTestSoftware14,1,Concept,Large,java,Critical

As you see, SoftwareName is unique. So, every time before execution, I need to change those values. But, I want to put my automation in Jenkins. So, I want to write code such that it could change the SoftwareName dynamically.

I did R&D on this and find below info.

I came across CSVDozerWriter in SuperCSV. Firstly, I read the CSV file to bean. Then, I will squeeze out the number part and increment that value. Then write that again to CSV. But, I find it very difficult.

https://super-csv.github.io/super-csv/examples_dozer.html

Can anyone help?

EDIT1: my main goal is to write a code to change the softwareName values

What is your specific question/problem? – Jan Apr 26 '16 at 07:34 — Jan, Apr 26 '16 at 07:34
I want code to change softwareName column values.... – Lokesh S Apr 26 '16 at 07:37 — Lokesh S, Apr 26 '16 at 07:37
try out opencsv (http://opencsv.sourceforge.net/) – Eritrean Apr 26 '16 at 07:44 — Eritrean, Apr 26 '16 at 07:44
Okay, will go through it.... – Lokesh S Apr 26 '16 at 07:45 — Lokesh S, Apr 26 '16 at 07:45

How to change a column value in csv dynamically

0 Answers0