Split a single-line text into multiple lines using a specified delimiter.
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 “Split Single-line Text into Multiple Lines,” 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 Single Line Text Field, Delimiter, and Target Field (Optional).
Select the Text field. Only the Text field can be selected.
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.
*: If you set a Condition that only applies to some table rows (such as the Condition “When Fields Value Changed”), the Do will only process the rows affected by that Condition.
Enter the characters to be used as delimiters to separate the text. Multiple characters can be specified, not just one.
Use this parameter to set the results to another field. You can omit this parameter if you do not set the results directly in the field but use it in another action. Only the Text area field can be selected.
If the “Text area 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)":