I need to import data from a CSV file into a project. One import field is the description field which can contain carriage return and line feed, but this will break the import.
I thought of replacing the CR+LF with a some text token like <<CRLF>> and then replacing it after the import using direct SQL on the database.
Is there some better way? Surely this is a common problem?