Passing special characters to TestComplete through Excel

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.