Boxes - Length Functions (legacy document)
1. Cut last words
Goal: Shorten text if length is exceeded by deleting complete words
Example:
26" Conti MTB Slick Reifen SportContact Continental Fahrradreifen Sport Contact 26" Mountainbike Slick Reifen Der Conti SportContact macht aus jedem 26 Zoll Mountainbike einen Renner. Natürlich kommt die Sicherheit nicht zu kurz. Sehr feine und widerstandsfähige Karkasse und SafetySystem-Pannenschutz Mountainbike Slick Reifen * Größe: ETRTO 42-559 * Dimension 26x1,6 * Empf. Luftdruck 4,0 bar * Max. Luftdruck 5,5 bar
Result (with max length 100):
26" Conti MTB Slick Reifen SportContact Continental Fahrradreifen Sport Contact 26" Mountainbike
2. Trim to 70 characters
Goal: Cut text after 70 characters (mid-sentence or mid-word). Useful for Google Merchant Center titles.
Example:
Der ContiPremiumContact 2 besitzt neuartige 3-D-Rillen. Die innovative Technologie dieser Profileinschnitte optimiert die Bremsleistung auf trockener und nasser Fahrbahn. Ein weiterer Vorteil der 3D-Rille: Durch das Zusammenwirken von steilen und flachen Flanken wird in den Rillen ein Drall erzeugt, der die Wasserableitung aus der Bodenaufstandsfläche beschleunigt.
Result:
Der ContiPremiumContact 2 besitzt neuartige 3-D-Rillen. Die innovative
3. Add Column if fits
Usage: Add columns and the respective value without exceeding maximum length.
Goal: You want to add "Color: dynamic value" to your title, but only if the result <70 characters
Example A:
Nike Sportswear Nike PRE Montreal Racer Trainers Size:11.5
Column: Color: Turquoise
Result A:
Nike Sportswear Nike PRE Montreal Racer Trainers Size:11.5
--> value not added as max length would be exceeded
Example B:
Wrangler Corynn Slim fit jeans Size:32x32
Column: Color: Turquoise
Result B:
Wrangler Corynn Slim fit jeans Size:32x32 Color: turquoise"
-> value added as max length not exceeded
4. Add Value if fits
Usage: This works exactly as above, except that the column heading (fixed value) will not be included, only the dynamic value (within the column). Here again, the value will only be added if the stipulated maximum length is not exceeded.
5. Cut first characters
With this box you can cut the first characters from your cell.
You have to fill in number of characters you want to cut off from the beginning. (you can use the dropdown)
2 cut off the first 2 signs
-2 cut everything except the last 2 signs
This box now will cut off the first 2 signs.
If you want to cut everything except a number of last signs, use negative numbers.
The -2 means, cut everything except the last 2 signs.
6. Cut last characters
This box works similar to the box Cut first characters.
If you fill in positive numbers (here 2), the last 2 signs will be cut off.
If you fill in negative numbers (here -2), everything except the last 2 characters will be cut off.