Replace part of a string in a field with different string.
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.
Set Record, Field, String before Substitution, String after Substitution, and How Handle Multiple Hits.
As an example, assume the target field contains the string “3.5 grams.” If you input “grams” in the parameter String before Substitution and input “g” in the parameter String after Substitution, the Action will replace “3.5 grams” with “3.5 g.”
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.
Select the fields that hold the string value you want to replace. 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:
This parameter does not accept fields that are inside tables.
Input the string you want to remove and replace.
Input the string you want the Action to insert instead of the removed string.
If you leave this parameter empty, the Action will simply remove the string specified in String before Substitution.
Choose what to do if the target field contains multiple instances of the string specified in “String before Substitution”. You can select between “Replace All” and “Replace Only First One”.
Select Replace All if you want to replace all instances of the string specified in String before Substitution.
Select Replace Only First One if you only want to replace the first instance of the string (the string closest to the beginning of the field value).