transformations:exporttext
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
transformations:exporttext [2021/05/06 22:29] – craigt | transformations:exporttext [2021/07/19 02:08] (current) – [Examples] craigt | ||
---|---|---|---|
Line 6: | Line 6: | ||
=====Description===== | =====Description===== | ||
This action exports a table into a delimited text file. The file name can use either a full or relative path. | This action exports a table into a delimited text file. The file name can use either a full or relative path. | ||
- | |||
- | By default, when the file name has no extension, the action automatically appends the extension " | ||
\\ | \\ | ||
=====Use cases===== | =====Use cases===== | ||
- | Create a plain-text, unformatted data file for use with a wide variety of applications and services.\\ | + | Create a plain-text, unformatted data file (such as CSV file) to exchange data with a wide variety of applications and services.\\ |
\\ | \\ | ||
Line 19: | Line 17: | ||
|Separator|Select the delimiting character used to define columns in the exported file. Options: | |Separator|Select the delimiting character used to define columns in the exported file. Options: | ||
|Decimal|Select the character used within numeric values to define decimal places. | |Decimal|Select the character used within numeric values to define decimal places. | ||
- | |Export mode|Select whether this action will create a new file, or append to an existing file. See the table below for details| | + | |Export mode|Select whether this action will create a new file, or append to an existing file. See the table below for details.| |
|File already exists|When selecting to " | |File already exists|When selecting to " | ||
< | < | ||
Line 51: | Line 49: | ||
\\ | \\ | ||
=====Remarks===== | =====Remarks===== | ||
+ | By default, when the file name has no extension, the action automatically appends the extension " | ||
+ | |||
The " | The " | ||
Line 71: | Line 71: | ||
> Wrap in quotes is " | > Wrap in quotes is " | ||
\\ | \\ | ||
- | **Result:** | + | **Result |
< | < | ||
RecID, | RecID, | ||
Line 83: | Line 83: | ||
The first record' | The first record' | ||
All Zip values are quoted as they are numeric values that have been re-typed as text.\\ | All Zip values are quoted as they are numeric values that have been re-typed as text.\\ | ||
+ | |||
+ | \\ | ||
+ | ====Community examples==== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
\\ | \\ |
transformations/exporttext.txt · Last modified: 2021/07/19 02:08 by craigt