HomeSite MapCustomer Logon
 Dialog1
 DialogClassic
 DialogPRO
 DialogSelect
 DialogWeb
 ProQuest Dialog
Authoritative Answers for Professionals
Follow Dialog on Twitter  Follow Dialog on Facebook  Join Dialog on LinkedIn  You Tube e-Newsletters  RSS Feeds  Share

Support : DialogLink : Online Help : REPORT :
Post-Processing Formats

REPORT (continued)

Post-Processing Formats

Command Format:REPORT <Sn>/<field codes>/<items> DELIM
REPORT <Sn>/<field codes>/<items> SYLK

The two main post-processing formats available for online REPORT output from Dialog are DELIM and SYLK. These formats facilitate the post-processing of data with personal computer applications software. When you use a post-processing format, Dialog automatically modifies the data to conform to the specified format.

To request either of the formats, append the format code shown above to your REPORT command. The maximum line width for reports in post-processing formats is 240 characters.

Two additional post-processing formats are available:

    Data Interchange Format DIF
    System DataFIXED

 

DELIM

The Comma-Delimited (DELIM) format provides comma delimiters separating each data column in the report. There are no fill blanks to the left or right of the data in each field. Text fields have quotation marks (" ") at the beginning and end. Empty text fields are indicated by a double set of quotation marks. Empty data fields have no special markers. Fields with no data are separated from preceding and succeeding fields with a comma delimiter.

• To use the DELIM format:

?report s1/co,ni,ta/all delim

Align paper;  press ENTER
?<enter>

DIALOG(R)File 101 :Disclosure Database(R)
(c) 2008 Thomson Financial All rts. reserv.
"","Net","Total"
"Company","Income","Assets"
"Name","(000s)","(000s)"
"INTELSAT CORP",99532,5734877
"INTELLON CORP",-3029,7646
"INTELLIGENTIAS INC",-18,20
"INTELLIGENT SYSTEMS CORP",4469,15010
"INTELLI CHECK INC",-2880,5656
"INTEL CORP",5044000,48368000
"INTELLIGENT LIVING CORP","",766
"INTELLISYNC CORP",-13414,160793
"INTELLIGENT MOTOR CARS GROUP I",-338,581
"INTELIDATA TECHNOLOGIES CORP",-33235,10605
"INTELGENX TECHNOLOGIES CORP","",""
"INTELLIGENT SECURITY NETWORKS",-1494,55
"INTELLIGROUP INC",-6385,44488
"INTELLECTUAL TECHNOLOGY INC",615,3512
"INTELLIGENT SPORTS INC",-449,60
"INTELLIREADY INC OK",-1959,131
"INTELEFILM CORP",-12636,4857
"INTELLIGENT CONTROLS INC",-282,9392
"INTELLICORP INC",-7246,11494

(continued) 

top

DialogLink Online Help

DialogLink 5 Enhanced Features
Alerts
Bluesheet Annotations
DIALINDEX®
Linking Pane
Marking Retrieve Buffer Content
Record Links
Saving and Editing Search Saves
Reporting Option

Commands Available Through DialogLink

ADD
BEGIN
CAPTURE
COST
DISPLAY
DISPLAY SETS
EDIT
EDIT ADDRESS
EXCEL
EXECUTE/ EXECUTE STEPS
EXPAND
HELP
HTML
IDENTIFY DUPLICATES
IDENTIFY DUPLICATES ONLY
IDPAT
KEEP
LIMITALL
LOGOFF
LOGOFF HOLD
LOGON
MAP
ORDER
PICKLIST
PRINT
RANK
RANK FILES
RECALL
RELEASE
REMOVE DUPLICATES
REPEAT
REPORT
SAVE ALERT
SAVE SEARCH
SELECT
SEND
SET
SHOW
SHOW PREFERENCES
SORT
TEXT
TYPE
VIEW
VISUAL EXPAND
VISUAL RANK
WORD
XML
XSLT

Appendix A: Punctuation and Symbols

Appendix B: Restricted Words

Appendix C: Glossary

top of page

  ProQuest   |   About Us   |   Site Search   |   Site Map  
Copyright Notices   |   Terms of Use   |   Privacy Statement