Using a csv file with embedded CR/LF

[Mike Cunningham <mike.cunningham@xxxxxxx>]

I have to load a csv file I am getting from a 3rd party into an iSeries database. The csv file files are correctly comma separated and double-quoted but in one large text string there can be embedded carriage return/line feeds and the same is used to end the record. The large text string is within double quotes but CPYFRMSTMF still sees the CR/LF within the double quotes and takes that as the end of record which results in one record in the csv file becoming multiple records in the file that is used in the TOMBR parameter in the CPYFRMSTMF. None of the options for ENDLINFMT appear to work.  Is there some trick to getting CPYFRMSTMF to do what I need? I do need the embedded CR/LF characters included in the database field so the text appears correctly when it is displayed on a web page. Will I need to read the csv file and do my own parsing of the data to split out each field as needed?