Hi all,
I have an approximately same issue, the idea is that I am getting a value from DB which is assigned to a variable, e.g. Requested_Field.
the format of this value is e.g.: 126991.55 (it have an ".")
then to the second variable is assigned another value, which is got from the application, it's value is for e.g. the same but format is another: 126,991.55 (with "," and ".").
when I am comparing them, I'm getting an error, this is because the formats are different: the report added by me when comparison fails is:
The variable1: '126991.55' is not the same as variable2: '126,991.55'! Please check manually!
Can anyone help me to remove the "," from first variable, I don't know which statement should be used to remove some specific chars(the chars I want) from a string or a variable..
Please can anyone help me?
I have an approximately same issue, the idea is that I am getting a value from DB which is assigned to a variable, e.g. Requested_Field.
the format of this value is e.g.: 126991.55 (it have an ".")
then to the second variable is assigned another value, which is got from the application, it's value is for e.g. the same but format is another: 126,991.55 (with "," and ".").
when I am comparing them, I'm getting an error, this is because the formats are different: the report added by me when comparison fails is:
The variable1: '126991.55' is not the same as variable2: '126,991.55'! Please check manually!
Can anyone help me to remove the "," from first variable, I don't know which statement should be used to remove some specific chars(the chars I want) from a string or a variable..
Please can anyone help me?