I hope this is the correct section for my question.
I need to paste 30 text files (they all have the same format, like 30 characters for the first column, 15 for the second one, and so on) one under the other and create just one text file, but each file has to be filtered in a different way (for example, if in the first file it says id=1002, delete that row). Which would you think would be the better way to do that? Each file has 20k rows, approximately.
We use the Microsoft package (Excel, Access, etc.) . The unified text file is going to feed an Access file.
What do you think would be better? Create the filters in the same Access, use a VBA script (or Python/C would have a much better efficiency?) or other program like SQL Developer? Any ideas would be helpful
Edit: I'm looking for recommendations about the software, not how to use it