title: Robot framework: Lists should be equal problem with empty values: "None" and ''
body: <p>So problem here is that I am comparing two lists from different locations. One list is from excel and other list is from particular table which represents the imported values of the same excel values.
  So all values are correct; but the excel gives one or possbily more values which are &quot;none&quot; and from the table i get those values only empty value as astrophes ''. How can i change &quot;None&quot; to '' or vice versa?
  In this particular case &quot;None&quot; and '' are in the 10th value slot in lists but over time it can change because different values are put to the excel.<br />
  So how can I remove or replace/modify these &quot;nones&quot; to '':s or vice versa?</p>
  <p>Excel list: [1, 'X', 'Y', 200, 1999, 'Z', 'W', 4, 'V', None, 2, 1100]
  Table list: [1, 'X', 'Y', 200, 1999, 'Z', 'W', 4, 'V', '', 2, 1100]</p>
  <p>Using ExcelLibrary and ExcelRobot to get the mixture of keywords .. below is the similar approach</p>
  <pre><code>${iTotalRows} =   Get Row Count    Sheet1 (etc.) # excel
  
  ${item1} =      Get Table cell     //table[@class=&quot;xx&quot;]    2        1
  ${item1} =      Get Table cell     //table[@class=&quot;xx&quot;]    2        2 #etc..
  Lists should be equal       ${x}       ${y}
  
  </code></pre>
  <p>Thank you in advance</p>