String manipulation

BASE64DECODE – Decode text from Base 64

105 views June 1, 2018 admin 0

BASE64ENCODE – Encode text as Base 64

106 views June 1, 2018 admin 0

CHAR – Convert number to character

115 views June 1, 2018 admin 0

CONCAT – Concatenate (join) separate strings

668 views June 1, 2018 admin 0

CONTAINSALL – Test if all specified strings are contained

124 views June 1, 2018 admin 0

CONTAINSANY – Test if any strings are contained

368 views June 1, 2018 admin 0

COUNTOF – Count string instances

165 views June 1, 2018 admin 0

DISTINCTLIST – Create unique list of values

400 views June 1, 2018 admin 1

FIELDSTR – Display contents of field

831 views June 1, 2018 admin 0

FIELDVAL – Display value of field

366 views June 1, 2018 admin 0

FORMATASTABLE – Format list as table

167 views June 1, 2018 admin 0

FORMATSTRBOOST – Format string using Boost

125 views June 1, 2018 admin 0

HTMLCLEAN – Clean raw HTML using HTML5 parsing

218 views June 1, 2018 admin 1

INDEXOF – Find character index of first instance of a string

216 views June 1, 2018 admin 0

LASTINDEXOF – Find character index of last instance of a string

132 views June 1, 2018 admin 0

LEFTSTR – Select characters from left side of field

296 views June 1, 2018 admin 0

LENGTH – Calculate the number of characters in a field

147 views June 1, 2018 admin 0

LITERAL – Supply string to function expecting field name

132 views June 1, 2018 admin 0

LOOKUP – Select matching value from another field

262 views June 1, 2018 admin 0

LOWER – Converts field contents to lower case

169 views June 1, 2018 admin 1

PARTSTR – Extract part of delimited list

679 views June 1, 2018 admin 1

REGEX – Search and replace string using regular expression

354 views June 1, 2018 admin 0

REGEXV1 – Search and replace string using regular expression

279 views June 1, 2018 admin 0

REMOVEBLANKLINES – Remove blank lines from string

181 views June 1, 2018 admin 0

REMOVEDUPLICATES – Remove duplicate values from string

289 views June 1, 2018 admin 0

REPLACE – Search for and replace text

199 views June 1, 2018 admin 0

RIGHTSTR – Select characters from right side of field

235 views June 1, 2018 admin 0

SENTENCECASE – Convert field contents to sentence case

165 views June 1, 2018 admin 0

SORT – Sort delimited string into ascending/descending order

139 views June 1, 2018 admin 0

STRIPWHITESPACE – Remove white space from string

274 views June 1, 2018 admin 0

SUBSTR – Select string of characters in a field

365 views June 1, 2018 admin 0

TITLECASE – Convert field contents to title case

241 views June 1, 2018 admin 0

TRUNCATESTR – Remove last N characters from string

116 views June 1, 2018 admin 0

UNIQUESTR – Return unique entries in a given string

93 views June 1, 2018 admin 0

UPPER – Convert field contents to upper case

257 views June 1, 2018 admin 0

URLDECODE – URL-decode a given string

78 views June 1, 2018 admin 0

URLENCODE – URL encode a given string

98 views June 1, 2018 admin 0

URLSTR – Retrieve a string from a URL

528 views June 1, 2018 admin 1

WORDWRAP – Word wrap a string to specified length

107 views June 1, 2018 admin 0