Hari

No Terry. I went by the text and rewrote it and missed that option. After your second post, I understood I missed something and went by the code carefully.

Dear Terry, When I was testing your code, I did not select the option "do not process embedded variables". My mistake. I think this is why your method was failing when I tested it. Now I am able to run the task even after using % in the variable value after replacing % with ASCII Char 37. Thank you very much for the help This thread can be closed as resolved. Regards

Dear Terry, Thanks for your suggestion. But unfortunately it is not working. Facing the same error. see below code used...It is failing at the same function : trim. Both the text box displays are showing the same value. Variable Set to ASCII Char 37 to %tPerSign% Variable Set String %NewCellVal% from the clipboard contents Delay: 300 milliseconds Text Box Display: New Cell Value Delay: 300 milliseconds Variable Modify String: Replace "%" in %NewCellVal% with "%tPerSign%" Delay: 300 milliseconds Text Box Display: New Cell Value Variable Modify String %NewCellVal%: Trim

Dear All, Apologies for not specifying the scenario correctly. After your comments tried to test the scenario again. the result is 1) when I use only one % in the variable value, it is working for me also. No problem. 2) But if I use two % for ex (CASH%CGR%USD) in the value, I am facing the undefined variable error. Unfortunately, I have to use two or more "%" in the value. Though I am using a workaround to solve this issue, it would be better if we can find a straight solution. Thanks again for your efforts.

Thanks to both of you for your clarification.. Actually I am copying a cell value from Excel to NewCellVal and then applying Trim. it is failing at the code where I am doing "trim" function. the error is Line30: Debug error : Undefined variable or the variable is the wrong type. However if I replace "%" with "-" and then run the same code, there is no error. So I thought the problem may be due to using % in the variable value. I am using version ME Pro 4.8.1.1 Text Type (Simulate Keystrokes): <CTRLD>c<CTRLU> Delay: 300 milliseconds Variable Set String %NewCellval% from the clipboard contents Delay: 300 milliseconds Variable Modify String %NewCellVal%: Trim Delay: 300 milliseconds thanks again for your contribution.

Thanks Cory for the quick response. I have searched the forum before logging this. But could not find a resolution. Any member's help in providing the link to the resolution is welcome:-)

I have a scenario where I need to use % as part of the variable value. For example %T[1]% = "CASH%001". When using the value like this, the variable T[1] is not taking the value correctly and macro is stopped at the line where the string is modified. Thanks in advance for your suggestions.