Job Runner

Remove Blank Spaces

Overview

Remove blank spaces, tab characters, and line feed characters in the specified fields.

Usage

Depending on the type of field you select, you may or may not want to strip line breaks. In the String (multi-line) and Rich Editor, the original line breaks are preserved, stripping only whitespace and Tab characters. For other types, it also removes line breaks.

Source Records saved under normal screen Operation do not contain line breaks in the String (one line). However, in the case of data created by customization, it may include line breaks. “Remove Whitespaces” can remove line breaks caused by such customization.

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 and Field.

Record

Select the Action you used to import the target records.

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

Field

Select the field you want to strip whitespace from. You can select multiple fields. When multiple fields are selected. the Action will simultaneously replace the target string in all fields.

This parameter accepts the following field types:

  • Text
  • Text area
  • Rich text

You cannot include fields that are within a table.