CSV representation properties - 8.0
Talend Data Mapper User Guide
- Version
- 8.0
- Language
- English
- Product
- Talend Big Data Platform
- Talend Data Fabric
- Talend Data Management Platform
- Talend Data Services Platform
- Talend MDM Platform
- Talend Real-Time Big Data Platform
- Module
- Talend Studio
- Content
- Design and Development > Designing Jobs
- Last publication date
- 2024-03-28
-
New line character type: Select whether you want to define a newline based on
your platform or specify a custom one.
-
New line character: Enter the character sequence that represents a
newline.
-
Delimiter: Enter the character used to separate values.
-
Skip header reading: Select this
check box to skip the first line, which is useful when the first line is a
header. Note that if no header is present, selecting this check box will skip
the first line of data.
-
Skip header writing: Select this
check box to skip the first line when printing a CSV file.
-
Generate default header: Select this
check box when there is no header in the file to generate default header values
by concatenating 'Col_' with the position index of the column (e.g. 'Col_1',
'Col_2', 'Col_3', and so on).
-
Quote mode: Select how quotes should
behave when printing, and has five possible values:
-
None: No quote mode defined
-
All: Quote all fields
-
Minimal: Quote fields which contain special
characters such as a delimiter, quotes character or any of the
characters in line separator
-
Non-numeric: Quote all non-numeric fields
-
Never: Never quote fields
-
Quote character: Enter the character
to be used as value encapsulation marker.
-
Comment start character: Enter the
character used for comment identification.
-
Escape character: Enter the character used to
escape special characters in values.
-
Ignore surrounding spaces: Select
this check box to ignore whitespaces enclosing values.
-
Ignore empty lines: Select this check
box to skip empty lines.
-
Trim: This lets you trim leading and trailing blanks.
-
Character encoding: Specify the character
encoding for the data to be processed. For more information, see Character encoding.
-
Enforce zero
scale on output decimals?: Select this check box if you want to
remove all fractional digits for Decimal elements with the Decimal
Places property set to
0
.
-
Decimal sign is implied on output:
Select this check box if you do not want the decimal sign to appear in the
output.