Differences

This shows you the differences between two versions of the page.

--- transformations:subfield [2021/04/20 13:43] – craigt
+++ transformations:subfield [2021/04/21 15:35] – [Remarks] craigt
@@ Line 5: / Line 5: @@
 \\
 =====Description=====
-This action splits column values delimited with a separator (e.g. comma) into multiple rows -- one row per value. Values in other columns are duplicated in the new rows.\\
+This action splits column values delimited with a separator (e.g. comma) into multiple rows -- one row per value.
+Values in other columns are duplicated in the new rows.\\
 \\
@@ Line 21: / Line 23: @@
 =====Remarks=====
 Unlike the [[transformations:splitdelimitedtext|Split delimited text into columns]] action, in which you have to define the new columns to receive the split values, this action will create as many new rows as necessary to output all split values in the selected column.
+Leading and trailing whitespace are automatically removed from values when the new columns are created.\\
 \\