Posts: 1,199
Threads: 5
Joined: Nov 2008
Reputation:
0
08-11-2009, 10:33 AM
Hi egun,
Use cdbl instead of Trim while comparing will solve your issue
If cdbl(value5) = cdbl(value6) Then
Posts: 1,003
Threads: 1
Joined: Jul 2009
Reputation:
5
08-11-2009, 10:56 AM
Egun -
Are you importing the data from Excel Sheet ?? Because if you are entering the data into the datatable, Datatasheet blindly eliminates all the special charachters . Never mind, just curious to know.
Try this, I have modified your code.
Code:
DbTable("DbTable_4").Output CheckPoint("DbTable_4")
Browser("V").Page("V").WebElement("14,800.18").Output CheckPoint("14,800.18")
'here I'm getting 14800.18
value5 = Datatable.Value("DbTable_TAmount")
'here I'm getting 14,800.18
value6 = Datatable.Value("_charges_innertext_out")
value6 = Replace(value6, ",", "")
If Trim(value5) = Trim(value6) Then
foundC = True
Reporter.ReportEvent micPass, "found", "TAmount is correct."
Else
foundC = false
Reporter.ReportEvent micFail, "found", "TAmount is INCORRECT."
End if
Let me know if it worked or it helped you or this exactly what you were looking for.
Basanth
Give a fish to a man and you feed him for a day..Teach a man how to fish and you feed him for life.
Posts: 1,199
Threads: 5
Joined: Nov 2008
Reputation:
0
08-11-2009, 11:05 AM
great, Replace is also a good idea, But I feel, if we need to compare numeric values then we should use cdbl.
what say, Basanth27?
Posts: 1,003
Threads: 1
Joined: Jul 2009
Reputation:
5
08-11-2009, 11:18 AM
(This post was last modified: 08-11-2009, 11:21 AM by basanth27.)
Saket -
You know what, I looked at egun's code and saw that he was reffering closely to the numeric conversions. But if it deals or anything dealing with Currency formats etc..cdbl is an excellent option.
Thanks saket for bringing it up and sharing it.
Egun - You have 2 options now :-) pick your choice.
Unsure why i have no option to Edit..it throws a error. Just a quick snippet about CDBL.
This one from QTP Help...
Use the CDbl function to provide internationally aware conversions from any other data type to a Double subtype. For example, different decimal separators and thousands separators are properly recognized depending on the locale setting of your system.
This example uses the CDbl function to convert an expression to a Double.
Dim MyCurr, MyDouble
MyCurr = CCur(234.456784) ' MyCurr is a Currency (234.4567).
MyDouble = CDbl(MyCurr * 8.2 * 0.01) ' Convert result to a Double (19.2254576).
- basanth
Basanth
Give a fish to a man and you feed him for a day..Teach a man how to fish and you feed him for life.
Posts: 23
Threads: 9
Joined: Jul 2009
Reputation:
0
08-11-2009, 09:45 PM
Thank you both for your input - the CDbl function worked for me... I appreciate the help as always.
egun