3

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 need to remove just the single quotes around Bob so that the outcome is:

"Robert Bob LaBla"

Tried REPLACE(Column,"\"","") which removes the double quotes perfectly but replacing this expression with single quotes doesn't seem to work. I'd rather not have to write a script for this. Any help is appreciated.

Hadi
  • 36,233
  • 13
  • 65
  • 124
ManMadeNova
  • 57
  • 2
  • 14

1 Answers1

2

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

Hadi
  • 36,233
  • 13
  • 65
  • 124