How to remove data from a csv file

Question

Help please!&nbsp;I am tying to create a keyword test which uses a variable from a csv file. The csv file contains serial numbers / ecodes however once an ecode has been used I want to remove it from the csv file so the next time I use the variable it doesnt try to use one that is no longer available.&nbsp;&nbsp;does anyone know a way where I can remove the first row of data from the csv file after I have used it in my test?&nbsp;I use this variable in numerous different tests too&nbsp;

hkim5 · Accepted Answer

one last suggestion would be to use a persistent project level variable as an integer value;

you can reference that value as an index, save a table(or column of those serial codes etc.) as another variable, and access one index value at a time, with an additional last step being incrementing the persisten project level variable.&nbsp;

now you can edit what you are typing in/setting text/etc.

&nbsp;
and when you click into that value panel, you can select your table variable, then select the cell, column (the names or serial numbesr etc.) and then the rows (project index variable)

&nbsp;
and then finally, you increment the value of the project index variable by 1, using a little code.

drag that script routine in as your last step in your keyword test, and now, everytime you run your test, this test will use the next "row" of the table variable storing whatever information you have, to type it in as you need.

tristaanogre · Answer

OK... a suggestion...&nbsp; Rather than altering your source CSV file, create another one that all it contains is a list of the encodes/serials that were used.&nbsp; Every time you use an encode, just write it out to the next line in that new file.
&nbsp;
So, then, at the start of your automation, you read BOTH files into your automation into temporary variables.&nbsp; Then, when you go to use an encode, first check to see if it has already been used. If so, skip and try the next one.&nbsp; If you ever need to reset, simply empty that "used" file and you'll start over.Now... that said...&nbsp; A more "complete" suggestion.
&nbsp;
Sanitize your test environment before every regression run.&nbsp; Basically, reset all the databases, etc., back to a baseline starting point.&nbsp; That way, each time you run it, you can use the same encode/serial each time and you won't have to worry about maintaining a list.&nbsp; Basically, you're setting up your environment then to always have the same conditions.&nbsp; It has the added benefit of predictability...that any comparisons you do, etc., can be against a fixed baseline rather than being a moving target of sorts.

tristaanogre · Answer

Marsha_R&nbsp;question is relevant because we need to know how you are reading in the values in the first place.&nbsp; Are you using the Data Driven operations of keyword tests?&nbsp; In that case, using the CSV file is a read-only, forward moving loop.&nbsp; To do what you want, you'll need to be able to write to the CSV which means you'll need to engage the CSV file using an aqFile method to open and write to the file.

marsha_r · Answer

How are you choosing which value to use from the .csv file?&nbsp; Are you just iterating through the rows?

marsha_r · Answer

And if you use that data-driven loop, there's no need to delete values, so if you aren't doing that, you should consider it.&nbsp;&nbsp;

jakemorley · Answer

Yeah just using the next one on the list just like it does when creating a data loop however I want to either remove the ones which have been used or remember which line is next when I restart the test or use the same variable on another test.

Hope that makes sense?

Forum Discussion

How to remove data from a csv file

8 Replies

Related Content

Strict removed from CucumberOptions

remove unneeded files

Comparing table data in IF not working

TcxListBox: How to add data at (row, column) or remove an Item?

backslash being removed

Recent Discussions

Keyword Test - Click - use -1, -1 by default?

How to import external node modules in TestComplete

convert absolute path to relative path

Multiple execution of a test plan with different values from an Excel table

Searching for mapped object took too much time msg