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.

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.

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.

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.

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”.

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.

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.

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.

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”.

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”.

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.

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”:

Example

In this example, we will be manipulating an existing dataset by adding an empty column between fields, using the GetLineFeed Function Transformation object.

Our data is stored in a Fixed Length File Source object, and look like this:

Now, we will map source fields and the output value of the function transformation object to a Delimited File Destination.

Upon previewing the destination output, you can see that Astera Data Stack has added a new value column, thus a new empty string field for each record present, using the GetLineFeed function transformation object.

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.

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.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

str = 1a2 3c d

index = 3

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 white space.

Conversely, if we replace the index value with “2”, the output value will return the Boolean value, “False”, as shown below:

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.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

str = A-B-C-D-E

delimiter = -

tokenIndex = 2

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the string value, indicating the token in index position 2.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

insertInto = ABEF

insertString = CD

position = 2

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned a string value with the specified string inserted in the specified position.

Example

In this example, we are passing the required parameter to the function transformation object using a Variables object.

Where,

str = ABCDEFG

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the value, “7”, indicating that the specified string consists of seven characters.

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”.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

str = ABCDEFG

startAt = 3

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned a string beginning from the specified startAt position.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

str = 1a2b3c4d

index = 1

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 alphabetical.

Conversely, if we replace the index value with “0”, the output value will return the boolean value, “False”, as shown below:

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:

Example

In this example, we are passing the required parameter to the function transformation object using a Variables object.

Where,

name = ABCD_123

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned “True”, as the specified string is a valid object or element name.

Conversely, if we swap the input value with “ABC 123”, Astera Data Stack will return “False”, as the specified string value is not a valid object or element name.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

str = AbCdEfG

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 an uppercase alphabet.

Conversely, if we replace the index value with “1”, the output value will return the Boolean value, “False”, as shown below:

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

str = ABCDEFG

startAt = 3

noOfChars = 2

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned a string beginning from the specified startAt position, and of specified noOfChars length.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

str = AUSTRALIA

noOfChars = 3

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the first three characters of the specified string.

Example

We have a sample Customers_Marketing dataset with the field CompanyName. In this example, we want to return the first part of each record in the CompanyName field.

We will use the LSplit function and a Variables object to do this. We will map the CompanyName field from our source object to the str input node of the function transformation object. For the other required inputs of the function transformation object, we will use a Variables object.

Where,

maxTokens = 2

delimiter =

returnToken = 0

We will write the output to a Delimited Destination File object.

Now, to view the output, we will right-click on the destination object’s header and select Preview Output. You can see that Astera Data Stack has split the string values in the CompanyName field, and returned only the first part of the split string.

Similarly, if we change the returnToken value to “1”, the second chunk from the two will be returned, as shown below:

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

str = ABCDEFG

lookFor = e

isCaseSensitive = False

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned all the characters to the left of the specified string value.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

str = abcabcabcabc

charsToRemove = c

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned a string with all occurrences of the specified string removed.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

str = A@B!C$D*

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned a string, having replaced all special characters with a space.

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.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

str = ABC

padChar = -

length = 10

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the padded string of the specified length.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

str = ABC

padChar = .

length = 20

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the padded string of the specified length.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

str = ABCDEFGH

noOfChars = 3

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned a string of the specified noOfChars, from the right.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

str = ABCDEF

length = 25

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the specified string, aligned to the right, and of the specified length.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

str: A-B-C-D-E-F-G-H-I

maxTokens = 3

delimiter = - (Note: Since the string values in our case are separated using “-”, our delimiter value will also be “-”. This value can be replaced with other delimiters, depending on the data format)

returnToken = 2 (Note: We are using the value 2, as we want to return the third part of the split string, from the right)

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the third part of the split string, counting from the right.

Example

In this example, we are passing the required parameters 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 mirrored string in the output.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

str = ABABABA

lookFor = b

replaceWith ­= C

charsToRemove = False

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned a string, having replaced the last occurrence of a specified string with another provided string.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

str: A/B/C/D/E/F

separator = /

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the different parts of the split string as separate records, on the basis of the specified delimiter (separator) value.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

str: ABCDEFGHI

startAt = 2

noOfChars = 4

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned a part of the string, starting at position startAt, and of length, noOfChars.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

Str: ABC

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned a string value, with trimmed leading and trailing whitespace characters.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

str = A,B,C,D,E,F,G,H,I,J

separator = ,

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the split string.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

str: ABC-DEF/GHI.JKL

separator1 = -

separator2 = /

separator3 = .

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the different parts of the split string, on the basis of the specified delimiter (separator) values.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

str: A?B/C-D?E/F

separator1 = ?

separator2 = /

separator3 = -

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the different parts of the split string as separate records, on the basis of the specified delimiter (separator) values.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

htmlText: <p>Hello World.</p> <p>This is a test.</p>

decode = True

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned a string values, stripped of HTML tags.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

str: A?B?C/D/E/F

separator1 = ?

separator2 = /

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the different parts of the split string as separate records, on the basis of the specified delimiter (separator) values.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

str: A B C

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned a string value, with any extra spaces removed.

Example

We have a customers' dataset in which the ContactTitle field is in pascal case. Our goal is to add spaces between the characters in this field.

We will map the ContactTitle data field to the str under the Input node inside the Function transformation object.

In the output, you can see that the data inside the ContactTitle field has been converted to proper case.

Example

In this example, we have order details of customers residing in an Excel file. We want all the columns to be free of white spaces so that the data is more cleansed, presentable, and ready for further processing.

Map the CompanyName to the str data field under the Input node inside the function transformation object.

You can see that all the leading and trailing spaces have been removed from the data field.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

str: ABC

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned a string value, with trimmed leading whitespace characters.

Example

In this example, we have a customer’s data in which we want to convert the CustomerID information into lower case. Map the CustomerID to the str data field under the Input node inside the function transformation object.

Right-click on the header of function transformation object and select Preview Output. You can see that all the CustomerIDs have been converted into lower case.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

str: ABC

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned a string value, with trimmed trailing whitespace characters.

Example

In this example, we are passing the required parameters to the function transformation through a Variables object.

Where,

str = ABCDEF

startAt = 2

Right-click on the function transformation object and select Preview Output. You can see that it has returned the string value after second position.

Example:

In this example, we are passing the required parameters by the function transformation from a Variables object.

Where,

str = AB CD

count = 2

delimiter = ,

Right-click on the function transformation object and select Preview Output. You can see that the characters specified in the str data field are repeating two times, separated by the given delimiter.

Example

In this example, we are passing the required parameters to the function transformation object using a Variables object.

Where,

str = ABCDEF

startsWith = B

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned the Boolean value, False, which means the original string does not start with the given value.

Example:

In this example, we are passing the required parameters from the Variables object to the function transformation object.

Where,

str = ABCDE

lookFor = DE

replaceWith = GH

Right-click on the function transformation object and select Preview Output. You can see that characters 'DE' have been replaced by 'GH'.

Example

In this example, we are passing the required parameters to the data fields under the Input node inside the function transformation object.

Where,

str = April Danes

lookFor = Danes

replaceWith = Luke

isCaseSensitive = False

Right-click on the function transformation object and select Preview Output. You can see that the “Danes” has been replaced by “Luke” successfully.

Example

We have a customers' dataset in which we want to convert the ContactTitle field into proper case.

We will map the ContactTitle data field to the str under the Input node inside the function transformation object.

You can see that the data inside the ContactTitle data field has been converted to proper case.

Example

We have 3 parameters, str, startAt and noOfChars, in a Variables object in which we have specified the default values as:

str = Charles Dickens

startAt = 8

noOfChars = 7

Map the data fields from the Variables object to the respective data fields under the Input node inside the function object.

Now, right-click on the RemoveAt function transformation object and select Preview Output. You can see that starting from position 8, 7 characters have been removed from the string.

Example

We have a customers data in which we want to convert the Address information into proper case.

We will map the Address data field to the str under the Input node inside the function transformation object.

You can see that the data inside the Address field has been converted to proper case.

Example

In this example, we have customers data stored in an Excel sheet. We want to convert CustomerContactName into uppercase. So, we will map the CustomerContactName data field to str data field under the Input node inside the function transformation object.

Right-click on the function transformation object and select Preview Output. You can see that the value inside the data field has been converted into uppercase.

Example

In this example, we have are passing the required parameters using a Variables object where:

str = ABCDEFGH

charsToRemove = ABC

Right-click on the function transformation object and select Preview Output. You can see that the specified characters in charsToRemove have been removed.

Example

In this example, we are passing the required parameters by the function transformation through a Variables object.

Where,

str = flourine-chlorine-bromine-iodine-astatine-helium-neon-argon,krypton,xenon

separator1 = -

separator2 = ,

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has split the string into 10 parts based on the given separators.

Example

In this example, we are passing the required parameters by the function transformation through a Variables object.

Where,

str = Max Medina

lookFor = Max

isCaseSensitive = False

Right-click on the header of function transformation object and select Preview Output. You can see that Astera Data Stack has returned the value on the right of the string given in lookFor.