I have created a java program to count occurrences from a csv file and working fine in eclipse. Below is the code.
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileWriter;
import java.io.IOException;
import java.io.PrintStream;
import java.util.HashMap;
import java.util.Map;
import java.util.Scanner;
import com.opencsv.CSVWriter;
public class ReadExcelDemo {
public ReadExcelDemo(FileWriter fileWriter) {
// TODO Auto-generated constructor stub
}
static void countEachWords(String fileName, Map < String, Integer > words) throws FileNotFoundException
{
Scanner file = new Scanner(new File(fileName));
while (file.hasNext())
{
//String[] w=file.split(" ");
String word=file.next();
String key = word.split(",")[1];
Integer count = words.get(key);
if(count !=null)
count++;
else
count =1;
words.put(key, count);
}
file.close();
}
public static void main(String args[]) throws IOException
{
Map<String, Integer> words= new HashMap<String, Integer>();
countEachWords("C:\\apache-jmeter-5.1.1\\Results\\Login.csv", words);
FileWriter csvWriter = new FileWriter("C:\\apache-jmeter-5.1.1\\Results\\output.csv");
for(String keyset : words.keySet()) {
String data = keyset +","+ words.get(keyset);
String data1 = keyset;
Integer data2= words.get(keyset);
csvWriter.append(data);
csvWriter.append("\n");
}
csvWriter.close();
}
}
While running in jmeter beanshell throwing below error.
Response message: org.apache.jorphan.util.JMeterException: Error invoking bsh method: eval In file: inline evaluation of: ``import java.io.File; import java.io.FileNotFoundException; import java.io.FileWr . . . '' Encountered "<" at line 16, column 57.