Qualifiers with CSV input using Flat File Wizard?

Replies to This Discussion

Permalink Reply by Joe Klug on August 30, 2017 at 5:08am

Garrett,

The Flat File Parser has a feature called "User Defined" which allows you to manually define the structure of the flat file and you can designate fields with a quote character.  To do this:

1.  On the Flat File Type wizard page, select your type (comma delimited), click next

2.  On the Comma-Delimited Flat File wizard page, select User Defined (and if your flat file will have column names in the first row, check that box too), click next

3.  On the Set Column Details wizard page, in the Columns box, right click and select Add.  Set the column name, and if that column will have quotes, set the quote character.

4.  In the Columns box, select the row just created, right-click and select Add After Selected Row.  Set the column name, and if that column will have quotes, set the quote character.

5.  Repeat step 4 for each column in your flat file

The reason you have to do it this way is because when you provide the wizard with a sample flat file it attempts to load it into the flat file engine based on the settings already provided (assuming no quoted fields).  We added the "User Defined" option for this very use case.

Let me know if you need any more help!

Joe

• ▶ Reply

Permalink Reply by Garrett Dieckmann on August 30, 2017 at 8:52am

Ah!

Thank you for pointing that out Joe.

Garrett D.

• ▶ Reply