Data Cleaning
Drop All Events to Start With
Description:
Dropping all events operation is used to drop all the events that starts with the user defined value.
Number of Parameters : 1
Parameter : Drop All Event To Start With
Drop All Event To Start With helps in giving the value from which the user needs to start dropping the value.
Below is an example here we want to start dropping the values from https .
"https"
Drop all Event for Value
Description:
Dropping all events operation is used to drop all the values for a given event specify by the user.
Number of Parameters : 1
Parameter : Drop All Event For Value
It is used to drop all the values from a specific event.
Below is an example where we want to drop all the value Michael.
"Michael"
Eliminate
Description:
Eliminate operation is used for eliminating any key name from the data set.
Number of Parameters : 1
Parameter : Eliminate
The users need to pass the key name which they want to eliminate.
Below is an example where we are eliminating the keys Organization and Item.
"Organization","Item"
Substitute
Description:
Substitute operation is used to substitute or replace a value or a word or a character to a new value, specify by the user.
Number of Parameters : 1
Parameter : Substitute
This is used to modify, replace any key's value with the user defined value.
Below is an example where we want to substitute the existing value of email-id which is .in to .com.
Example: ["key_name","to be replaced","replaced by"]
"email-id",".in",".com"
Rename
Description:
Rename operation is used to rename any key name to a new key name specified by the user.
Number of Parameters : 1
Parameter : Rename
Rename gives a comma-separated key-value pair where key is the existing column name and value is the new column name.
Below is an example where we want to rename email to email-id.
"email":"email-id"
Strip
Description:
Stripping operation helps to strip a value or a word or character from left, right or both.
Number of Parameters : 1
Parameter : Strip
Strip can be used in values, words or characters form left to right or from both the ends.
Below is an example where we want to strip tabledata from right and remove the extra \n from the data
"TableData","right","\n"
Substring
Description:
Substringing is used to crop the extract portion of a string or object that matches a certain requirement of the user.
Number of Parameters : 1
Example 1 : Get the first 5 characters of a string
string = "freeCodeCamp"
eZintegrations Operations :
"string":"[0:5]"
Response : freeC
Example 2 : Get a substring 4 characters long, starting from the 3rd character of the string
string = "freeCodeCamp"
eZintegrations Operations :
"string":"[2:6]"
Response : eeCo
Example 3: Get the last character of the string
string = "freeCodeCamp"
eZintegrations Operations :
"string":"[-1]"
Response : p
Example 4 : Get the last 5 characters of a string
string = "freeCodeCamp"
eZintegrations Operations :
"string":"[-5:]"
Response : eCamp
Example 5 : Get a substring which contains all characters except the last 4 characters and the 1st character
string = "freeCodeCamp"
eZintegrations Operations :
"string":"[1:-4]"
Response : reeCode
Example 6 : Get every other character from a string
string = "freeCodeCamp"
eZintegrations Operations :
"string":"[::2]"
Response : feCdCm
Example 7 : Extract number like a regular expression from string. "_"
string = "freeCodeCamp_123"
eZintegrations Operations :
"string":"[bizdata_substring.index("_") + 1:]"
Response : 123