ExportListToDelimitedFile

Top Previous Next

×V4.1Ø

S	A	W	WS
ü	ü

Syntax:

ExportListToDelimitedFile <List Name> <FileNameDestination> <Delimiter>

Where:

<List Name> is the user defined name that is assigned to the list.

<FileNameDestination> is a literal string or a variable that contains a literal string.

<Delimiter> is a literal string or a variable that contains a literal string.

Description:

This command is used to take the contents of a List and export them to the specified text file. The FileNameDestination parameter defines the directory and file name, including extension, where the list will be exported. The Delimiter is an optional parameter. If no delimiter is provided then a comma will be used.

Note: If #INPUTFILENAME# is used and there is no input file specified, the text will not be replaced. The following key terms may be used in the name of the file for export. These terms will be valued when the command runs and the values will be used in the name of the file:

Term	Will be replaced by
#TODAY#	The current date in the format MMDDYY
#DATE#	The current date in the format MMDDYY
#NOW#	The current time in the format hhmmss
#TIME#	The current time in the format hhmmss
#INPUTFILENAME#	The current input file name without the extension
#SCRIPTFILENAME#	The name of the script file without extension
#SCRIPTFOLDER#	The name of the folder path where the current script file is located

If the file specified does not exist, EMUE will create it.

Sample 1:

The following example will export List_01 to a CSV file.

ExportListToDelimitedFile List_01 "C:\EMUE\Excel_Files\ChargeOuput.csv"

Sample 2:

The following example will export List_02 to a double pipe delimited file.

ExportListToDelimitedFile List_02 "C:\EMUE\Excel_Files\ChargeOuput.txt" "||"