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

REPORT (continued)

Post-Processing Formats (continued)

SYLK

Symbolic Logic (SYLK) is a data interchange format that was developed by Microsoft^® to support the transfer of data to and from Microsoft software programs. SYLK files are transmitted as ASCII text files; files are divided into records by carriage return/line feed characters. Capture the report elements by highlighting text from the line that says "ID;PDIALOG" all the way down to and including the letter "E" at the bottom. Copy and paste into Word. Save as a .txt file. Open in Excel.

• To use the SYLK format:

?report s3/co,ni,ta/all sylk

Align paper;  press ENTER
?<enter>

ID;PDIALOG
"DIALOG(R)File 101 :Disclosure Database(R)"
"(c) 2008 Thomson Financial All rts. reserv."
B;X3;Y22
F;C1;DF0G31
F;C2;DF0G16
F;C3;DF0G16
F;W1  1 30
F;W2  2 10
F;W3  3 10
C;Y1;X2;K"Net"
C;Y1;X3;K"Total"
C;Y2;X1;K"Company"
C;Y2;X2;K"Income"
C;Y2;X3;K"Assets"
C;Y3;X1;K"Name"
C;Y3;X2;K"(000s)"
C;Y3;X3;K"(000s)"
C;Y4;X1;K"INTELSAT CORP"
C;X2;K99532
C;X3;K5734877
C;Y5;X1;K"INTELLON CORP"
C;X2;K-3029
C;X3;K7646
C;Y6;X1;K"INTELLIGENTIAS INC"
C;X2;K-18
C;X3;K20
C;Y7;X1;K"INTELLIGENT SYSTEMS CORP"
C;X2;K4469
C;X3;K15010
. . . .
E

DIF

The Data Interchange Format (DIF) was developed for VisiCalc and can be used to move data between spreadsheets. The format identifies the number of rows and columns to be transmitted and indicates whether a field is textual or numeric. To request this format, append the DIF to your REPORT command, e.g.,

REPORT <Sn>/<field codes>/<items> DIF

FIXED

The System Data (FIXED) format produces fixed-length records with fixed-length fields, in which all data is left-justified. To request this, append the FIXED to your REPORT command, e.g.,

REPORT <Sn>/<field codes>/<items> FIXED

Note: Post-processing formats apply to all Dialog files having the REPORT capability. They cannot be used with preformatted reports.

(REPORT TITLES) 

top