How to exclude null or empty values using Script Includes?

[Lisa Goldman]

Hello,

I'm using the following script to parse an Excel file:

var parser = new sn_impex.GlideExcelParser();
var attachment = new GlideSysAttachment();

// use attachment sys id of an excel file
var attachmentStream = attachment.getContentStream('61d8600297262110610dbfb6f053af1c');

parser.parse(attachmentStream);

//retrieve the column headers
var headers = parser.getColumnHeaders();
var header1 = headers[0];
var header2 = headers[1];

//print headers
gs.info(header1 + " " + header2);

while(parser.next()) {
var row = parser.getRow();
//print row value for both columns
gs.info(row[header1] + ' ' + row[header2])
}

The output including "Null" values:

I just want to print the row with values.  Can someone help please?

Thank you

[Sandeep Rajput · Accepted solution]

@Lisa Goldman Please try the following script.

var parser = new sn_impex.GlideExcelParser();
var attachment = new GlideSysAttachment();

// use attachment sys id of an excel file
var attachmentStream = attachment.getContentStream('61d8600297262110610dbfb6f053af1c');

parser.parse(attachmentStream);

//retrieve the column headers
var headers = parser.getColumnHeaders();
var header1 = headers[0];
var header2 = headers[1];

//print headers
if (header1 && header2) {
    gs.info(header1 + " " + header2);
}


while (parser.next()) {
    var row = parser.getRow();
    //print row value for both columns
    if (row[header1] && row[header2]) {
        gs.info(row[header1] + ' ' + row[header2]);
    }

}

[Sandeep Rajput · Accepted solution]

@Lisa Goldman Please try the following script.

var parser = new sn_impex.GlideExcelParser();
var attachment = new GlideSysAttachment();

// use attachment sys id of an excel file
var attachmentStream = attachment.getContentStream('61d8600297262110610dbfb6f053af1c');

parser.parse(attachmentStream);

//retrieve the column headers
var headers = parser.getColumnHeaders();
var header1 = headers[0];
var header2 = headers[1];

//print headers
if (header1 && header2) {
    gs.info(header1 + " " + header2);
}


while (parser.next()) {
    var row = parser.getRow();
    //print row value for both columns
    if (row[header1] && row[header2]) {
        gs.info(row[header1] + ' ' + row[header2]);
    }

}

[Ankur Bawiskar · Accepted solution]

@Lisa Goldman 

try to check if value is not null

var parser = new sn_impex.GlideExcelParser();
var attachment = new GlideSysAttachment();

// use attachment sys id of an excel file
var attachmentStream = attachment.getContentStream('61d8600297262110610dbfb6f053af1c');

parser.parse(attachmentStream);

//retrieve the column headers
var headers = parser.getColumnHeaders();
var header1 = headers[0];
var header2 = headers[1];

//print headers
gs.info(header1 + " " + header2);

while(parser.next()) {
var row = parser.getRow();
//print row value for both columns
if(row[header1] != null && row[header2] != null)
gs.info(row[header1] + ' ' + row[header2]);
}

[Sharath7]

If your using array then use this :- 

if (row[header1] != null) {

                    arrRes.push({

                        "case_number_mvs": row[header1] // muti variables >> variable name                     

                    });

[Amit Gujarathi]

HI @Lisa Goldman ,
I trust you are doing great.
Looking at your current script, you are already pa

var parser = new sn_impex.GlideExcelParser();
var attachment = new GlideSysAttachment();

// use attachment sys id of an excel file
var attachmentStream = attachment.getContentStream('61d8600297262110610dbfb6f053af1c');

parser.parse(attachmentStream);

while(parser.next()) {
  var row = parser.getRow();
  //print row values for both columns
  gs.info(row[0] + ' ' + row[1]);
}

rsing the Excel file using the GlideExcelParser() function and retrieving the column headers using the getColumnHeaders() function. To print the row values, you simply need to modify the while loop to print the row variable instead of the headers. Here's an updated script: