UNIX for Dummies Questions & Answers

Hi,

I want to use the sed command to delete some lines in a file and I was wondering whether there is a possibility of knowing which lines are deleted, or at least which line numbers.

Thanks

Maybe it's easier with awk for a job like this. What are the conditions to delete a line?

Regards

Hi,

I'm not familiar with awk, but if that's better then fine!

Basically I need to delete any lines which contains records from a SQL output.

Here is what I started coding (I'm posting only the part I need help with):


...
sqlplus -s $APPS_USR/$APPS_PWD <<ENDOFSQL
SET HEADING OFF;
SET FEEDBACK OFF;
SET LINESIZE 300;
SELECT banque, guichet, compte
FROM (select abb.bank_number banque,
abb.bank_num guichet,
abaa.bank_account_num compte,
rbi.import_date date_dernier_import,
row_number() over (partition by rbi.bank_account_id order by rbi.import_date desc) rn
from ap.ap_bank_accounts_all abaa,
ap.ap_bank_branches abb,
rb.rb_bank_accounts_all rbaa,
rb.rb_batch_import rbi
where rbaa.bank_account_id = abaa.bank_account_id
and abb.bank_branch_id = abaa.bank_branch_id
and rbi.bank_account_id = rbaa.bank_account_id
and rbaa.status = 'Y'
)
WHERE rn = 1
AND date_dernier_import > add_months(sysdate, -2);
ENDOFSQL
} | while read ligne
do
if [ "$ligne" ] # Ligne non NULL
then
set $ligne
banque="$1"
guichet="$2"
compte="$3"

sed '/'"$banque"'.*'"$guichet"'.*'"compte"'/ !d' < $fich_src > $fich_dest
cp $fich_dst $fich_src
fi
done
...

So I'd like to log which line numbers have been deleted.

Thanks

You also can use a grep command between the sed and cp command in this case (output in "deleted.log"):

Code:

sed '/'"$banque"'.*'"$guichet"'.*'"compte"'/ !d' < $fich_src > $fich_dest
grep -v -n -f $fich_dest $fich_src > deleted.log
cp $fich_dst $fich_src

Instead of the sed command you can try this with awk (not tested), the deleted lines are in the file "deleted.log":

Code:

awk '/'"$banque"'.*'"$guichet"'.*'"$compte"'/{print;next}{print NR, $0> "deleted.log"' < $fich_src > $fich_dest

Regards

I hadn't thought of using grep just after to identify deleted records.

Thanks!