export

Exports a database table to a delimited text file.

Summary

Parameter	Description	Default
table	The table to export.	None
base	Alias for table.	None
database	Alias for table.	None
field	The column to add (or delete if delete and verify are true).	None
file	Filename to export to.	None
sort	Sort the output rows.	None
type	Specify the column and row delimiter type.	None
delete	If verify attribute also set, deletes column specified by field attribute rather than adding a column.	None
verify	Must be true when deleting a column.	None
hide	Suppress any output text that would ordinarily be returned from this tag. (This universal parameter was introduced with Interchange version 5.5.2.)	No

$Tag->export({
table => $table,
});

or similarly with positional parameters:

$Tag->export($table, $attribute_hash_reference);

Exports the named table to a delimited text file. Also see the [import] tag which is used to import files into tables.

The table to export.

The column to add (or delete if delete and verify are true).

Filename to export to. Note that the NoAbsolute directive and other conditions may affect actual location of the output file.

Output sorted rows (usage: sort="sort_field:sort_option"). See search/form variable "mv_sort_option" for sort options.

Specifies the row and column delimiter types. Either NOTES or one of the following:

If using NOTES:

Column delimiter is the value of the notes_separator parameter (defaults to "\f").
Row delimiter is the value of the notes_field parameter (defaults to "notes_field").

See the NOTES description in the type parameter.

See the NOTES description in the type parameter.

If verify attribute also set, deletes the column specified by field parameter, rather than adding a column.

Must be true when deleting a column.