Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Name
Chr
Syntax
Chr (Integer asciiValue)
Purpose
To return a single-character string converted from a specified integer ascii value.
Description
Returns a single-character string that contains the character representing the specified ASCII value.
Return Type
String
Parameters
asciiValue [System.Int32] – Ascii value to be converted into string
Example
In this example, we are passing the required parameter to the function transformation object using a Variables object.
Where,
asciiValue = 40
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned a string value converted from a specified ASCII value.
Name
Concatenate
Syntax
Concatenate (String str1, String str2)
Purpose
To concatenate two strings and return the result.
Description
Returns the concatenated string.
Return Type
String
Parameters
Str1 [System.String] – First string
Str2 [System.String]
Example
In this example, we are passing the required parameters to the function transformation object using a Variables object.
Where,
Str1 = Hello
Str2 = World
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the a concatenated string using variables str1 and str2.
Name
Asc
Syntax
Asc (String str)
Purpose
To return the ASCII value of a specified character.
Description
Returns ASCII value of the specified character.
Return Type
Int32
Parameters
str [System.String] – Character for ASCII value
index [System.Int32] – Position of character to be converted within string
Example
In this example, we are passing the required parameter to the function transformation object using a Variables object.
Where,
str = ABC-123
index = 3
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned an integer ASCII value of the specified character in a string.
Name
Contains
Syntax
Contains (String lookFor, String lookIn)
Purpose
To determine whether lookFor string exists in lookIn string.
Description
Returns true if the lookFor string exists within the lookIn string. Otherwise returns false. Note: This function is case sensitive.
Return Type
Boolean
Parameters
lookFor [System.String] – String to search for
lookIn [System.String] – String to search in
Example
In this example, we are passing the required parameters to the function transformation object using a Variables object.
Where,
lookFor = GH
lookIn = ABCDEFGH
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned True, indicating that the the lookFor string is present within the lookIn string.
Name
Compact
Syntax
Compact (String str)
Purpose
To return the resulting string after removing all leading, trailing, and consecutive white space characters.
Description
Removes all leading and trailing white space characters from the string. Also removes any duplicate white space characters within the string. White space characters include space, tab, return, and linefeed characters.
Return Type
String
Parameters
Str [System.String] – String that will be compacted
Example
In this example, we are passing the required parameter to the function transformation object using a Variables object.
Where,
str = Hello World A B C
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the specified string after removing all white space characters.
Name
Find
Syntax
Find (String lookFor, String lookIn)
Purpose
Searches the string specified in lookFor in the lookIn string.
Description
Returns an integer representing the starting position of lookFor, in lookIn. If lookFor was not found in lookIn or either lookFor or lookIn is null, -1 Is returned. Note: Counting is started with the integer value, “0”
Return Type
Int64
Parameters
lookFor [System.String] – String to search for
lookIn [System.String] – String to search in
isCaseSensitive [System.Boolean] – Is Case Sensitive
Example
In this example, we are passing the required parameters to the function transformation object using a Variables object.
Where,
lookFor = e
lookIn = ABCDEFGH
isCaseSensitive = False
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the integer value “4”, indicating that the lookFor value’s positional integer value in the lookIn string is “4”.
Name
Extract
Syntax
Extract (String str, String start)
Purpose
To return string enveloped between specified start and end values within the str value.
Description
Returns a string enveloped between ‘start’ string and ‘end’ string. If ‘end’ is omitted, string starting after ‘start’ is returned. Case sensitivity can be specified by the user, using Boolean values, True or False.
Return Type
String
Parameters
str [System.String] – The string to search in
start [System.String] – The beginninh part of the string to search for
end [System.String] – The optional ending of the string to search for
isCaseSensitive [System.Boolean] – True to match
Example
In this example, we are passing the required parameters to the function transformation object using a Variables object.
Where,
str = helloABCworld
start = o
end = W
isCaseSensitive = False
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned ABC, the value enveloped between the start value “o” and NOT case sensitive end value, “W”.
Name
AddCDATAEnvelope
Syntax
AddCDATAEnvelope (String str)
Purpose
To return the given string surrounded by CDATA envelope.
Description
Surrounds the specified string with CDATA XML envelope. Use this function to surround a string when mapping as CDATA to XML destination.
Return Type
String
Parameters
Str [System.String] – String to surround with CDATA envelope
Example
In this example, we are passing the required parameter to the function transformation object using a Variables object.
Where,
str = Hello World
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the specified string surrounded by CDATA envelope.
Name
GetFindCount
Syntax
GetFindCount (String lookFor, String lookIn)
Purpose
To search and return an integer value indicating the number of occurrences of the specified lookFor string in the specified lookIn string.
Description
Returns an integer representing the number of occurrences of lookFor in lookIn
Return Type
Int64
Parameters
lookFor [System.String] – String to search for
lookIn [System.String] – String to search in
isCaseSensitive [System.Boolean]
Example
In this example, we are passing the required parameters to the function transformation object using a Variables object.
Where,
lookFor = a
lookIn = AbcdabABCabcdeA
isCaseSensitive = False
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the integer value “5”, indicating that the lookFor value, “a”, occurs 5 times within the lookIn value.
Name
GetDigits
Syntax
GetDigits (String str)
Purpose
To return a string containing all numeric characters in the specified str value.
Description
Removes all occurrences of non-numeric characters and returns all digits in str.
Return Type
String
Parameters
str [System.String] – String to remove non-numeric characters from
Example
In this example, we are passing the required parameters to the function transformation object using a Variables object.
Where,
str = A123Bc4de5678f9g10
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned a string containing only numeric values from the specified str value.
Name
ContainsAnyChar
Syntax
ContainsAnyChar (String charsTolookFor, String lookIn)
Purpose
To determine whether any character in charsTolookFor string exists in lookIn string.
Description
Returns true if any character in charsToLookFor string exists in the LookIn string. Otherwise returns false. Note: This function is NOT case sensitive.
Return Type
Boolean
Parameters
CharsTolookFor [System.String] – String to search for
lookIn [System.String] – String to search in
Example
In this example, we are passing the required parameters to the function transformation object using a Variables object.
Where,
CharsTolookFor = # @ab
lookIn = 1234 @# ABC
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned True, indicating that the the CharsTolookFor string is present within the lookIn string.
Name
IndexOf
Syntax
IndexOf (String lookIn, String lookFor)
Purpose
To return the index of a specified lookFor string after searching the lookIn string.
Description
Returns an integer representing the starting position of lookFor, in lookIn. If lookFor was not found in lookIn or either lookFor or lookIn is null, -1 is returned.
Return Type
Int64
Parameters
lookIn [System.String] – String to search in
lookFor [System.String] – String to search for
isCaseSensitive [System.Boolean] – Is Case Sensitive
Example
In this example, we are passing the required parameters to the function transformation object using a Variables object.
Where,
lookIn = ABCDEFG
lookFor = c
isCaseSensitive = False
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the integer value, “2”, indicating that the specified lookFor string is in the outputted index value position, “2”.
Name
Find
Syntax
Find (String lookFor, String lookIn, Integer startAt)
Purpose
Searches an integer representing the starting position of lookFor, in lookIn, starting at startAt. Note: This function is particularly useful when fields contain repeated values.
Description
Returns an integer representing the starting position of lookFor, in lookIn. If lookFor was not found in lookIn or either lookFor or lookIn is null, -1 Is returned. Note: Counting is started with the integer value, “0”
Return Type
Int32
Parameters
lookFor [System.String] – String to search for
lookIn [System.String] – String to search in
startAt [System.Int32] – Position to start searching at. Zero indicates the first position
isCaseSensitive [System.Boolean] – Is Case Sensitive
Example
In this example, we are passing the required parameters to the function transformation object using a Variables object.
Where,
lookFor = g
lookIn = ABCDEFGABCDEFG
startAt = 7
isCaseSensitive = False
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the integer value “13”, indicating that the lookFor value’s positional integer value in the lookIn string is “13”. Note that since the specified starting position is “7”, the intital lookFor value, “g”, in position “6”, has been ignored.
Below are preview windows with startAt values, “7” and “0”:
Name
Center
Syntax
Center (String str, Integer length)
Purpose
To return a string value centered in accordance with the provided integer length.
Description
Returns specified string centered according to the specified integer value. Returns zero if string is null.
Return Type
String
Parameters
Str [System.String] – String which will be centered
length [System.Int64] – Length of the output string
Example
In this example, we are passing the required parameters to the function transformation object using a Variables object.
Where,
str = ABC
length = 20
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the specified string centered in accordance with the provided length value.
Name
EndsWith
Syntax
EndsWith (String str, String value)
Purpose
To determine whether a string ends with a specified value.
Description
Returns true if str ends with specified value. Otherwise returns false. Note: This function is case sensitive.
Return Type
Boolean
Parameters
str [System.String] – String that will be searched
value [System.String] – Value that will be searched
Example
In this example, we are passing the required parameters to the function transformation object using a Variables object.
Where,
str = ABCDE
value = CDE
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned True, indicating that the the str string does end with the value string.
Name
FindLast
Syntax
FindLast (String lookFor, String lookIn)
Purpose
To search the lookIn string for the last occurrence of the string specified.
Description
Returns an integer representing the starting position of lookFor, in lookIn. If lookFor was not found in lookIn or either lookFor or lookIn is null, -1 Is returned.
Return Type
Int64
Parameters
lookFor [System.String] – String to search for
lookIn [System.String] – String to search in
isCaseSensitive [System.Boolean]
Example
In this example, we are passing the required parameters to the function transformation object using a Variables object.
Where,
lookFor = a
lookIn = ABCDEFGABCDEFG
isCaseSensitive = False
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the integer value “7”, indicating that last occurrence of the lookFor value was in the integer position, “7”.
Name
IsSubstringOf
Syntax
IsSubstringOf (String str1, String str2)
Purpose
To search specified string for another specified string value and return True if the latter is a substring of str2.
Description
Checks whether specified string is a substring of another string value. Note: Is case sensitive.
Return Type
Boolean
Parameters
str1 [System.String] – String to search for
str2 [System.String] – String to search in
Example
In this example, we are passing the required parameters to the function transformation object using a Variables object.
Where,
str1 = llo
str2 = Hello World
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned “True”, as the str1 value is a substring of the specified str2 value.
Name
IsLower
Syntax
IsLower (String str)
Purpose
To check whether the specified character within a string, in the specified index position, is lowercase alphabetic.
Description
Checks whether specified character is lowercase alphabetic.
Return Type
Boolean
Parameters
str [System.String] – String containing the character to test
index [System.Int32] – Numerical position of the character in the string to test. If not specified, index is presumed to be 0
Example
In this example, we are passing the required parameters to the function transformation object using a Variables object.
Where,
str = aAbBcC
index = 0
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned “True”, as the character in the specified numerical position is a lowercase alphabet.
Conversely, if we replace the index value with “1”, the output value will return the Boolean value, “False”, as shown below: