Toggle navigation
Features
Pricing
Docs
Downloads
Tools
Blog
Login
Home
Tools
CSV/Delimited Input
CSV/Delimited Input
Try our new interactive
data transformation and code generator tool
.
Data Pipeline Builder 1.0.2
Steps
Input
Transformations
Output
Generated Code
More Transformations
CSV/Delimited Input
Type
Generic
JDBC
CSV / Delimited
Excel
Select the initial data format or leave as "Generic" to decide later.
File
The CSV/delimited file to open.
Field Separator
Leave blank for default (comma).
Line Separator
Leave blank for default (all of \n, \r, and \r\n).
Quote Char
Leave blank for default (double quote - ").
Allow Multi-line
Allow quoted fields to contain line-breaks.
Trim Fields
Remove leading and trailing whitespace.
Starting Row
Number of lines to skip before reading.
Last Row
All rows are read if less than zero.
Field Names in First Row
The first line of records are the field names.
Field Names
CUSTOMER_ID FNAME LNAME EMAIL PHONE URL DOB GENDER CREATEDON MODIFIEDON CREATEDBY MODIFIEDBY
One field name per line. This is a hint to the wizard to tell it the fields available for later steps.
Feedback / Feature Request
© 2024 North Concepts Inc.