diff options
| author | Thomas G. Lockhart | 2000-08-23 13:44:14 +0000 |
|---|---|---|
| committer | Thomas G. Lockhart | 2000-08-23 13:44:14 +0000 |
| commit | 87523ab8db34859ae3fb980a3fab9f29dfc4c97a (patch) | |
| tree | 936d4af7164e81ebf487782addf440af47a99a7f | |
| parent | 8a35cbe1db808126b5285bdfbc115b6f0e393541 (diff) | |
Comment fixes from Larry Rosenman" <ler@lerctr.org>.
| -rw-r--r-- | contrib/mac/ouiparse.awk | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/contrib/mac/ouiparse.awk b/contrib/mac/ouiparse.awk index 63c264a9eac..8f2fd00c3d7 100644 --- a/contrib/mac/ouiparse.awk +++ b/contrib/mac/ouiparse.awk @@ -1,4 +1,4 @@ -# $Id: ouiparse.awk,v 1.1 2000/08/23 06:02:23 thomas Exp $ +# $Id: ouiparse.awk,v 1.2 2000/08/23 13:44:14 thomas Exp $ # # ouiparse.awk # Author: Lawrence E. Rosenman <ler@lerctr.org> @@ -10,10 +10,9 @@ # manufacturer text); # the table name is set by setting the AWK variable TABLE # -# we translate the character apostrophe (') to space inside the company name -# to avoid SQL errors. +# we translate the character apostrophe (') to double apostrophe ('') inside +# the company name to avoid SQL errors. # -# match ONLY lines that begin with 2 hex numbers, -, and another hex number BEGIN { TABLE="macoui"; @@ -27,6 +26,7 @@ END { printf "COMMIT TRANSACTION;"; } +# match ONLY lines that begin with 2 hex numbers, -, and another hex number /^[0-9a-fA-F][0-9a-fA-F]-[0-9a-fA-F]/ { # if (nrec >= 100) { # printf "COMMIT TRANSACTION;"; @@ -47,7 +47,7 @@ END { Company=Company " " $i; # Modify any apostrophes (') to avoid grief below. gsub("'","''",Company); - # Print out for the 'C' structure in mac.c + # Print out for the SQL table insert printf "INSERT INTO %s (addr, name) VALUES (trunc(macaddr \'%s\'),\'%s\');\n", TABLE,OUI,Company; } |