CTHUB - GER phone number validation

[katerinkus]

Describe the task GER dataset contains phone numbers in the Phone Number column that could be anywhere from Canada. The number of digits should be 10 but it could have different formats (dashes, brackets, etc.). Optionally, the first three numbers should be checked against Canada's area codes to make sure they are valid. A warning should come up if a number is incomplete or has a non-existing area code.

Purpose It ensures that we have proper contact information.

Acceptance Criteria

• [x] Warning comes up if the number of digits is not 10 with the row index and the problematic phone number
• [x] Warning comes up if the area code does not exist with the row index and the problematic phone number (optional, it is not easy to find a good area code dataset)

Additional context

• Please see GER_notes_for Agile_team, section 6 for some regex ideas.
• Useful resource with area codes (but it is a bit confusing)

[ArawuSamuel1]

Hey team! Please add your planning poker estimate with Zenhub @emi-hi @tim738745

[shayjeff]

Tested