Formatting a string
I would like to output the Text value from an edit field in the app to the QTP datatable. The string in the edit field is dynamic and each chunk of text is seperated by a "-". Is there a function that can evaluate and remove the hyphens, and then store each chunk of code into a different column in the datatable?
Re: Formatting a string
I think you want to split the string into array elements, using "-" as delimiter?
Dim arrList, strSentence
strSentence = [get your target string here]
arrList = Split(strSentence, "-")
To put each chunk of substring (now array elements) into a different column in the datatable, I think you need to call AddParameter() function of the sheet.