Shell Programming and Scripting

Hi,

I have an requirement where i need to remove few bad records(bad records I mean email id's are part of the 1st field, where a numeric value expected) from the text file delimited by ",".

file1.txt
---------
1234,,DAVID,MAX
abc@email.com,,JOHN,SMITH
234,,ROBERT,SEN

I need to remove all the lines which contains "email address in the 1st field" from the file

Please help me out.

Thanks in advance.

Code:

awk -F, '$1 !~ /@/' input_file

Code:

 awk -F "," '{if ($1~/@/) {$1=""}}1' OFS=","  file1.txt

---------- Post updated at 07:14 PM ---------- Previous update was at 07:13 PM ----------

Mine is wrong, this is correct.

Thanks Scott... it works fine....