Skip to main content

Right

Return characters from the right of text. Strings shorter than the length defined will be unaffected.

Select characters from the right of the input. Using a negative length reverses the side of selection, selecting from the left.

Parameters​

NameDescriptionAccepted ValuesDefaultRequired
I/O
inputName of the column(s) to edit.string, integer, array—Yes
outputName of the output column(s).string, array, nullnullNo
Options
lengthNumber of characters to include from the right. If negative, this will remove the specified number of characters from the right. May not equal 0.integer—Yes
Conditions
ifCondition that determines whether the wrangle runs as a whole. Recipe variables may be referenced with ${variable}.string—No
whereFilter rows before applying the wrangle using SQL-like criteria, such as column1 = 123 OR column2 = 'abc'.string—No
where_paramsValues used with where for parameterized criteria. Uses SQLite placeholder syntax such as ? or :name.array, object—No

Examples​

wrangles:
- select.right:
input: Column
output: Result
length: 3
Column
pudding
Result
ing
Access
RequirementValue
AI-poweredNo
Requires WrangleWorks accountNo
Requires subscriptionNo
Requires external API keyNo
Technical details
FieldValue
Catalog ID58
Catalog keyselect.right
Recipe keyselect.right
Catalog statusactive
Lifecycle statusactive
Recipe Writer eligibleYes
Namespaceselect
Documentation groupselect
AliasesNone
Runtime symbolwrangles.recipe_wrangles.select.right
Legacy UUID89ee82ec-3bc5-4bfa-899b-7a1260ef9bdb

Sources