I am extracting data from files which has XML tags and New line characters withing the field. File Format as below
Field delimiter -comma
record delimiter - New Line
field surrounded by double quotes
can some one please let me know how do we read this fields? as one row becomes several rows because of new line character.
Row is as below in source file:
Code: Select all
"<?xml version='1.0'?>
<fcpMailFormat=\"normal\" fcpMode=\"substituteAd>