DataTable Issue

[VineethRPillai]

Hi Friends,

I have to do a data validation of an excel file. I imported the excel into QTP and I pull one value after another for checking the data.

The problem I am facing is that, the value which I pull from Datatable is picked as a string. Debugger shows the value in " ". If I use a TypeName function, it returns STRING always, even though the data is numeric..How can I handle this scenario??

Thanks in Advance

[venkatbatchu]

Hi,

U could use CINT(Datatable.Value("Paramaeter ID",Sheet ID")

Venkat.Batchu

[VineethRPillai]

But if the value coming in is a string, then CINT will throw an error...

[venkatbatchu]

If you are not familiar about the data type you are comparing then please pass the Cstr(Target) and Cstr(Source)

Please convert both target and source as strings then u will not face any issue.

Try with this, it will work.


Venkat.Batchu

[VineethRPillai]

Thanks Venkat...

The Real Scenario is diff.

Eg: I have a column in Datatable which is supposed 2 have only NUMBERS. (1000,1001...). Since I am picking the value frm DT, QTP picks it as "1000". And when I do a TypeName, it returns String although it is a number..

In general, any data(whether it is a NUMBER,STRING,DATE etc) that you pick up from DT will be returned as a STRING if I use TypeName.