Text tables export
Sample script file: TextExport.mrs
This example script is based on the Museum sample data set. See
Running the sample table scripts for information on running the example scripts.
UNICOM Intelligence Reporter comes with a Text Export component, which enables you to export tables to a delimited text file (typically a .csv file).
The file encoding is UTF-8 and the output files contain the UTF-8 0xEF BB EF signature. The exported data is in the character delimited format, and the default character is a tab. Tables are also delimited by a character, which must be different from the field delimiting character. Here is an example of the .csv output for a simple table of Age by Gender:
"Museum of the Living World"
"Visitor Survey"
"Museum of the Living World"
"Age by Gender<BR/>"
""
"Table: 1<BR/>Level: Top"
"Gender of respondent"
Base Male Female
"Age of respondent"
"Base" "602" "339" "263"
"11-16 years" "38" "23" "15"
"17-20 years" "82" "50" "32"
"21-24 years" "95" "51" "44"
"25-34 years" "192" "108" "84"
"35-44 years" "91" "49" "42"
"45-54 years" "55" "32" "23"
"55-64 years" "33" "16" "17"
"65+ years" "16" "10" "6"
""
"Cell Contents: <BR/>- Count<BR/>"
""
""
See also