When dealing with files exported from Paragon, It's became apparent fields are not properly escaped per RFC4180 Sections 2-6 and 2-7. This typically happens in remarks or comments. A real estate agent will enter a comma, tab or quote and generate extra columns for that particular row. Escaping these during export is very easy, however, trying to sort out which columns need to be recombined or excluded after the fact is exceedingly difficult and lowers the ability of the MLS user to use these files in third party applications. I was wondering if there was a way that this could be fixed? I've done what I can on my end, but only have about a 20% success rate at reconstructing malformed rows and have to exclude the rest.
For Refrence https://tools.ietf.org/html/rfc4180#s...