Jmeter - how to write specific variable to CSV file to specific row/column

Question

My csv file looks like:

TC_name, username, password, excpecedCode
ad_test_master_successful_login,username,Test123!,200

What is the easiest way to so i can write to csv to specific row/column, and example to overwrite Test123! with variable fetched from user defined variables?

I know i can read value using JSR223 Pre/post processor with ex:

def line10 = new File('C:/Users/test/Desktop/testData/login.csv').readLines().get(1).split(",")[2]
log.warn("csv as-> " + line10);

Dmitri T · Accepted Answer · 2020-05-18 14:14:20Z

1

There is no such concept as "cell" in CSV files, if you're looking for the code which will replace one string with another, you can do something like:

def file = new File('test.csv')
def text = file.text.replaceAll('Test123!', vars.get('foo'))
file.text = text

If you're looking for a better option you can consider using GroovyCSV library (you will need to download it and place in JMeter Classpath followed by JMeter restart) or consider switching to Excel file where you will have full control via Apache POI library like it's described in How to Implement Data Driven Testing in your JMeter Test article

answered May 18, 2020 at 14:14

Dmitri T

169k6 gold badges91 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Jmeter - how to write specific variable to CSV file to specific row/column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related