Hi all, I need a little help to extract all the string within and including the brackets and output them into separate columns and into a final table please. Here is an example of some of the fields in the source table.
CREATE TABLE TableName
(FieldName nvarchar(max))
INSERT INTO dbo.TableName
SELECT 'Urology Consultants OSSD (GSD)' UNION
SELECT 'Speech and Lang Speech Recdd (BSDF)' UNION
SELECT 'Psychology Con Speech Recdd (FD)' UNION
SELECT 'Immunology/Allergy Consultant (HRB)' UNION
SELECT 'Gastro Endoscopy Nurseses (HRB)' UNION
SELECT 'Histology-Cellular Pathology Speech Reced (WFSP)'
SELECT *
FROM dbo.TableName
I would like the output to be like the below.
thanks,
