Plancd = Datatable.value ("ClaimStatus" , "Retrieval")
msgbox Plancd [Comment] i am getting ABR as a result
If Plancd = "ABR" Then
Final result is B it is suppose to be A i am not sure what mistake i am doing.
Check to see if there are any nulls or spaces in the value.
I have not failed. I've just found 10,000 ways that won't work" --Thomas Edison
yes you are right i got value 5 when i used this command
result = len(Plancd)
what i can do in this case ? is there any method to remove space or null character?
The spaces are probably at the end of the data, the value is probably "ABR " so why don't you use this to check the value.
yeah but i used trim function to remove spaces
So it works now?
yes and thanks alot