Convert letters to numbers by removing commas and converting double-byte characters to single-byte characters in the specified fields.
If there are characters that cannot be converted to a number, they will be converted to a blank.
Example:
| Before conversion | After conversion |
|---|---|
| 12,000 | 12000 |
| １５００ | 1500 |
| 2,800 | 2800 |
| ABC | (blank) |
| ¥12,000 | (blank) |
Set Field.
Select the fields to convert. You can select multiple fields. When multiple fields are selected, the Action will simultaneously convert the target string in all fields.
This parameter accepts the following field types:
If you select a field that is inside a table, the Do will process all rows of that table. See *1 for exceptions to this behavior.
*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.
This action is designed to work seamlessly with krewSheet.
Fields retrieved through a Lookup are not supported.
The following field types can be supported only at the timing of record saving (e.g. “Before Record Saved Excluding Deleted”): If you want to gain more technical knowledge, refer to the krewSheet documentation .