Activities

• Between String
• Compare
• Create Random String
• CSV Parser
• CSV Search
• Decrypt String
• Encrypt String
• EndsWith
• Extract String
• Generate Password
• Generate Password V2
• Filter Regex
• Insert
• IsNormalized
• Length
• Modifier
• Regex
• Remove
• Replace
• Search
• StartsWith
• Substring

Between String

This activity extracts a string between given inputs.

Activity Parameters

The Between String activity parameters can be provided by manual inserted values or via IN arguments or variables:

Parameters:

• After string (text box editor type) (type: string): enter the after string of extraction.
• Before string (text box editor type) (type: string): enter the before string of extraction.
• InputString (text box editor type) (type: string): enter the input string.

The Read Only Output variable are the possible output values that the activity will provide:

• Result (type: string): outputs the extracted string.

Compare

This activity compares String1 with String2 and returns 0 if they are the same, a negative value if String1 is lower than String2 and a positive value otherwise.

Activity Parameters

The Compare activity parameters can be provided by manual inserted values or via IN arguments or variables:

Parameters:

• String1 (text box editor type) (type: string): enter the first String.
• String2 (text box editor type) (type: string): enter the second String.
  
  

The Read Only Output variable are the possible output values that the activity will provide:

• Result (type: string): outputs the result of the comparison.

Create Random String

This activity creates a random string with various levels of complexity.

Activity Parameters

The Create Random String activity parameters can be provided by manual inserted values or via IN arguments or variables:

 
 
 Parameters:

• Complexity (combo-box control type): select the complexity level of the returned string.
• Length (text box editor type) (type: string): enter the length of the returned string.
  
  

The Read Only Output variable are the possible output values that the activity will provide:

• Random string (type: string): outputs a random generated string.

CSV Parser

This activity parses the content of a CSV file and outputs the result in a Datatable variable.

Activity Parameters

The CSV Parser activity parameters can be provided by manual inserted values or via IN arguments or variables:

 
 
 Parameters:

• Delimiter (text box editor type) (type: string): the delimiter that will be used for parsing.
• Path (text box editor type) (type: string): the path to the CSV file (full path).
• Qualifier (text box editor type) (type: string): the text qualifier is used to differentiate your field data from your delimiter. If the data also contains quotes, it must be chosen to either not use a text qualifier or to select a text qualifier that does not appear within the data.
  
  

The Read Only Output variable are the possible output values that the activity will provide:

• Result (type: DataTable): outputs the CSV content into a Datatable.

CSV Search

This activity searches in a CSV file by column and unique row value.

Activity Parameters

The CSV Search activity parameters can be provided by manual inserted values or via IN arguments or variables:

 
 
 Parameters:

• Column (text box editor type) (type: string): the name of the CSV column which will be searched for values.
• Delimiter (text box editor type) (type: string): the delimiter that will be used for parsing.
• Path (text box editor type) (type: string): the path to the CSV file (full path).
• Qualifier (text box editor type) (type: string): the text qualifier is used to differentiate your field data from your delimiter. If the data also contains quotes, it must be chosen to either not use a text qualifier or to select a text qualifier that does not appear within the data.
• Unique Value (combobox control type) (type: string): specify if the row value is unique or not.
• Value (text box editor type) (type: string): the value after the row content will be searched for.
  
  

The Read Only Output variable are the possible output values that the activity will provide:

• Result (type: DataTable): outputs the CSV search result into a Datatable.

Decrypt String

Decrypt a String which were encrypted by the Encrypt String activity and output the decrypted string.

Activity Parameters

The Decrypt String activity parameters can be provided by manual inserted values or via IN arguments or variables:

Parameters:

• Password (password editor type) (type: string): the password which were used to encrypt the String.
• Password Binding (text box editor type) (type: string): bind to a variable containing the encrypted password for the connection. (This parameter is used only when the user wants to send an encripted password from outside the workflow, for example Flowster Portal).

• String to decrypt (text box editor type) (type: string): enter the encrypted string, which were encrypted by the Encyrot String activity.
  
  

The Read Only Output variable are the possible output values that the activity will provide:

• Decrypted String (type: string): outputs the decrypted string.

Encrypt String

Encrypt a String with AES256 with a password and outputs the encrypted string.

Activity Parameters

The Encrypt String activity parameters can be provided by manual inserted values or via IN arguments or variables:

Parameters:

• Password (password editor type) (type: string): the password to encrypt the String.
• Password Binding (text box editor type) (type: string): bind to a variable containing the encrypted password for the connection. (This parameter is used only when the user wants to send an encripted password from outside the workflow, for example Flowster Portal).
• String to encrypt (text box editor type) (type: string): enter the cleartext string, which should be encrypted.
  
  

The Read Only Output variable are the possible output values that the activity will provide:

• Encrypted String (type: string): outputs the encrypted string.

EndsWith

This activity returns a boolean value showing whether a string ends with a given string.

Activity Parameters

The EndsWith activity parameters can be provided by manual inserted values or via IN arguments or variables:

 
 
 Parameters:

• EndString (text box editor type) (type: string): enter the ending string.
• InputString (text box editor type) (type: string): enter the input string.
  
  

The Read Only Output variable are the possible output values that the activity will provide:

• Result (type: string): outputs a boolean value representing whether the InputString ends with EndString.

Extract String

This activity extracts a string before or after the given sign. Example: Import value "c:\windows", Select text "After", Sign character: "\", creates output: "windows".

Activity Parameters

The Extract String activity parameters can be provided by manual inserted values or via IN arguments or variables:

 
 
 Parameters:

• InputString (text box editor type) (type: string): enter the input string.
• Select text (combo-box control type): choose to extract Before or After the Sign character parameter.
• Sign character (text box editor type) (type: string): enter the separator string.
  
  

The Read Only Output variable are the possible output values that the activity will provide:

• Result (type: string): Outputs the extracted string from the InputString.

Filter Regex

This activity takes a string as an input and checks if its value matches a regex pattern, returning the result(s) in a collection/item.

Activity Parameters

The Filter Regex activity parameters can be provided by manual inserted values or via IN arguments or variables:

 
 
 Parameters:

• Input String (text box editor type) (type: string): enter the input string for which the regex pattern will be applied.
• Pattern (text box editor type) (type: string): the regex pattern. E.g. "([0-9].[0-2])" pattern will search for 2 digits separated by a dot.

The Read Only Output variable are the possible output values that the activity will provide:

• Matches (type: collection<string>): Outputs a collection of all matches.
  
• Result (type: string): Outputs the resulting string after the regex pattern was applied.

Generate Password

This activity generates a random password by selected criteria.

Activity Parameters

The Generate Password activity parameters can be provided by manual inserted values or via IN arguments or variables:

 
 
 Parameters:

• Brackets (combo box control) (type: string): select 'True' if the password will contain brackets. E.g. {}[]()<>
• Digits (combo box control) (type: string): select 'True' if the password will contain digits. E.g. 0123456789
• High ANSI Characters (combo box control) (type: string): select 'True' if the password will contain high ANSI characters
• Lower Case (combo box control) (type: string): select 'True' if the password will contain lower case letters. E.g. abcdef
• Minus (combo box control) (type: string): select 'True' if the password will contain minus character.
• Password Length (text box editor type) (type: Int32): enter the length of the password. 
• Space (combo box control) (type: string): select 'True' if the password will contain spaces.
• Special (combo box control) (type: string): select 'True' if the password will contain special characters. E.g. $%^&*
• Underline (combo box control) (type: string): select 'True' if the password will contain underline character. 
• Upper Case (combo box control) (type: string): select 'True' if the password will contain upper case letters. E.g. ABCDEF 
  
  

The Read Only Output variable are the possible output values that the activity will provide:

• Result (type: string): outputs the generated password in plain text.

Generate Password V2

This activity generates a random password by selected criteria.

Activity Parameters

The Generate Password V2 activity parameters can be provided by manual inserted values or via IN arguments or variables:

 
 
 Parameters:

• Digits (combo box control) (type: string): select 'True' if the password will contain digits. E.g. 0123456789
• Lower Case (combo box control) (type: string): select 'True' if the password will contain lower case letters. E.g. abcdef
• Password Length (text box editor type) (type: Int32): enter the length of the password. 
• Special (combo box control) (type: string): select 'True' if the password will contain special characters. which are set under Special chars
  
• Special chars (combo box control) (type: string): Eenter the desired special characters e.g. *$-+?_&=!%{}/
• Upper Case (combo box control) (type: string): select 'True' if the password will contain upper case letters. E.g. ABCDEF 
  
  

The Read Only Output variable are the possible output values that the activity will provide:

• Encrypted Password (type: string) outputs the generated password as encrypted string. This string can be used in the Password Binding Parameters of connect activities.
• Result (type: string): outputs the generated password in plain text.

Insert

This activity inserts a string into another string at the specified position.

Activity Parameters

The Insert activity parameters can be provided by manual inserted values or via IN arguments or variables:

 
 
 Parameters:

• InputString (text box editor type) (type: string): enter the input string.
• InsertString (text box editor type) (type: string): enter the string to insert.
• Start Position (text box editor type) (type: string): enter the position on which InsertString should be placed.
  
  

The Read Only Output variable are the possible output values that the activity will provide:

• Result (type: string): Outputs the final string.

Is Normalized

This activity checks if a given string is normalized..

Activity Parameters

The Is Normalized activity parameters can be provided by manual inserted values or via IN arguments or variables:

 
 
 Parameters:

• InputString (text box editor type) (type: string): enter the input string to check if it is normalized.
  
  

The Read Only Output variable are the possible output values that the activity will provide:

• Result (type: boolean): Outputs a boolean value representing whether the String is normalized.

Length

This activity returns the length of the InputString parameter.

Activity Parameters

The Length activity parameters can be provided by manual inserted values or via IN arguments or variables:

 
 
 Parameters:

• InputString (text box editor type) (type: string): enter the input string.
  
  

The Read Only Output variable are the possible output values that the activity will provide:

• Result (type: integer): Outputs the length of the InputString parameter.

Modifier

This activity performs a chosen operation on the InputString parameter.

Activity Parameters

The Modifier activity parameters can be provided by manual inserted values or via IN arguments or variables:

 
 
 Parameters:

• InputString (text box editor type) (type: string): enter the input string.
• Operation (combo-box control type): choose one of the operations available to be applied on the InputString parameter.Choose from the drop down list the desired operation.
  
  

The Read Only Output variable are the possible output values that the activity will provide:

• Result (type: string): Outputs the resulting string after the chosen operation.

Regex

This activity takes a string as an input and checks if its value matches a regex pattern, returning the result.

Activity Parameters

The Regex activity parameters can be provided by manual inserted values or via IN arguments or variables:

 
 
 Parameters:

• Input String (text box editor type) (type: string): enter the input string for which the regex pattern will be applied.
• Pattern (text box editor type) (type: string): the regex pattern. E.g. "([0-9].[0-2])" pattern will search for 2 digits separated by a dot, and the second digit must be in the {0,1,2} set.

The Read Only Output variable are the possible output values that the activity will provide:

• Result (type: string): Outputs the resulting string after the regex pattern was applied.

Remove

This activity removes a set amount of characters from an input string starting with a specified start position.

Activity Parameters

The Remove activity parameters can be provided by manual inserted values or via IN arguments or variables:

 
 
 Parameters:

• InputString (text box editor type) (type: string): enter the number of characters to remove. If no value is entered or the value is invalid, the remaining characters after StartPosition will be removed.
• Count (text box editor type) (type: integer): enter the input string.
• StartPosition (text box editor type) (type: integer): enter the starting position where the characheters will be removed.
  
  
  

The Read Only Output variable are the possible output values that the activity will provide:

• Result (type: string): Outputs the final string with the characters removed from the specified position.

Replace

This activity replaces all occurences of OldText parameter in InputString parameter with NewText value.

Activity Parameters

The Replace activity parameters can be provided by manual inserted values or via IN arguments or variables:

 
 
 Parameters:

• InputString (text box editor type) (type: string): enter the input string.
• NewText (text box editor type) (type: string): enter the text value that will replace OldText.
• OldText (text box editor type) (type: string): enter the text value to be replaced.
  
  
  

The Read Only Output variable are the possible output values that the activity will provide:

• Result (type: string): Outputs the final string with the OldText value replaced with NewText value.

Search

This activity searches if a String occurs in another String and returns the position on which it is first encountered. If it is not found, the output will be -1.

Activity Parameters

The Search activity parameters can be provided by manual inserted values or via IN arguments or variables:

 
 
 Parameters:

• InputString (text box editor type) (type: string): enter the input string.
• StringToFind (text box editor type) (type: string): enter the text(String) you want to be searched in InputString parameter.
  
  
  

The Read Only Output variable are the possible output values that the activity will provide:

• Result (type: integer): Outputs the position in the InputString parameter where the StringToFind text was first encountered. If the value is -1, the StringToFind value was not found.

StartsWith

This activity returns a boolean value showing whether a string starts with a given string value.

Activity Parameters

The StartsWith activity parameters can be provided by manual inserted values or via IN arguments or variables:

 
 
 Parameters:

• InputString (text box editor type) (type: string): enter the input string.
• StartString (text box editor type) (type: string): enter the starting string.
  
  
  

The Read Only Output variable are the possible output values that the activity will provide:

• Result (type: boolean): Outputs a boolean value representing whether the InputString starts with StartString.

Substring

This activity takes the value of an input string and returns a substring from the given position. Example: InputString "c:\windows", Length "3", Starting Position "3", creates Result: "win".

Activity Parameters

The Substring activity parameters can be provided by manual inserted values or via IN arguments or variables:

 
 
 Parameters:

• InputString (text box editor type) (type: string): enter the input string.
• Length (text box editor type) (type: string): enter the length of substring.
• Starting Position (text box editor type) (type: string): enter the starting position from where to extract substring (the first letter is at position 0).
  
  
  

The Read Only Output variable are the possible output values that the activity will provide:

• Result (type: string): Outputs the extracted substring.