The extra space was intentional to replace double quotes with space to avoid trim. Also I had put the space manually in the file to try this out.

No, it did not work and that was the reason I took time to post it here. I have tried many options including substring.

I have spent almost a day trying to replace double quotes in SSIS derived column using replace:

My input file has header and I need to replace EXTRA double quotes with...