The current file has phone numbers in column 3, or 4 or both, and sometimes they’re the same, and sometimes they’re different. A valid telephone number from this file is nnn-nnn-nnnn.
cat blacklist.csv | awk -F"," '{print $3 "\n" $4}' | sort -u | grep "[0-9][0-9][0-9]-[0-9][0-9][0-9][0-9][0-9][0-9][0-9]" | wc -l
5525
So, of all the numbers in the current file, there are only 5525 unique ones.
I started this discussion with the Superfecta folks, and the conclusion over there was that the spam functionality over there wasn’t so good:
It would work, but the spam interception aspects of Superfecta have not been
well maintained, so that would have to be fixed before effort was put into
making the FCC list work. My gut feeling is that implementing the robocall list
would best be done independently of Superfecta.
It seems to me that the database lookup in Superfecta should certainly scale well into the several thousands of records… but I don’t know what might be broken with the spam aspects of Superfecta. Does anyone here know?
Adam