Contributions
Reading from .txt file and writing results to excel spreadsheet.
Hi guys, I am attempting to read text from a .txt file and write the results to a excel file. I can get a script to write to testcompletes log, but the text comes out looking like jibberish. I am using VBscript. Thanks.1.5KViews0likes1Comment- 1.3KViews0likes0Comments
Retrieving data from Excel table column and inputting into form.
Okay, so I can get Excel data easily input into a form(textbox) if the column isnt missing any data . My column is a middle name column and some people dont have middle names so that space is left blank. I am having trouble getting Test complete to pass over the textbox and continue looping if there is no data in the excel table for that specific middle name cell. I have tried making "If....Then" statements but I cant seem to get them to work in this situation properly. I can make them work but only for one middle name at a time, for example: If middle name : "timothy" is in Excel table column "Middle Name" use that, else: go on to next text box I could technically make like 50 if statements for all people but I know there has to be another way. Again, I want to pass over the middle name text box if there is no data in Excel for that particulare person. Otherwise TestComplete stops looping and just sits there with the cursor on the middle name box. I am doing this with a keyword test, and have been using the software for 6 days so any detailed instructions on how to accomplish this would be very GREATLY appreciated. Thanks!Solved2KViews0likes2CommentsVerifying data from a form that has change slightly
Hello, I have been using Test Complete for about 7 days so please go easy on me. I am using a keyword test and I have a form that has a text box where a telephone number is input. Now the thing is, I can have a data loop input(from excel table) "7045675678" and the text box will accept it. The problem is that the textbox will auto format the number to: 704-567-5678. I cannot change this auto formatting. Thus, when I use a property checkpoint to compair it against the excel file it fails because 704-567-5678 does not equal 7045675678(which is stored in the excel file) I am a little shaky on using actual "code" so if that is required please insturct me on how to implement it. Thanks!1.7KViews0likes4Comments