Delete lines that match.

[Korelis]

I am trying to find a way in bash to delete all lines in a file that contains the backslash (\) . I tried using sed to delete the file out with the \\ to delete the lines but this does not appear to work.

sed /"ACC7575 NAS\Backup of files on X$,System State and Services Database\bob"/d

I am going to be making a script that will read a file full of these lines. I figured sed would be the easy one to do this.

[Franklin52]

Try:

grep -v '\\' file

Regards

[Franklin52]

If you prefer sed:

sed '/\\/d' file

Regards

[Korelis]

If you prefer sed:

sed '/\\/d' file

Regards

Let me clarify what I meant

Status:

 
ACCT00251 SERVER01\Backup of files on P$\administrator Thursday
ACCT00251 DC\Backup of System State \administrator Thursday
ACCT00251 SUA\Backup of files on D$\administrator Thursday
ACCT00253 BOB1\Backup of files on C$,D$\admin Thursday
ACCT00253 MIKE\Backup of Microsoft Exchange Server\admin Thursday
ACCT00253 RCLS03\Backup of files on C$,D$\admin Thursday

I have those lines in a file.

In another file I have a few lines that look like:
Exclusion:

ACCT00253 MIKE\Backup of Microsoft Exchange Server\backup_admin
ACCT00253 BOB1\Backup of files on C$,D$\admin

I want to delete any line in in the exclusion file that matches in the status file. I was trying to make sed delete the lines (I want to match the full line aside from the Day (in the example Thursday). But I was unable to get sed to delete anything because the file has \ and if I add \\ to the exlcude file it will still not delete the file.

[Franklin52]

Let me clarify what I meant

Status:

 
ACCT00251 SERVER01\Backup of files on P$\administrator Thursday
ACCT00251 DC\Backup of System State \administrator Thursday
ACCT00251 SUA\Backup of files on D$\administrator Thursday
ACCT00253 BOB1\Backup of files on C$,D$\admin Thursday
ACCT00253 MIKE\Backup of Microsoft Exchange Server\admin Thursday
ACCT00253 RCLS03\Backup of files on C$,D$\admin Thursday

I have those lines in a file.

In another file I have a few lines that look like:
Exclusion:

ACCT00253 MIKE\Backup of Microsoft Exchange Server\backup_admin
ACCT00253 BOB1\Backup of files on C$,D$\admin

I want to delete any line in in the exclusion file that matches in the status file. I was trying to make sed delete the lines (I want to match the full line aside from the Day (in the example Thursday). But I was unable to get sed to delete anything because the file has \ and if I add \\ to the exlcude file it will still not delete the file.

This deletes any line in the exclusion file that matches the first 2 columns in the status file:

awk 'NR==FNR{x[$1$2];next}$1$2 in x{next}1' Statusfile Exclusionfile

Regards

[ghostdog74]

awk 'BEGIN{ FS="\\" }
     NR==FNR{ a[$1$2]=$0;next}
     { if ( !( $1$2 in a ) ) print $1 }
     END { }' "statusfile" "exclusion"

[Korelis]

If the line exists in the exclusion file delete that line from the status file. I had a phone call while typing that post up. Sorry. I switched the exclusion and status file but it is not deleting right. I need the line to be an exact match to ensure we do not delete a similar line.

[Franklin52]

You can simply change the order of the 2 files like this:

awk 'NR==FNR{x[$1$2];next}$1$2 in x{next}1' Exclusionfile Statusfile

An exact match of the whole line in both files:

awk 'NR==FNR{x[$0];next}$0 in x{next}1' Exclusionfile Statusfile

Regards

[ghostdog74]

If the line exists in the exclusion file delete that line from the status file. I had a phone call while typing that post up. Sorry. I switched the exclusion and status file but it is not deleting right. I need the line to be an exact match to ensure we do not delete a similar line.

awk 'BEGIN{ FS="\\" }
     NR==FNR{ a[$0];next}
     { if ( !( $0 in a ) ) print $0 }
     END { }' "file2" "file"