madSearch2's primary means of sharing data with other applications is via the export of a table's information to a delimited file. A Delimited file is a plain text file in which each record is given its own line. Each of the data fields that comprise the record are separated by a specified character. additionally, data fields are often Delimited (surrounded) by a specified character. An example of a record within a Delimited file would be as follows:
"John Doe","123 Dumb Bunny Lane","Ossining, NY 10025","914.555.1212"
The separator character is used by another application to determine where data fields begin and end. The delimiting character is used to ensure that a data field, whose value contains the separator character, is not improperly divided. In the example above, the separator character is a comma. The delimmitting character is a quotation mark. The quotation marks around the CityStateZip field prevent an application from breaking the CityStateZip field value for the record above into "Ossining" and "NY 10025".
two things to note when using madSearch2's Delimited file export utility:
Exporting a madSearch2 table to a Delimited file requires administrative privileges to the underlying data table.
The export utility will have the browser prompt you to save the exported information on your local computer.
In order to export a madSearch2 table, simply follow these instructions: (remember the separator character and delimiting character discussed above? You're going to be asked to choose these next...)
| Table Export Instructions |
| step 1 |
From the madSearch2 menu, select the "Export A Delimited File" option. The madSearch2 Delimited file export screen will appear.
|
| step 2 |
In the field named "Table Directory", enter the directory path of the table you wish to export. For example,
/wwws/data/cu/pooh/
|
| step 3 |
In the field named, "Table Name", enter the name of the table you wish to export. For example,
mytable
|
| step 4 |
From the choices presented to you within the field, "Fields Are Separated By", select the character you wish to have separate the record data fields within your Delimited file.
The standard separator characters are among your choices: commas, tabs, and semi-colons. If you wish to use a different character, select the "Other" option and type the character you wish to use in the "Other" option's associated field.
|
| step 5 |
From the choices presented to you within the field, "Fields Are Delimited By", select the character you wish to use in delimiting the data fields of each record.
The standard delimitter characters are among your choices: quotes and nothing (no character at all). If you wish to use a different character, select the "Other" option and type the character you wish to use within the "Other" option's associated field.
|
| step 6 |
When you have reviewed your selections, click the "Export Table" button. Your browser will prompt you to save the file on your local computer.
|
|
|