Forum Discussion

Mis3's avatar
Mis3
Frequent Contributor
4 years ago

Groovy Script to read a CSV

My Groovy script has a loop to read an CSV file and to execute the testcases one by one.  It is working but I like to improve its efficiency. If the CSV has blank lines, the testcase would still exe...
  • nmrao's avatar
    nmrao
    4 years ago
    Ok.
    Instead of data[0].charAt[0], try using
    if (rowdata.startsWith('3')) {
    // do all the processing here
    }
  • Mis3's avatar
    Mis3
    4 years ago

    Thanks, nmrao.

    I used your code but modified it a bit.   I also added a continue statement so to ignore the rest of the code like testcase, etc.

     

    if ( !rowdata.startsWith('302') )
    {
    log.info " Seq="+i+ " " + data[0]+" Invalid line"
    report << "\n"+ sdf.format(log_date)+" Seq="+i+ " " + data[0] +" Invalid line"
    continue
    }

Mis3's avatar
Mis3
Frequent Contributor

Problem is I am usually not the one who prepare the input file and to execute the Groovy script.

The script in its current form is working well.  I just wanted to improve it so to handle potential human errors.  

 

Because the 1st character of each "good" input line should be "3", I was thinking to compare this char so if it is not "3", the loop should skip this line.  

char_1 = data[0].charAt(0)

log.info char_1

Unfortunately, this does not work.  It gave me a outofbound error.  

 

1. Is there a way to detect blank line?

2. When a blank line is detected, how do I skip the rest of the commands in the loop?  I like to output a message like "invalid data."; skip all the commands in the loop and proceed to the next line (until no more data)?

 

Thanks.

 

nmrao's avatar
nmrao
Champion Level 3
4 years ago
Ok.
Instead of data[0].charAt[0], try using
if (rowdata.startsWith('3')) {
// do all the processing here
}
  • Mis3's avatar
    Mis3
    Frequent Contributor
    4 years ago

    Thanks, nmrao.

    I used your code but modified it a bit.   I also added a continue statement so to ignore the rest of the code like testcase, etc.

     

    if ( !rowdata.startsWith('302') )
    {
    log.info " Seq="+i+ " " + data[0]+" Invalid line"
    report << "\n"+ sdf.format(log_date)+" Seq="+i+ " " + data[0] +" Invalid line"
    continue
    }