Batch to remove commas, qoutes

The issue here is that you shouldn't have to edit a well-formed csv before you import it to SQL.
That aside, your sample doesn't contain a line with a comma, other than the ones used as delim, so we can't tell if there's anything special going on with your import format. It doesn't contain a line with double quotes either, but enough single quotes, so I assume these are meant to be replaced.
Now, if you save an Excel sheet as csv, it will by default enclose (only) fields that contain the delim in double quotes, and it will escape a double quote inside a field with a second double quote. The default delim is ";". Is that the case for your export as well?
Can your SQL import handle fields enclosed in double quotes?

For starters, here's a Powershell script; you can pass it a path of a file to process (wildcards accepted), default is all csv files in the current directory. It will add a prefix to the edited files, and will skip any files starting with that prefix.
You can change the $ReplacementList variable to your needs.
Save it as Whatever.ps1 and run it like that:

C:\Temp\Whatever.ps1 -Path "C:\Users\Wassim\Desktop\POD Updates\*.csv"

Select all Open in new window

Or, for example, process only a single file, and use "<TAB>" as the export delimiter:

C:\Temp\Whatever.ps1 -Path "C:\Users\Wassim\Desktop\POD Updates\Sample.csv" -ExportDelim "`t"

Select all Open in new window

[CmdletBinding()]
Param(
	[string]$Path = "$(Get-Location -PSProvider FileSystem).Path)\*.csv",
	[string]$ImportDelim = ",",
	[string]$ExportDelim = ";",
	[string]$ExportPrefix = "_Edited_",
	[string]$Encoding = "UTF8"
)
$ReplacementList = @{
	"'" = "_"
	"," = "_"
}
If (-not (Test-Path -Path $Path)) {
	Throw "No csv files found in '$($Path)'"
}
Get-Item -Path $Path |
	Where-Object {$_.Name -notlike "$($ExportPrefix)*"} |
	ForEach-Object {
		$OutFile = $_.DirectoryName + "\" + $ExportPrefix + $_.Name
		"Processing '$($_.FullName)' --> '$($OutFile)'" | Write-Host
		$FirstLine = Get-Content -Path $_.FullName -TotalCount 1
		$FieldCount = ([regex]::Matches($FirstLine, $ImportDelim + '(?=(?:[^"]*"[^"]*")*[^"]*\Z)')).Count + 1
		$Header = 1..$FieldCount | % {"Col_$($_)"}
		Import-Csv -Path $_.FullName -Delimiter $Importdelim -Header $Header -Encoding $Encoding |
			ForEach-Object {
				ForEach ($Column In $Header) {
					ForEach ($Replacement In $ReplacementList.GetEnumerator()) {
						$_.$Column = $_.$Column.Replace($Replacement.Key, $Replacement.Value)
					}
				}
				$_
			} |
			ConvertTo-Csv -NoTypeInformation -Delimiter $ExportDelim |
			Select-Object -Skip 1 |
			Set-Content -Path $OutFile -Encoding $Encoding
	}

Select all Open in new window