how to transfer values from one big text file to another
Posted on 2004-11-24
I dont know where to place this question, but any ideas will be greatly apprecciated.
im having two text files- lets say A and B
A is having values like this
1 0 0 1
2 0 1 1
3 0 0 -4
4 0 0 -4
and B is having values like
1…1.4910967E+003 8.7261375E+002 1.1463431E+003 -3.0539021E+002 1.9476335E+002 -3.5904820E+002
so what i want is to bring the values from A into B where last number is less than zero, in the above example they are 3 and 4th rows. So i want to bring in the 3 and 4 into the B file.
the problem is i cannot import it into excel as the file has more than 65000 rows and also matlab cannot do this function.
can somebody tell me how i could achieve this....
I need only the correspording rows from the A file, and the chosed rows should build a new table, if possible in turn, with the original sequence. The A file has only a function, to help us to decide which row be useful in the second file