Can somebody please help me. I'm trying to analyze a table and automatically delete all rows that are not numbers and leave only the rows that are numbers.
For example, my table might have the following data:
25
38
16
dgfdgafd
78
ukjdhg
12
How can I automatically delete "dgfdgafd" and "ukjdhg" from this example? I know I can loop through the table but I don't know what else to do.
Try looping backwards through the table (otherwise you will cut the branch between yourself and the tree ), check the cell contents on each row with IsNumber (Help-> Main Help-> Keywords-> String) and delete the row if it isn't.