Hari
-
Posts
7 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by Hari
-
-
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.
Using % in variable value
in Macro Express and Macro Express Pro
Posted
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.