Convert a multi-line string into a single-line string by removing line breaks and 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 “Convert Multi-line Text to Single 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 Text Area Field, Delimiter, and Target Field (Optional).
Select the source Text area field for conversion. Only the Text area field can be selected.
If you select a field inside a table, all rows of that table will be processed. For exceptions: See (*1)
(*1) If you set a Condition that only applies to some table rows (such as the Condition “If Field Value is a Specific Value”), the Do will only process the rows affected by that Condition.
When single-lined, it is separated by the character specified here. 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 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)":