Welcome to Catalog Tips

Search more than 200 articles to learn more about creating and automating your product catalogs

Tip: Start typing in the input box for immediate search results.

Category - String manipulation

Articles

BASE64DECODE - Decode text from Base 64
BASE64ENCODE - Encode text as Base 64
CHAR - Convert number to character
CONCAT - Concatenate (join) separate strings
CONTAINSALL - Test if all specified strings are contained
CONTAINSANY - Test if any strings are contained
COUNTOF - Count string instances
DISTINCTLIST - Create unique list of values
FIELDSTR - Display contents of field
FIELDVAL - Display value of field
FORMATASTABLE - Format list as table
FORMATSTRBOOST - Format string using Boost
HTMLCLEAN - Clean raw HTML using HTML5 parsing
INDEXOF - Find character index of first instance of a string
LASTINDEXOF - Find character index of last instance of a string
LEFTSTR - Select characters from left side of field
LENGTH - Calculate the number of characters in a field
LITERAL - Supply string to function expecting field name
LOOKUP - Select matching value from another field
LOWER - Converts field contents to lower case
PARTSTR - Extract part of delimited list
REGEX - Search and replace string using regular expression
REGEXV1 - Search and replace string using regular expression
REMOVEBLANKLINES - Remove blank lines from string
REMOVEDUPLICATES - Remove duplicate values from string
REPLACE - Search for and replace text
RIGHTSTR - Select characters from right side of field
SENTENCECASE - Convert field contents to sentence case
SORT - Sort delimited string into ascending/descending order
STRIPWHITESPACE - Remove white space from string
SUBSTR - Select string of characters in a field
TITLECASE - Convert field contents to title case
TRUNCATESTR - Remove last N characters from string
UNIQUESTR - Return unique entries in a given string
UPPER - Convert field contents to upper case
URLDECODE - URL-decode a given string
URLENCODE - URL encode a given string
URLSTR - Retrieve a string from a URL
WORDWRAP - Word wrap a string to specified length
+ 31 Articles
Show Remaining Articles