How do I create a delimited download with the NPR Report Writer?

Jenny — Sun, 13 Aug 2006 17:56:22 GMT

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”

How do I create a fixed-width download with the NPR Report Writer?

Jenny — Sun, 13 Aug 2006 17:54:41 GMT

To create a fixed-width data extraction where each field is set to a defined width, utilize the RL footnote.

Things to consider when using RL footnote:

w RL footnote is used when a record must be longer than 200 characters/line

w RL can be used with the NL line attribute since the report picture is still limited to 200 characters across

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 record length footnote to desired length

w Define NL line attribute to suppress carriage/return linefeed for record lengths > 200

Example Footnotes:

EFF NO

SFF NO

PFF NO

RL 150

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

Search results matching tag 'Download'

How do I create a delimited download with the NPR Report Writer?

How do I create a fixed-width download with the NPR Report Writer?