Table of Contents

Search

  1. Preface
  2. Introduction
  3. Dashboard
  4. Resources
  5. Workflows
  6. Task Reference
  7. Services Overview
  8. Users
  9. Logs and Reports
  10. Encryption
  11. System
  12. Appendix
  13. Glossary Terms

Formatting Options

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.

0 COMMENTS

We’d like to hear from you!