I have added a Powershell step that removes the extra " chars.
I use the | symbol as field seperator which is a regex special char, so the regex expression has a \ in front of the | char to escape it.
Replace both when you're character is not an special char for regex.
[font="Courier New"]$ExportFileLocation = 'C:\MyCsvFilesLocation\Exports'
Get-ChildItem $ExportFileLocation -Filter *.csv | `
Foreach-Object{
#write-host $_.Fullname
(get-content $_.Fullname -ReadCount 0) -replace '(?<!\|)"(?!\||$)',''| set-content $_.Fullname
}
[/font]