Home » PlItems » String nach Delimenter zerlegen (MySQL)

String nach Delimenter zerlegen

ID236
Link ReferenceNot set
Link CreditsNot set
Link Technical DocumentationNot set
PlCodelangMySQL
PlGroupStrings
PlItemTitleString nach Delimenter zerlegen
Code-- Not a real solution, but a workaround if you have rights to create a function
-- see: http://blog.fedecarg.com/2009/02/22/mysql-split-string-function/
-- same problem with MSSQL.

CREATE FUNCTION SPLIT_STR(
StringToBeSplitted VARCHAR(255),
delimiter VARCHAR(12),
position INT
)
RETURNS VARCHAR(255)
RETURN REPLACE(SUBSTRING(SUBSTRING_INDEX(StringToBeSplitted, delimiter, position),
LENGTH(SUBSTRING_INDEX(StringToBeSplitted, delimiter, position -1)) + 1),
delimiter, '');

SELECT SPLIT_STR(string, delimiter, position);
Result Example