String


In this article, you will learn all about the nineteen functions related to “String”. To be precise, we will discuss the following functions:


Concat

Concatenate given values to one string

Select the elements and/or specify constants you want to concatenate to one string

Lowercase

Transform all characters to lowercase

Select the element you want to convert to lowercase

Normalize Space

Strips leading and trailing whitespace from a string and replaces sequences of whitespace characters by a single space

Select the element for which you want to remove unnecessary whitespace

Pad Left

Add characters on the left side of your string to reach a specified length

srcValue:


length:


character:

Select the element you want to extend on the left

Specify the total length of your resulting string

Specify the character that should be used to pad with. (Default = space)

Pad Right

Add characters on the right side of your string to reach a specified length

src Value:


length:


character

Select the element you want to extend on the right

Specify the total length of your resulting string

Specify the character that should be used to pad with. (Default = space)

Regex Replace

Replace any searched patterns with a specified string

value:


regex:



replaceStr:

Select the element in which the search and replacement will occur

Use regular expession language to search for specific text or patterns within the element

Specify how you want to replace the predefined part of the element.

Replace

Replace all occurances of a specified character(set)

value:


oldValue:


newValue:

Choose the element for which you want replacements

Specify the value you want to replace

Specify the value you want oldValue to be replaced with

String Join

Join multiple elements using a separator

separator:



ignoreIfEmpty:

Specify the character(s) with which you want to separate the elements / constants

Check if you want to ignore empty elements to avoid unnecessary elements

Select the elements / constants you want to join

String Left

Keep the first specified number of characters from the element

srcValue:


nofChar:

Specify the element you want to shorten

Specify the number of characters you want the element to be

String Length

Specify the number of characters of your element

Select the element of which you want to calculate the length of

String Right

Keep the first specified number of characters from the element

srcValue:


nofChar:

Specify the element you want to shorten

Specify the number of characters you want the element to be

Strip Leading Zeroes

Strip all leading zeroes

Select the element for which you want to strip all leading zeroes

Strip Trailing Zeroes

Strip all trailing zeroes

Select the element for which you want to strip all trailing zeroes

Substring After

Select the value after the first match of the specified searchStr

srcValue:


searchStr:



mustFind:

Specify the element you want a substring of

Specify the character that marks the start of your substring (the specified character is excluded)

Check if you want an error to be thrown if there is no match

Substring Before

Select the value before the first match of the specified searchStr

srcValue:


searchStr:



mustFind:

Specify the element you want a substring of

Specify the character that marks the end of your substring (the specified character is excluded)

Check if you want an error to be thrown if there is no match

Substring

Select a specified number of characters of an element after startIndex

srcValue:


startIndex:


length:

Specify the element you want a substring of

Specify the amount of characters after which your substring begins

Specify the length of your substring

Trim End

Trim all occurances of one specified character from the end of an element

character:


srcValue:

Specify the character you want to trim

Specify the element from which you want to trim the specified characters

Trim Start

Trim all occurances of one specified character from the start of an element

character:


srcValue:

Specify the character you want to trim

Specify the element from which you want to trim the specified characters

Uppercase

Transform all characters to uppercase

Select the element you want to convert to uppercase

Leave a comment