Ssis Removing Single Quote Within Double Quotes

I am attempting to create a derived column that will remove single quotes surrounding a string that is also contained within double quotes. For example: 'Robert 'Bob' LaBla' I nee

Solution 1:

To remove single quotes in derived column just use the following expression:

REPLACE(Column,"'","")

If you need to remove both quotes then

REPLACE(REPLACE(Column,"\"",""),"'","")

References

• how to replace quotation marks in a derived column?
• REPLACE (SSIS Expression)