Available for SQL 2016 and above.

SELECT value
FROM STRING_SPLIT('abc, def, klasdklas, lkdld', ',')
WHERE value IS NOT NULL
AND RTRIM(value) <> '';

https://msdn.microsoft.com/en-us/library/mt684588.aspx