Solving Issues for Fixed and Delimited Fields in PDW

You may experience some common problems when you define your electronic files' fields. For the following problems, use the suggested solutions.

Fixed Fields

For files with headers that you cannot remove but you do not want to import, define the start position one character after the last character position of the header.

For example, if the header ends at position 128, enter 129 for the first field.

Delimited Fields

The following three problems are common when you use delimited fields:

Problem	Solution
If you are using quotation marks (") to represent inches in Microsoft Excel, Excel tries to treat these characters as enveloping characters.	Use Microsoft Access to save files as text (TXT) when some fields include quotation marks.
If the data in a .csv file is comma (,) delimited and some data elements already include commas, the system incorrectly separates the data.	Use quotation marks (") as the enveloping character instead.
If a quotation mark enveloping character causes the data to split incorrectly, then the fields within the files include commas and quotation marks.	Change the file to a Tab delimited text (TXT) file and remove the quotation marks as enveloping characters.