By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
WITH CTE AS (
SELECT value, ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS rn
FROM STRING_SPLIT(REPLACE(REPLACE('(0.0000, 3546.0000, 253422.000)', '(', ''), ')', ''), ',')
)
SELECT [1] AS Val1,
[2] AS Val2,
[3] AS Val3
FROM CTE
PIVOT (
MAX(value)
FOR rn IN ([1], [2], [3])
) p
| Val1 | Val2 | Val3 |
|---|---|---|
| 0.0000 | 3546.0000 | 253422.000 |