Forum Discussion

sankar_k's avatar
sankar_k
Occasional Contributor
11 years ago

Passing special characters to TestComplete through Excel

Hi There I am developing a generic framework and I am passing Name Mapping, child objects to be searched (set of properties and their values) and the actual values to be entered into the text f...
  • Colin_McCrae's avatar
    11 years ago
    You could parse them as you read them in.



    So search the read-in string for "chr(*)" so that it finds and extracts each one. Then simply re-compile the string using the extracted CHR's in an EVAL statement. (Having removed them from the original of course)



    Seems little clunky, but a single function should work on all fields.



    I can pretty much visualise the code in my head in VBScript. But I don't know what you're writing in.



    I do something sort of similar with my framework which reads in tests from Excel fields in that certain combinations of leading characters tell it what a cell contains. "P:" is a parameter, "E:" is an expected result, "M:" is a marker, "D:" is a dependency .... etc etc. These are all parsed out of the cell data as it's read in.