I have a table with Memo fields that contain "dirty" unstructured data - characters within the fields include commas, quotes, html (<br>, etc.). These memo fields are used to display direction sets to physical locations (ex. 12345 Smith Street).
I need to export these fields in csv format for inclusion in an email.
However, I can't get these fields to export "nicely" - a single line per record set.
When I attempt to view the data using any number of editors (ultra edit, etc....even notepad), it's badly formatted.