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 |