Replace Function for Commas

can u share ur csv file?
'

use single quotes instead of double quotes in

 Replace(title, ',', ' ')

I tried a few combinations with the replace function, but nothing still seems to work.

I am also attaching a sample of one of the many csv files that my package processes.  

Thanks.  sample-csv-asrun.csv

Some of the media  may have several commas which creates a problem, since the file is a csv and the comma usually denotes a break in the field.  How can I by pass this error?

My current replace function is:

REPLACE(title,","," ")

And when I try the following replace function:

Replace(title, ',', ' ')

I get the following error message:

Error at Asrun Data Flow Task [Replace commas with space [230]]: Parsing the expression "Replace(title, ',', ' ')" failed. The single quotation mark at line number "1", character number "16", was not expected.

Error at Asrun Data Flow Task [Replace commas with space [230]]: Cannot parse the expression "Replace(title, ',', ' ')". The expression was not valid, or there is an out-of-memory error.

Error at Asrun Data Flow Task [Replace commas with space [230]]: The expression "Replace(title, ',', ' ')" on "input column "title" (245)" is not valid.

Error at Asrun Data Flow Task [Replace commas with space [230]]: Failed to set property "Expression" on "input column "title" (245)".

you can do it manually. Open your csv with microsoft excel.  When you will view this csv in excel you will not find comma (,) in file except for those columns which has multiple comma. In excel search for comma (,) and replace it with some other character.  then save this as new file and hen import this file.

It will work. I tried with your sample file and it worked.

Pragmatically how to do this i m not able to figure out yet.

For time being you can proceed like this until some expert gives you programmatic solution.

I understand that this can be done manually, but I have a client that won't do this, so I have to find a better solution to compensate for the problem.  I also have thousands of files that the client pulls for processing.  

Thank you!