title: How to uppercase and convert data to ArrayList in Robot framework?
body: <p>I had to create a robot framework script for comparing data between Excel and WebDriver (Firefox). </p>
  
  <p>Solution 1: The problem is "I cannot convert to uppercase and convert to ArrayList for comparing data".</p>
  
  <pre><code>${doc1}=   Open Excel Document        filename=${OpenExcel}     doc_id=doc1
  ${view_bicccicmdu}=   Read Excel Row    row_num=1   max_num=6   sheet_name=UpperTT
  ${view_bicccicmduCheckLength}=    Get Length    ${view_bicccicmdu}
  Wait Until Page Contains Element    ${EmptyValue}  ${timeout}
  Click Element   ${EmptyValue}
  Execute JavaScript  window.scrollTo(0, 7000);
  Wait Until Page Contains Element    ${ClickAV.CheckColumn}  ${timeout}
  ${HG}=          Get Text    ${ClickAV.CheckColumn}
  ${UPPER1}=      Evaluate     "${HG}".upper()
  ${HG2}=         Combine Lists  ${HG}
  ${HGLenght}=         Get Line Count  ${HG}
  Should Be Equal     ${HGLenght}    ${view_bicccicmduCheckLength}
  Should Be Equal     ${HG}     ${view_bicccicmdu}        ignore_case=True
  Close Excel Document
  </code></pre>
  
  <p>Solution 2: The problem is "I cannot convert to uppercase".</p>
  
  <pre><code>${doc4}=   Open Excel Document        filename=${OpenExcel}     doc_id=doc4
  ${view_callsrc}=   Read Excel Row    row_num=5   max_num=6   sheet_name=UpperDD
  ${view_callsrcCheckLength}=    Get Length    ${view_callsrc}
  Wait Until Page Contains Element    ${EmptyValue}  ${timeout}
  Click Element   ${EmptyValue}
  Execute JavaScript  window.scrollTo(0, 7000);
  Wait Until Page Contains Element    ${ClickAV.dropdownSeID}  ${timeout}
  #Execute JavaScript   ${ClickAV.dropdownExJ}
  Wait Until Page Contains Element    ${ClickAV.dropdownExSelect}  ${timeout}
  ${HG}=   Get List Items    ${ClickAV.dropdownExSelect}
  ${UPPER1}=      Evaluate     "${HG}".upper()
  ${HGLenght}=    Get length    ${HG}
  # ${BBB}=     Strip String    ${HG}   characters=total
  #${BBB2} =  Convert To Integer  ${BBB}
  Should Be Equal     ${HGLenght}    ${view_callsrcCheckLength}
  Lists should be equal     ${HG}     ${view_callsrc}
  Close Excel Document
  </code></pre>
  
  <p>Solution 3: The problem is "I don't know how to ignoreUppercase or ignoreLowercase, I just need to compare the data that are equal".</p>