Convert a Currency value to number

[basanth27]

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.