How can I write all values extracted via regex to a file?

0
votes

I've got a piece of regex which I've tested in JMeter using the regexp tester and it returns multiple results (10), which is what I'm expecting.

I'm using the Regular Expression Extractor to retrieve the values and I would like to write ALL of them to a CSV file. I'm using the Beanshell Post Processor but I am only aware of a method to write 1 value to file.

My script in Beanshell so far:

temp = vars.get("VALUES"); // VALUES is the Reference Name in regex extractor

FileWriter fstream = new FileWriter("c:\\downloads\\results.txt",true);
BufferedWriter out = new BufferedWriter(fstream);
out.write(temp);
out.close();

How can I write all the values found via the regex to file? Thanks.

2
jmeterbeanshell
How is temp defined? - Philip Allgaier
I have not defined temp. I grabbed some code while googling a solution as to how to write to files in JMeter. - ratsstack
I see where you're going with this though. VALUES is an array so I'd need to define it as an array when I do a vars.get("VALUES"). This is what I'd like to know how to do. Also once we have temp defined as an array how do I dump it's contents to a file? Would I need to write a loop that went through each row of an error? Forgive me if these questions are stupid, I'm just learning this stuff for the first time. :-) - ratsstack

2 Answers

3
votes

If you'll look into Debug Sampler output, you'll see that VALUES will be a prefix.

Like

  • VALUES=...
  • VALUES_g=...
  • VALUES_g0=...
  • VALUES_g1=...

etc.

You can use ForEach Controller to iterate over them.

If you want to proceed with Beanshell - you'll need to iterate through all variables like:

    import java.io.FileOutputStream;
    import java.util.Map;
    import java.util.Set;

    FileOutputStream out = new FileOutputStream("c:\\downloads\\results.txt", true);
    String newline = System.getProperty("line.separator");
    Set variables = vars.entrySet();

    for (Map.Entry entry : variables) {
        if (entry.getKey().startsWith("VALUES")) {
            out.write(entry.getValue().toString().getBytes("UTF-8"));
            out.write(newline.getBytes("UTF-8"));
            out.flush();
        }
    }

    out.close();
2
votes

To write the contents of your values array into the file, the following code should work (untested):

String[] values = vars.get("VALUES");

FileWriter fstream = new FileWriter("c:\\downloads\\results.txt", true);
BufferedWriter out = new BufferedWriter(fstream);

for(int i = 0; i < values.length; i++)
{
   out.write(values[i]);
   out.newLine();
   out.flush();
}
out.close();