ListExportAsTabDelimitedText(listboxName As String)

 

Shows a File Save As dialog window, where the user can enter a name for the new text file to be created. The contents of the listbox with listboxName will be exported to the new text file.

 

The first row in the exported text file contains the heading names of each column, as shown in the listbox.

 

Columns are separated by a tabulator, i.e. each field is ended by a tabulator character (chr(9)).

 

Each row is ended by a platform specific EndOfLine indicator. The Unix line ending, chr(10) is used by OS X and Linux.

  

Hint: ListExportAsTabDelimitedText can be called without the use of any paramters. In this case the contents of the listbox of the currently active module (addresses, events, infos, items, finances or locations) will be exported.

   

Parameters:

 

Name	Type	Value	Description
listboxName	String	Listboxname	Optional: name of a listbox to export. listboxName corresponds to the ScreenFieldName of a listbox control. Ctrl+Click onto a Listbox to retrieve its ScreenFieldName.

 

Available in:

 

WindowMain	WindowLink
YES	NO

 

Used in:

 

XojoScript Name	GUID
Export List as tab delimited text	9E4AFEA9-E3D6-4C6F-A503-25BD41227BC8

 

Hint: You can find more references to XojoScripts which make use of this function by sending the following SQL statement to the database:

Select id,GUID, ScriptName,ScriptCode from im_scripts where ScriptCode Like '%ListExportAsTabDelimitedText%'

 

Example XojoScript:

 

// Export List as tab delimited file, from scripts menu

// If you want to export a specific listbox, then

// Call ListExportAsTabDelimitedText with its screenfieldname as parameter

// Like: ListExportAsTabDelimitedText("ListboxAddresses")

// When you call it without parameter, then the contents of the frontmost

// list in the databox will be exported.

// Note: You can Ctrl+Click a listbox to see and copy its screenfieldname

 

ListExportAsTabDelimitedText