I am trying to parse an address for unstructured data that was scraped from a website. I think I have it just about figured out. The issue I am having is that when I use my 2000 record data only 1988 records are out put. I need all data to output. I see when the record count goes from 2000 to 1988 when the records are joined after splitting then to rows. I got that solution from another discussion question and I do have enough understanding of it to work out the issue.
