Forum Discussion

manojgovikari's avatar
manojgovikari
Contributor
14 years ago

How to Replace character "µ" with null or empty string

Hi , I need to replace the character "µ" with empty stirng.. i tried the following code but not successded. 1. Replace(µg/dL, "µ","") 2. Replace(µg/dL, char(181),"") Please help me get...
manojgovikari's avatar
manojgovikari
Contributor
14 years ago
Expected result captured from External excel file and it will be compared using Instr.

If Instr(ActualResult, Expected Result) > 0 Then

 Log PASS

Else

 Log FAIL

End IF



StrComp is also not working due this character. Is there any technique to replace/remove those special characters.