By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
WITH yourTable AS (
SELECT 1 AS id, '''Siemens'',''Simatic'',''Microbox'',''PC'',''27'',''6ES7677AA200PA0'',''6ES7'',''677AA200PA0''' AS val
),
cte AS (
SELECT id, value
FROM yourTable
CROSS APPLY STRING_SPLIT(val, ',')
)
SELECT id, STRING_AGG(value, ',') AS val
FROM cte
WHERE LEN(value) > 6
GROUP BY id;
| id | val |
|---|---|
| 1 | 'Siemens','Simatic','Microbox','6ES7677AA200PA0','677AA200PA0' |