Hi all,
I've given up trying to test the right RegEx syntax for cleaning some raw Address values. What I would to do is match non-standard values and NULL them. So I would like to RegEx match any record that has an alpha AND numeric, not either or. So Example is:
| Address | Clean_Address |
| pobox | NULL |
| 123 | NULL |
| pobox 123 | pobox 123 |
| 123 Sesame St. | 123 Sesame St. |
| . | NULL |
| needed | NULL |
Any help would be greatly appreciated. Thank you!
