Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThis took some time to tease out all the iterations of how data is presented. My workflow has a discrepancy for record #1252. After reviewing the data and looking at the presentation of the fax number for this company, it looks like the number at the end of the address is actually the phone number and not part of the address. I could have added to my last formula tool to remove this result and put it back on the address, but my results are correct as is and I am leaving the discrepancy. If I was creating this for production, I would have completed the data cleanse and made the phone/fax numbers in standard format.