User Guide

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

Back Next

Example 1: Read CSV File

Follow the steps below to read a CSV file that trims the leading and trailing spaces and also takes a containing dollar figures and converts them to a standard number without formatting. The following image represents the input CSV file:

From within the Project Designer page, expand the Data Translation folder in the Component Library, and then drag the Read CSV task to the Project Outline.

On the Basic tab of the Read CSV task, specify values for the Read CSV Task attributes:

Input File: The file path and file name of a single file from which to read the data.
Output Row: Set VariableThe name of a variable which will contain the data read from the specified input file.

Click the

Add

button, and then click

Specify Data Options

On the Data Options tab, specify the trim option, which is how the leading and trailing spaces will be trimmed.

Click the

Add

button, and then click

Add Column

to add an element to the Read CSV task.

On the Basic tab of the Column element, specify the Index value of the column (to perform type conversion for).

On the Type Conversion tab of the Column element , specify the following attributes:

: TypeThe data type of this column. Use the value NUMERIC to convert the currency amounts into a standard number as per the example parameter above.
Pattern: The pattern to use to format numeric fields.

Click the

Save

button when complete. When the project executes, a RowSet variable named myData will contain the following data. Note, the data format of ${myData[6]} has been updated to remove the currency format:

${myData} RowSet Variable
${myData[1]}	${myData[2]}	${myData[3]}	${myData[4]}	${myData[5]}	${myData[6]}
34594	Heather	Banks	1998-01-19	BB001	72000.00
34593	Tina	Young	2010-04-01	BB001	65000.00
34590	Kathy	Harris	2007-09-30	KH001	105000.00
34592	Mark	Walker	2012-11-15	KH001	87500.00
34591	John	Davis	2001-06-15	KH001	85000.00

Rename Saved Search

Table of Contents

User Guide

User Guide

Example 1: Read CSV File

Example 1: Read CSV File