Here's a quick patch for contrib/mac/ouiparse.awk to fix some commenting
changes due to Thomas' updates.
*** ouiparse.awk.old Wed Aug 23 01:02:23 2000
--- ouiparse.awk Wed Aug 23 07:44:09 2000
***************
*** 10,19 **** # 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. #
- # match ONLY lines that begin with 2 hex numbers, -, and another hex number BEGIN { TABLE="macoui";
--- 10,18 ---- # manufacturer text); # the table name is set by setting the AWK variable TABLE #
! # we translate the character apostrophe (') to double apostrophe ('') inside
! # the company name to avoid SQL errors. # BEGIN { TABLE="macoui";
***************
*** 27,32 ****
--- 26,32 ---- 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,53 **** Company=Company " " $i; # Modify any apostrophes (') to avoid grief below.
gsub("'","''",Company);
! # Print out for the 'C' structure in mac.c printf "INSERT INTO %s (addr, name) VALUES (trunc(macaddr
\'%s\'),\'%s\');\n", TABLE,OUI,Company; }
--- 47,53 ---- Company=Company " " $i; # Modify any apostrophes (') to avoid grief below.
gsub("'","''",Company);
! # Print out for the SQL table insert printf "INSERT INTO %s (addr, name) VALUES (trunc(macaddr
\'%s\'),\'%s\');\n", TABLE,OUI,Company; }
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 (voice) Internet: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749