String without the quotes

[tmcrouse]

I am trying to get the string that is within my quotes and not having any luck with the various ways I am attempting to do this. I have read only access so I cannot do a replace or update of the raw data. The raw data looks like this:



uniqueid memberfirst memberlast memberaddress membercity memberstate memberzip memberage dateofbirth
"111111" "john" "doe" "111 jones str" "Bronx" "ny" "10021" "25" "12/19/1965 00:00:00"

Don't ask me why the DBA built this table like this. None of the other tables are like this.

I have tried:

select distinct substring(uniqueid,'"','')
select distinct str$(uniqueid,'"','')
select distinct mid(uniqueid,'"','')



Nothing works

[orange]

Where is the raw data? You can import that kind of data into Access. I often import .txt or .csv files where the data is text and is quoted, and may have commas or Tabs or other character separating each field.

[tmcrouse]

It is in a SQL Server and the output has to remain in the SQL server. The tables that join on this one all have it like:

MemberTable
uniqueid memberfirst memberlast memberaddress membercity memberstate memberzip memberage dateofbirth
"111111" "john" "doe" "111 jones str" "Bronx" "ny" "10021" "25" "12/19/1965 00:00:00"

ConditionTable
uniqueid condition dateofservice outcome
111111 diabetes 01/01/2016 a1c eye and neph exam completed routing visits on a monthly basis to maintain normal levels

None of the other tables they have the " " and I cannot pull in any data on join because of this " " issue. I cannot export outside of the SQL Server. Rights for this are turned off. I know there is a way to query this just have not found it yet.

[June7]

Maybe use Replace function:

Replace([fieldname],"""","")