Removing " " from a string response

[Shruti Sheopurkar]

Hello! I am working with survey data where some responses have been entered along with quotation marks. Is there a way to remove these quotation marks? Here's an excerpt:

* Example generated by -dataex-. To install: ssc install dataex
clear
input float n str54 old_sector1
504016 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504017 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504018 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504019 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504020 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504021 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504022 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504023 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504024 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504025 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504026 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504027 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504028 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504029 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504030 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504031 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504032 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504033 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504034 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504035 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504036 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504037 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504038 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504039 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504040 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504041 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504042 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504043 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504044 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504045 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504046 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504047 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504048 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504049 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504050 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504051 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504052 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504053 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504054 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504055 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504056 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504057 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504058 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504104 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504105 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504106 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504107 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504108 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504109 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504110 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504111 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504112 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504113 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504114 `""BSC-Banking, Financial services and Insurance (BFSI)""'
504115 `""BSC-Banking, Financial services and Insurance (BFSI)""'
end

What code can I use so that the variable old_sector1 appears without quotation marks, with just the text inside those quotes?

Thank you!!

[Joseph Coveney]

replace old_sector1 = subinstr(old_sector1, char(34), "", .)

[Shruti Sheopurkar]

Thank you! This worked perfectly