anidata / ht-etl

Anidata 1.0: ETL and algorithm code.
0 stars 10 forks source link

Remove dashes/spaces in BackpagePhone table #3

Closed bmenn closed 7 years ago

bmenn commented 7 years ago

Per request from anidata/ht-archive#10, phone numbers should be stored without dashes, spaces, or other special symbols.

Tasks to do:

omnunum commented 7 years ago

I dont think we need a task for this since we can do this in sql and it only takes a second to run.

UPDATE backpagephone SET number = regexp_replace(number, '[-\n]', '', 'g');

This fixes up 100% of the records.

dlrobertson commented 7 years ago

Resolved by #12