Managed File Transfer User Guide

10.5.3
- 10.5.0
- 10.4.0
- 10.2.3
- 10.2.2 HotFix 1
- 10.2.2
- 10.2.1
- 10.2

Back Next

Formatting Options

Data Options specified will apply to every column in the file. For example, if you want to remove the leading and trailing white spaces on every field you can set that by using the Trim attribute. If you have a lot of columns in your file and you want all of the data trimmed except for a couple of columns then you can override the data options for a specific column by adding a Column element from the

Add

button on the page toolbar.

Column elements allow you to specify specific options for each column in your delimited file. You can add a name to the column, indicate the data type, change the formatting and more. The Pattern attribute of the Column element allows you to specify the date or number format of the input. For example, if your input contains a numeric value like $4,500.99 then you can specify a pattern of $###,###.00. After the data is read in it will be converted to 4500.99, which is a format that is accepted by databases. If the input doesn't match that pattern then the

Project

will fail preventing garbage data from being processed.

Read CSV Task

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal