Format CSV data as text pattern
Fill out a text pattern for each row in a CSV file. Use double square brackets([[) with the CSV column names to be updated in the template text
Application
- Text
Inputs (what you have)
| Title | Description | Data Type | Required? | Example |
|---|---|---|---|---|
| CSV file | CSV file to extract data from | File | Yes | data.csv |
| Text pattern | Text pattern to fill out with the data extracted from the CSV. Use double square brackets with the CSV column names to be updated in the text pattern. If a column name can't be found it will be replaced by a blank value | Text(Long) | Yes | { ”First”: “[[First Name]]“, ”Last”: “[[Last Name]]“ } |
| Separator text | The value to separate each generated text pattern | Text(Long) | No | , |
Note: the value of inputs can either be a set value in the configuration of the Wrk Action within the Wrkflow, or a variable from the Data library section. These variables in the Data library section are the outputs of previous Wrk Actions in the Wrkflow.
Outputs (what you get)
| Title | Description | Data Type | Required? | Example |
|---|---|---|---|---|
| Generated text | Text generated using the CSV file and text pattern | Text(Long) | Yes | { ”First”: “Jon“, ”Last”: “Doe“ },{ ”First”: “Jane“, ”Last”: “Smith“ } |
Outcomes
| Name | Description |
|---|---|
| Success | This status is selected if the template text was successfully generated. |
| Impossible to Complete | This status is selected in the event of the following scenarios:Unable to interact with the provided CSV |
Requirements
- N/A