TextSplitting

This activity helps the user to split and extract the characters from the provided input string.

Technical Reference

 

 

 

 

 

 

 

INPUT

InputString: This parameter indicates to provide the “Input” data that needs to be split and extracted.

 

You can either hardcode the values in “String” format or provide the values in “String” datatype.

 

This parameter accepts values in “String” datatype.

SplitType: Indicates to choose the split type option from the drop-down,

LTRIM: Trims characters from the left side

RTRIM: Trims characters from the right side

MIDTRIM: Trims characters from the middle

StringLength: Indicates to specify the “Length” of the input string characters that the bot must trim and display.

 

You can either hardcode the values in “Integer” format or provide the values in “Integer” datatype.

 

This parameter accepts values in “Integer” datatype.

 

 

 

 

 

 

 

MISC

DisplayName: Displays the name of the activity. The activity name can be customized, which aids in troubleshooting.

SkipOnError: Specify the "Boolean" value as "True" or "False."

 

True: Continue executing the workflow regardless of any errors thrown.

False: Halt the workflow if it encounters any errors.

None: If the option is left blank, the activity will, by default, behave as if "False" were chosen.

Version: It indicates the version of the feature being used.

 

 

 

 

 

OUTPUT

Result: It provides the ability to view the execution status of the activity. It returns values in "Boolean."

 

True: Indicates that the activity has been executed successfully without any errors.

False: Indicates that the activity has been unsuccessful due to an unexpected error being thrown.​​

Text: It returns the output of the activity as the text extracted from the specified text file. It returns the output in “String” datatype.

Represents mandatory fields to execute the workflow

 Here’s an example of how the activity works –

In the following example, I am going to use the “TextSplitting” activity to split and
extract the value form the provided input string. Here I am continuing from the
“ReadText” activity example.

Steps to execute the bot:

1.       Create a solution named “TextAutomation” or open an existing solution.

2.       Drag and drop the "TextSplitting" activity onto the designer pane and place
it below the read text activity.

3.       Double click on the activity.

a.       Here I am providing the input string as the text extracted from the “ReadText”
activity variable.

b.       Choosing the split type option as “LTRIM”.

c.       Providing the string length as “14” in the box to extract only 14 characters
from the left side of the text in the variable.

4.       Navigating to the “Text” in the output properties of the activity to declare a
variable to view the output.

a.       There are two methods to store the spied value in the variable.

b.       Method 1: Double-click on the variable parameter in the “Text” section and
enter a name that helps you easily identify it in the flow. Here, I'm using the
name "Trimmed" and using the shortcut key "Ctrl+Q" to create the variable.

c.       Method 2: Click on the variable pane, enter your preferred name (here, I'm using
"Trimmed"), and choose the data type as "String" since the output value accepts
the string data type.

5.       Now, placing the “Writelog” activity to write the output in the output window.

a.       Provide all the required inputs.

6.       Execute the workflow.

The bot executes the activity, trims the first 14 characters of the given input
string from the left side and gives the output as “The Dictionary”