Actions
Feature #14718
closed
Prepared Statement: QLEFT(), QRIGHT()
Start date:
12.09.2022
Due date:
% Done:
100%
Estimated time:
Discuss:
Prio Planung:
No
Vote:
Description
Eine Funktion, vergleichbar mit LEFT, RIGHT, die wenn der String laenger ist als len, diesen abschneidet und '...' anhaengt.
Updated by Carsten Rose over 1 year ago
# Routine name: QRIGHT
# Parameters: input text, maxlen int
BEGIN
DECLARE output TEXT;
IF maxlen < 1 THEN
SET maxlen = 1;
END IF;
IF CHAR_LENGTH(input) > maxlen THEN
SET output = INSERT(input, maxlen+1, CHAR_LENGTH(input)-maxlen, '...');
ELSE
SET output = input;
END IF;
RETURN output;
END
# Routine name: QLEFT
# Parameters: input text, maxlen int
BEGIN
DECLARE output TEXT;
IF maxlen < 1 THEN
SET maxlen = 1;
END IF;
IF CHAR_LENGTH(input) > maxlen THEN
SET output = INSERT(input, 1, CHAR_LENGTH(input)-maxlen, '...');
ELSE
SET output = input;
END IF;
RETURN output;
END
Updated by Carsten Rose over 1 year ago
- Status changed from New to Closed
- % Done changed from 0 to 100
Applied in changeset typo3-qfq|154f80bd73726ef38a5d7078ebc473ec4cc2d0af.
Updated by Carsten Rose over 1 year ago
- Target version changed from 385 to 22.9.1
Actions