How to use string_split with multiple delimiter

Question

Suppose the string values are separated by different delimiters like ',' '&' ';', then could we use string_split in this case?

Answer 1

Hi @Lylyy

could we use string_split in this case?

Yes, you could use Replace to turn these different delimiters to same and then use String_split.

Please check this sample:

DECLARE @string varchar(max) = 'AAA, BBB & CCC DDD;EEE'    

SELECT * 
FROM STRING_SPLIT(REPLACE(REPLACE(REPLACE(@string,' ',','),';',','),'&',','),',')
WHERE value <> ''

Best regards,

Cosmog Hong