Step 5. Modify the field formats

Input and output field formats depend on field types. The format of the input fields affects the way the corresponding text value will be read in. Let's take "20050123" string value as an example. The value looks like a date, so to parse it correctly the corresponding input field should have the following format: YYYYMMDD, which will convert your input value into a date 01/23/2005. Only date fields have input formats. Other types of data are dealt with automatically. The output field formats define how the converted text value will look in the preview and do not affect the actual text conversion process.

Now we can proceed to Step 6. Edit field map

(or go back to Step 4. Check your output structure )