Fastload Reading Input File with Double Quotes

Tools & Utilities

Fastload Reading Input File with Double Quotes

I'm loading large volumes of data using Fastload. However the data fields are full of large amounts of old "uncleansed" data. The data is making it hard for FLD to recognize both the delimter and the end of a row (carriage returns in some fields). Data is now being exported with the column's enclosed in double quotes. Example:

"Col1"|"Col2"|"Col3"|"Col4"
"Col1"|"Col2"|"Col3"|"Col4"
"Col1"|"Col2"|"Col3"|"Col4"

Will Fastload work this way or is my only option to cleanse the data prior to running the load through a prior Unix/Extract script?

Thanks