Follow along with the video below to see how to install our site as a web app on your home screen.
Anmerkung: This feature currently requires accessing the site using the built-in Safari browser.
@name_tmp := TRIM(name), -- Variable name_tmp mit Spalte name befuellen
CASE WHEN (RIGHT(@name_tmp, 5) = 'today') THEN @name_tmp := TRIM(SUBSTRING(@name_tmp, 1, CHAR_LENGTH(@name_tmp) - 5)) END,
CASE WHEN (RIGHT(@name_tmp, 6) REGEXP '[0-9]{6}') THEN @name_tmp := TRIM(SUBSTRING(@name_tmp, 1, CHAR_LENGTH(@name_tmp) - 6)) END,
CASE WHEN (RIGHT(@name_tmp, 5) REGEXP '[0-9]{5}') THEN @name_tmp := TRIM(SUBSTRING(@name_tmp, 1, CHAR_LENGTH(@name_tmp) - 5)) END,
CASE WHEN (RIGHT(@name_tmp, 4) REGEXP '[0-9]{4}') THEN @name_tmp := TRIM(SUBSTRING(@name_tmp, 1, CHAR_LENGTH(@name_tmp) - 4)) END,
CASE WHEN (RIGHT(@name_tmp, 3) REGEXP '[0-9]{3}') THEN @name_tmp := TRIM(SUBSTRING(@name_tmp, 1, CHAR_LENGTH(@name_tmp) - 3)) END,
CASE WHEN (RIGHT(@name_tmp, 2) REGEXP '[0-9]{2}') THEN @name_tmp := TRIM(SUBSTRING(@name_tmp, 1, CHAR_LENGTH(@name_tmp) - 2)) END,
CASE WHEN (RIGHT(@name_tmp, 1) = '-') THEN @name_tmp := TRIM(SUBSTRING(@name_tmp, 1, CHAR_LENGTH(@name_tmp) - 1)) END,
CASE WHEN (CONCAT('', RIGHT(@name_tmp, 6)) REGEXP '[0-9]{6}') THEN @name_tmp := TRIM(SUBSTRING(@name_tmp, 1, CHAR_LENGTH(@name_tmp) - 6)) END,
CASE WHEN (CONCAT('', RIGHT(@name_tmp, 5)) REGEXP '[0-9]{5}') THEN @name_tmp := TRIM(SUBSTRING(@name_tmp, 1, CHAR_LENGTH(@name_tmp) - 5)) END,
CASE WHEN (CONCAT('', RIGHT(@name_tmp, 4)) REGEXP '[0-9]{4}') THEN @name_tmp := TRIM(SUBSTRING(@name_tmp, 1, CHAR_LENGTH(@name_tmp) - 4)) END,
CASE WHEN (CONCAT('', RIGHT(@name_tmp, 3)) REGEXP '[0-9]{3}') THEN @name_tmp := TRIM(SUBSTRING(@name_tmp, 1, CHAR_LENGTH(@name_tmp) - 3)) END,
CASE WHEN (CONCAT('', RIGHT(@name_tmp, 2)) REGEXP '[0-9]{2}') THEN @name_tmp := TRIM(SUBSTRING(@name_tmp, 1, CHAR_LENGTH(@name_tmp) - 2)) END,
@name_tmp AS name, -- bearbeitetes name_tmp als name rausholen