Micro Focus QTP (UFT) Forums
How to verify data from UNIX file - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: How to verify data from UNIX file (/Thread-How-to-verify-data-from-UNIX-file)



How to verify data from UNIX file - syhusain - 05-18-2011

Hello,
I am new to QTP and working on script that need to compare data from UNIX file with DB tables. Could someone help me confirm if QTP allows UNIX file data comparison with DB.


RE: How to verify data from UNIX file - deepaksporty - 05-19-2011

Hi,

First of all QTP directly does not allow UNIX operations
Here is what I can think of:

1. First of all you need to ftp data or files (ASCII mode) to Windows text file and then make it compatible with windows file structure. Unix does not have CRLF.
2. Then you need to Connect to Database which you're using. may be copy the data which you need to compare in a variable or file
3. Use vbscript's string manipulation functions to compare data.

let me know if that helps
Deepak