Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThis was quite difficult.
This was tough, and I definitely didn't find all the structures that would have helped me simplify my workflow.
My solution below:
I was so confident about this but the random inconsitencies absolutely killed me. I have four records that don't match the example output as i extracted the trailing numbers into the Phone column.
I'm not familiar enough with US addressing to know if this is some sort of extra postal code but looked like phone numbers to me
This is a great challenge. It took me so much time to compare my output with the solution output because my workflow gave me several more records than the answer and then I have to find out the abnormal records and adjust my regex_match formular to correctly flag the abnormal records. Teach me to carefully investigate the output file in real work situation when there is no standard answer there.