Each row is delimited by new-line and each column is separated from other columns by a column delimiter character, such as a comma, pipe or the tab character.
The delimited sample shown below uses a comma (‘,’) character as a column delimiter. The column names in the header row corresponds to the columns for each record.
In the example above column 1 (one) “acct#”, column 2 (two) “first name”, column 3 (three) “last name”, column 4 (four) “phone#’, column 5(five) “amount due”, column 6 (six) “last payment date”.
In some cases your client might provide you with more detailed information. This can be used while mapping your data for your Import Mapping Definition (IMD) or Temporary Mapping Definition (TMD).
Pipe Delimited File
The delimited sample shown below uses a comma (‘|’)
Tab Delimited File
The delimited sample shown below uses a tab: