Extract the specified number of characters from the end of the specified field.
In many types of conversions, such as “Convert Half-width to Full-width,” the source field and the destination field are the same, but the value of the source field is altered. In contrast, for the operation “Extract Character from the Right of the Field Value,” the value of the source field remains unchanged, and a separate field must be prepared to hold the conversion result. Alternatively, it is also possible to obtain the conversion result using an expression like “= $1” besides setting it in a different field.
Set Field, Character Count, and Target Field (Optional).
Specify the field that contains the original value to be extracted.
Executing “Extract Character from the Right of the Field Value” does not change the original field value.
This parameter accepts the following field types:
For Number fields, the original value is used as a string of a raw number, which does not include digit separators or unit symbols.
If you select a field inside a table, all rows of that table will be processed. For exceptions: See (*1)
*1: If you set a Condition that only applies to some table rows (such as the Condition “When Fields Value Changed”), the value will be set only for those affected by that Condition.
Specify the number of characters to extract.
Values less than or equal to zero cannot be specified. If the specified expression results in a value less than or equal to zero at runtime, it will not result in an error, but the execution result will be an empty string.
If the specified number of characters exceeds the target’s length, the entire string will be returned as the result.
Specify the field where the result value of “Extract Character from the Right of the Field Value” will be set.
Executing “Extract Character from the Right of the Field Value” will overwrite the value of this field.
This parameter accepts the following field types:
If the “Field” parameter is a field in the table, the “Target Field (Optional)” must also be selected from the same table.
This action is designed to work seamlessly with krewSheet.
However, the following restrictions apply to the parameter “Target Field (Optional)":
In JavaScript, a single character may be represented by two codes. For example, it applies to characters like “𠮷” and emojis. In Extract Characters From the End of the Field”, these characters are treated as “one character”.