Natalie
Reputation: 21
Extracting text between delimiters in SQL
How do I extract all the value from a column separated by commas into a separate table? There could be up to 14 different values in the column.
Example:
2,8,5,10,12
Upvotes: 1
Views: 357
Answers (1)
Serge
Reputation: 4036
If you are using SQL Server 2016, then you may be in luck. You can use the STRING_SPLIT function.
Otherwise, it cannot be done easily.
Upvotes: 1
Related Questions
- Extracting string that only exists in certain rows and is between 2 different delimiters
- Extract String Between Two Different Characters
- Parse a string between 2 delimiters
- Extract some part of text separated by a delimiter using a regex
- Extract parts of string separated by delimiter
- Extract a part of string between multiple delimiters
- Extracting data between two delimiters in SQL Server?
- extract characters using delimiters
- Data extraction with multiple delimiters?
- Extract characters to the right of a delimited value in a SELECT statement