18 January 2026:


This forum is now archived and is in read-only mode. Please continue discussions on our improved new Sahi Pro Community forum.



Sahi Pro is an enterprise grade test automation platform which can automate web, mobile, API, windows and java based applications and SAP.

Null value is entered as "null"

anoop.philipanoop.philip Members
edited November -1 in Sahi - Open Source
I'm doing a data driven test using excel sheet to check invalid login. I've created one column for username and another for password and added some invalid values.
One row for username and password I left blank to check login with blank username and password.
When running the test, it is entering the value as "null" in both username and password fields. So i'm not able to check for blank username and password using excel sheet. It is working fine with .csv file.

The log shows for the particular blank row as
_setValue(_textbox("uname"), "null");
_setValue(_password("passwd"), "null");

Please help me with this.

Comments

  • narayannarayan Administrators
    Hi Anoop,

    I haven't checked yet, but I think blank and null may not be easily distinguishable when reading from Excel.
    Can you add a small function to check if the value is null and return blank?
    function blankIfNull($s){
  return ($s == "null" || $s == null) ? "" : $s;
}

$name = blankIfNull($name);
$password = blankIfNull($password);

_setValue(_textbox("uname"), $name);
_setValue(_password("passwd"), $password);

    Regards,
    Narayan
  • anoop.philipanoop.philip Members
    Hi Narayan,

    It is working now after adding the function you gave :) Thanks.

    Regards,
    Anoop
This discussion has been closed.