RIGHT
Given a number of characters, takes the rightmost number of characters in the strings from the source column or custom strings, and returns the specified number of rightmost characters in a new column.
Parameters
-
sourceColumn– The name of an existing column. -
value– A character string to evaluate. -
position– The character position to begin with, from the right side of the string. -
targetColumn– The name of the new column to be created.
Note
You can specify either sourceColumn or value, but not
both.
Examples
{
"RecipeAction": {
"Operation": "RIGHT",
"Parameters": {
"sourceColumn": "nationality",
"position": "3",
"targetColumn": "nationality_right"
}
}
}{
"RecipeAction": {
"Operation": "RIGHT",
"Parameters": {
"value": "United States of America",
"position": "7",
"targetColumn": "usa_right"
}
}
}