Tasks from base

Converts a date of input with a specific input format in a specific output format.

Converts 20160201 (* according to ISO 0 → yyyy MM dd) in 2016-02-01 (* according to ISO → yyyy-MM-dd). The value is then stored back into §CURRENT.

Determines the current date in the specified format output.

Returns the name of the current day.

Returns the name of the currennt month.

Returns the current day of the week.

Returns the current day of the year.

Calculates an ISO 0 Date of Excel date (days since 01/01/1990).

Returns the current month:

Returns the current month name.

Is the MS Excel returns an integer value for an input ISO 0-date.

Returns the calendar week of the year for an ISO 0 date back:

Returns the current year:

2 - Without century

4 - With Century

Any mathematical calculation operations. For example: (7^4)-(2*3) +4

Decrease the counter by 1.

Divides the Input / Value.

Increase the counter by 1.

Comparing Input and comparator and provides the higher value.

For example,  CURRENT = 1 and Comparator = 2. The function returns 2 back.

Comparing Input and comparator and provides the higher value.

Returns the remainder of the division (modulo).

For example,  CURRENT = 3 and divisor = 2. THe function returns 1.

Multiplies two values.

Changes the sign. E.g. +5 -> -5

Rounds the entered value to the desired decimal:

Count is the digits after the decimal point.

Subtraction of input - value

Subtracting double figures: input - value

Summing input and value.

Sums double figures: input + value.

Sums float numbers: input + add value

Sums two integer values: input + add Value

Sums two long values: input + add Value

Negates the input value.

Returns the magnitude of a negative value.

Removes leading and terminal "White Spaces" such as tabs, spaces, and newline characters.

Is the character of a specified location within a string back.

Narrated by  CURRENT = test the character at position 1: Previous T

Concatenating two strings into a new string using the specified character as a delimiter.

Narrated by  CURRENT = test the new value test 01 back.

Direct concatenate two strings together into a new string. (Without delimiter)

Concatenating two strings into a new string with a space as a separator.

Depends on the input string part of a second string. The new string is stored in the specified variable (default:  CURRENT).

At CURRENT = Test. Returns the value: Reset TEST TE.

Returns TRUE and FALSE. Finds the in specified search string in input .

Checks if a string to the value of, endstring 'ends. If the string ends with the specified value, TRUE is returned, otherwise FALSE.

Attaches a fill character to a given string until the desired length is reached. Based on the given direction, characters are attached to the character string on the left or right.
If the string is longer than the desired length, the method returns the original string back

Returns the substring at the specified index. For index 0, the last part is returned. is the position of the back track levels substring (index 0 is the last). splitchar is the separator to be used.

Returns the index to within the string of the first occurrence of the specified substring.

Returns the index within this string of the rightmost occurrence of the specified string.

Removes leading "white spaces" such as tabs, spaces, and newline characters.

A special task for merging several source strings that are to be mapped as a value in a target field. This task can only be used in conjunction with "additionals".

The function inserts a character string into an existing one. The existing content is overwritten and filled to the specified length with blanks.

removeAll

Removes all occurrences of remove string in input.

Removes the first occurrence of string remove in input.

Removes every occurrence of a newline character (CRLF) from the given string.

Replace all occurrences of based on a passed regular expression found substring with the given replacement string.

This task takes in the string in the parameter "Input" values from the substitution list specified in the parameter "replacementMap" and replaces it with the listed replacement values. It will replace all occurrences found. The final string is stored in the parameter "StoreIn" In order to replace, for example, German umlauts in a string the following assignment list are used: 

replaceAllMap(„ö:oe,ä:ae,ü:ue,ß:ss,Ö:OE,Ä:AE,Ü:UE")

Replaces the first occurrence of based a passed regular expression found substring with the given replacement string.

 This task compares the string in the parameter input with the comparison values from the Replace Map. When a comparison value matches, the associated replacement value in storeIn is stored.
Fits no comparison value, so the value Else in storeIn is written.

(compare_value:replacement_value,compare_value2,replace_value2...,else_value)

Removes terminal "white spaces" such as tabs, spaces, and newline characters.

Checks if a string with the value of "start string" begins. If the string starts with the specified value, TRUE is returned, otherwise FALSE.

Extracts a part string from the position set in 'start' to the end position of the input string.

Extracts the left part of the input string with a given length and returns it as a new substring.

Extracts the right part of the input string with a given length and returns it as a new substring.

Extracts a part of a string beginning with the in "start" you passed up to the specified end position of the input string.

Extracts a substring from a given string, beginning with the set start index in the specified length.

Converts string to lowercase.

Converts string to uppercase.

Removes leading zeros.

Removes terminal zeros.

Converts an input to the corresponding output format.

Returns the current time back in the desired output format.

Returns either a UNIX or a DB timestamp back.