eBiss 3 en:transformation:mappings:funktionen:string

Char

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

Char The function Char () is primarily intended for entering special characters. For example, to enter a line feed in the mapping, use Char (10), for a carriage return Char (13). It is not possible to enter a string, e. g. by' \r\n', because the backslash is masked.

concat

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

concat The function concat () assembles any number of strings. Syntax: concat('string1', 'string2', 'string3', ...) returns: string1string2string3 Sample: concat('000', @SupplierGLN) Here, the SupplierGLN is preceded by three zeros.

contains

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

contains The contains() function checks whether the second text is inside the first text. If this is the case, the logical (boolean) value true is returned, otherwise false. Note: If one parameter is empty or null, e.g. an X-path expression is not set, then it is interpreted as an empty text.

ends-with

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

ends-with The ends-with() function checks whether a string (string1) ends with a specific character or a particular substring (string2). If this is the case, true, otherwise false will be returned. Syntax: ends-with('string1', 'string2')

Extract

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

Extract The Extract () function takes a value from the specified string that is determined by the regular expression to be specified as a parameter . \ Syntax: Extract(string, regular expression) Note: In the RegEx,a so-called Capturing Group has to be determined. A capturing group is enclosed with the round brackets.

FixString

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

FixString The function FixString ()/ takes a String and the String length and additionally takes the direction (' l' left/' r' right) and returns the corresponding substring as result. Syntax: FixString('String','length', 'direction') Samples: FixString('ABCDEFG', '3', 'r')

HtmlStrip

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

HtmlStrip The HtmlStrip () function removes HTML markup from a given string. Verwendung: HtmlStrip($s) Sample: HtmlStrip("

blablahuhuhaha

blubber") returns: „Blabla huhu haha blubber“

LCase

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

LCase The LCase () takes a string and returns it in lower case. \ Numerical values and special characters are returned unchanged. Syntax: LCase('String') Sample: LCase('TEST') returns test

Match

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

Match The Match() function checks the input string for a match to a regular expression, see also Regular Expressions. Syntax: Match(string, regular expression) Samples: Match('test abc: 123', '.*abc') returns true Match('test abc: 123', '3.0$') returns true Match('test abc: 123', '\d+')

PadString

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

PadString The function PadString() is passed a string, the number of characters and the characters themselves as parameters and returns the string filled with the characters up to the specified number. Furthermore, a direction can also be specified from which the filling is to be carried out.

RemoveLetters

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

RemoveLetters The RemoveLetters () function removes all non-numeric characters from a string. caution: also special characters will be removed! Note: The function returns errors if the function parameter is zero. This means, for example, you have to check with a ruleset whether the data element exists and only then use the function.

RemoveZero

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

RemoveZero The RemoveZero () function removes all zeros preceding a string. Syntax: RemoveZero('Number') Sample: RemoveZero('00L01256523') returns L01256523

Replace

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

Replace The Replace () function gets a string, the string to be replaced and optionally the new string as a parameter. As a result, this function returns the string with the replaced string. If the third parameter is not specified, the character to be replaced is replaced by an empty string.

Split

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

Split The function Split() breaks a string separated by a separator. The function parameters are: * the String to be split * the separator character * the position The third parameter (position) represents the part that is to be returned as a result. This parameter is optional, if it is not specified, the function automatically returns the first part of the string.

SplitToArray

Anonymous (anonymous@undisclosed.example.com) — 2025-03-12T18:06:31+00:00

SplitToArray The SplitToArray function splits a string according to a list of separators and returns a structure that allows iteration in the RuleSet. Syntax: SplitToArray ('string','separator/string', boolean, boolean,) Parameters: * String which is to be split.

String functions

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

String functions All functions related to the processing or use of character strings. Topics string index

starts-with

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

starts-with The Starts-with () function checks whether a string (string1) begins with a specific character or substring (string2). If this is the case, true, otherwise false will be returned. Syntax: starts-with('string1', 'string2')

string-length

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

string-length The stringlength() function returns the length of a string. Syntax: string-length('string')

substring-after

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

substring-after The substring-after() function returns that part of an input string that follows the first occurrence of a comparison string in the input string. The comparison string should consist of at least one single character or a character string.

substring-before

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

substring-before The substring-before() function returns that part of an input string that precedes the first occurrence of a comparison string in the input string. The comparison string should consist of at least one single character or a character string.

substring

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

substring The substring() function extracts part of a string. Syntax: substring('String', 'Start', 'Length') Sample substring(@SupplierGLN,1,2) Here, a two-digit substring is extracted from the first character and returns the first two digits of the

Trim

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

Trim The Trim () function gets a string and the position at which spaces are to be removed is passed as a parameter and returns this string without any relevant spaces. Syntax: Trim('String', 'Positions') Possible positions are * l for left-sided blanks,

UCase

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:18+00:00

UCase The function Ucase() accepts a string and returns this string in capital letters. Numeric values and special characters are displayed unchanged. Syntax: UCase('String') Sample: UCase('test') returns TEST