Rob de Vos (5/29/2015)

---

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]