Reading values from excel file

This may be helpful:

https://support.smartbear.com/testcomplete/docs/testing-with/working-with-external-data-sources/excel/working-via-com.html

Hi newbiexiii.

Not sure what language you are coding, but the following JavaScript functions will show you how you can convert your date string.

The first is a generic function to convert hex codes to ascii characters. The second is specifically parsing your date string and then calling the hexToAscii function to get the ascii characters.  The third is just a test function.  You could combine them into one function if you wanted.

Have a look and let me know if this helps.

  function hexToAscii(hexString)
  {
    // create an empty string
    var ascii = "";
    for (var i = 2; i < hexString.length; i += 2)
    {
     // get the substring, convert to int using base 16, then get the ascii character
     ascii += String.fromCharCode(parseInt(hexString.substr(i, 2), 16));
    }
    return ascii;
  }

  function dateDecoder(excelValue)
  {
    // create a empty string to append and return
    var retAscii = "";
    // split the string on the underscore
    var arr = excelValue.split('_');
    // loop the array
    for (var i = 0; i < arr.length; i++)
    {
      // if 5 characters and starts with 'x' then convert the hexcode to ascii otherwise just append the item to asciiString
      if (arr[i].length == 5 && aqString.Find(arr[i], "x", 0, false) == 0)
        retAscii += hexToAscii(aqString.Replace(arr[i], "x", "", false));
     else
       retAscii += arr[i];
    }

    return retAscii;
  }

  function decoderTest()
  {

    BuiltIn.ShowMessage(dateDecoder("_x0038__x002F_25_x002F_2016_x0020_11:13:52_x0020_AM"));
  }