Hi all....I'm using awk to validate a csv file, but now I've been told to delete any invalid lines from the file.. Im not sure what the best way to do this is?

Would it be to create a temp file say "csv_temp.tmp" file and print all the valid records to that temp file. Then delete the old file "csv_file.csv" and rename the temp file to "csv_file.csv"?

is this an efficient way of doing this? any code snippets of kind of file manipulation would be greatly appreciated?

Kind Regards

Satnam

If this is real data, then consider writing the data into two files: good.csv bad.csv
Then when someone asks 'What did you exclude?' - bad.csv has your answers.

Hi jim, thanks for the feedback always useful stuff!

cheers

can i know how i can delete a particular record from a 1 million record file using awk?