To create a delimited data extraction where each field is separated by a specified character, utilize the FD footnote.
Things to consider when using FD footnote:
w FD footnote is used to define the field-delimiter character to use to separate fields
w All fields are separated by the specified character
w All blank spaces between fields are removed
w All non-numeric fields are placed in quotations
w If you want to remove quotation marks around non-numeric fields change the data type of the field to a numeric data type such as INT
w Suppress form feeds and page headers
w Set BANNEER prompt to NONE
w Set PAGE header to N
w Set Lines/Page = Page Size
w Set SFF, PFF, and EFF to NO
w Set field delimiter footnote if record are variable length (FD ASCII.code)
w Define NL line attribute to suppress carriage/return linefeed for record lengths > 200
Example Footnotes:
EFF NO
SFF NO
PFF NO
FD 59
Sample Output:
“MOUSE,MICKEY”;”M00001”;”01/01/2002”;”ADM IN”
“DUCK,DONALD”;”M00002”;”01/02/2002”;”DIS IN”
“MOUSE,MINNIE”;”M00003”;”04/01/2002”;”REG SDC”