title: In Jmeter, How can we use JSR223 Preprocessor to parse a CSV and filter on a particular column value to pass it as a variable to a sampler
body: <p>I'm new to JMeter and trying my best learn various things in JMeter especially regarding the CSV data processing as the application which I am working needs loads of parameterized data and I just can't create 100's of CSV filed as per the requirement and instead use a single CSV and filter the values based on specific conditions.  </p>
  
  <p>However, I'm finding it very difficult to write the code for this particular operatoin.</p>
  
  <p>Name|Identity|Date<br>
  "001, A"|"3409ADD9"|05-01-2020<br>
  "002, B"|"BA47D76A"|05-01-2020<br>
  "003, C"|"2BC92A2D"|05-02-2020<br>
  "004, D"|"AB9AEEBE"|05-23-2020<br>
  "005, E"|"09FF417D"|05-29-2020  </p>
  
  <p>Note: Here I'm using | to parse as my data will contain as part of the Name as shown.  </p>
  
  <p>As you can see, The data is grouped by Date value. I want to use this CSV file to pass the Identity and Name value based on currentDate.  </p>
  
  <p>For Ex, Current Date is May-01-2020, I want to pass only those records whose date is May-01-2020 and pass it as a variable to my samplers in a loop. Once we reach the end of the file (I mean values which don't have date May-01-2020 associated with, I want to start the loop again ) and repeat from first till the time I mention in the RunTime Controller.  </p>
  
  <p>I went through different questions and trying to find a solution as I couldn't write one for myself in Groovy, Hence asking for help.  </p>
  
  <p>As per many suggestions in different questions regarding the use of JSR223 preprocessor with Groovy instead of a bean shell, I would like to seek some guidance to solve this problem to move further.</p>