Get a specific value of a string_split in MSSQL

Asked Dec 12 '22 at 17:38

Active Dec 12 '22 at 18:00

Viewed 231 times

I have a string like this

0011.06.123.7-0

SELECT STRING_SPLIT(NUMBER,'.')

returns

And now I only and always need the third value, in this case '123' How do I select this proberly?

I already tried to get the third value with the Rownumber, but that didn't worked out.

edited Dec 12 '22 at 18:00

Thom A

asked Dec 12 '22 at 17:38

Waren Schild

For `STRING_SPLIT`, you must be using SQL Server 2022+. – Thom A Dec 12 '22 at 17:39
Have you considered parsename() ? – John Cappelletti Dec 12 '22 at 17:39
I have found a function named "SPLIT_PART" for postgreSQL, is there an equivalent in mssql? – Waren Schild Dec 12 '22 at 17:40
Working example of parsename() Select parsename('0011.06.123.7-0',2) Provided you don't have more than 4 segments – John Cappelletti Dec 12 '22 at 17:41
1

Note that the solution with `PARSENAME` *assumes* that there will *always* be 3 delimited values; if you have a variable amount it may not be appropriate, and simply won't work if you have 5+. – Thom A Dec 12 '22 at 17:42

0 Answers0