transformations:subfield
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
transformations:subfield [2021/04/21 15:24] – [Description] craigt | transformations:subfield [2023/10/11 20:54] (current) – [Remarks] craigt | ||
---|---|---|---|
Line 23: | Line 23: | ||
=====Remarks===== | =====Remarks===== | ||
Unlike the [[transformations: | Unlike the [[transformations: | ||
+ | |||
+ | Leading and trailing whitespace are automatically removed from values when the new columns are created.\\ | ||
+ | |||
+ | **Import 2 to 3 times faster (experimental feature).** | ||
\\ | \\ | ||
Line 37: | Line 41: | ||
> Delimiter: Semicolon | > Delimiter: Semicolon | ||
\\ | \\ | ||
- | **Result:** | + | **Result |
^ Row no ^ Numbers ^ | ^ Row no ^ Numbers ^ | ||
| 1|one | | | 1|one | | ||
Line 43: | Line 47: | ||
| 1|three | | | 1|three | | ||
- | \\ | + | \\ \\ |
**Example 2:** A column with multi-line text values.\\ | **Example 2:** A column with multi-line text values.\\ | ||
Line 55: | Line 59: | ||
> Delimiter: Line break | > Delimiter: Line break | ||
\\ | \\ | ||
- | **Result:** | + | **Result |
^ Location No ^ Location ^ | ^ Location No ^ Location ^ | ||
| 1| Mississauga | | 1| Mississauga | ||
Line 79: | Line 83: | ||
> Separator: Comma | > Separator: Comma | ||
\\ | \\ | ||
- | **Result:** | + | **Result |
^Customer ID^Order IDs^ | ^Customer ID^Order IDs^ | ||
|CUST001 | |CUST001 | ||
Line 91: | Line 95: | ||
|CUST003 | |CUST003 | ||
|CUST003 | |CUST003 | ||
+ | |||
+ | \\ | ||
+ | ====Community examples==== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
\\ | \\ |
transformations/subfield.txt · Last modified: 2023/10/11 20:54 by craigt