Job Runner

Extract Characters From the End of the field

Overview

Extract the specified number of characters from the end of the specified field.

Usage

If you perform this Do, the field value is changed from its original value, and records are reserved for saving. Updated records are not saved immediately but automatically after all actions in the job are finished. Use Save Modified Record to save the updated records at a different time.

You will need an API Token with the edit record permission for the app when autosaving. Make sure to Set Kintone API Token in another action and set the API Token for the Kintone app, if you want to save the Modified Source Record at a different time.

Parameters

Set Record, Field, Number of Characters, and Target Field (Optional).

Record

Select the Action you used to retrieve the target records.

If multiple records are included, it is processed for each record. If there are no records, nothing is done.

Field

Specify the field containing the original value to be retrieved.

Extracting the character from the right of the field value does not change the value of the source field.

This parameter accepts the following field types:

  • Text
  • Number
  • Text area
  • Link

Number fields are based on a string of numbers without thousands of separators or unit symbols.

This parameter does not accept fields that are inside tables.

Number of Characters

Specify the number of characters to extract.

You cannot directly specify a value less than or equal to zero. If you specify an expression and the value drops below zero at runtime, the result is an empty string, although no error occurs.

If the number of characters specified is greater than the length of the string, the entire string is the result.

Target Field (Optional)

Specify the field to which extract chevalier from the right of the field value should be set.

Extracting the character from the left of the field value will overwrite the value in this field.

This parameter accepts the following field types:

  • Text
  • Number
  • Text area
  • Link

This parameter does not accept fields that are inside tables.

Advanced Information

A JavaScript string may have one character represented by two codes, such as an emoji. The extracted character from the left of the field value also treats these characters as a single character.