ValueListForExport ( )

Function stats

Average user rating
38
263
9999
Support
FileMaker 9.0 +
Date posted
22 August 2010
Version
1
Recursive function
Yes

Author Info
 Daniele Raybaudi

9 functions

Average Rating 5.0

author_avatar



 

Function overview

Prototype

ValueListForExport  (  )


Parameters

No parameters for this function.


Description

Tags:  List   Export  

Returns a string suitable for export of all the Value Lists of the DB.

FileMaker can create a new DB based on the generated .txt file that will have:
One record
As many fields as the number of the value lists ( with their names )
All the values into each field

Examples

Sample input

ValueListForExport


Sample output

The alphabet !!    Flag ( one )    More and more ...
a b c d e f g h k j i l m n o p q r s t u v w x y z    1    One More Two X One Two-Edged Three Someone Xray Four

 

Function code

/*
ValueListForExport Custom Function

Author: Daniele Raybaudi
Parameter: none
Recursive: yes

Returns a string suitable for export of all the Value Lists of the DB.

FileMaker can create a new DB based on the generated .txt file that will have:
One record
As many fields as the number of the value lists ( with their names )
All the values into each field
*/

Let([
vlNames = ValueListNames ( Get ( FileName ) ) ;
$count = $count + 1 ;
vlName = GetValue ( vlNames ; $count ) ;
vlValues = If ( $count > 1 ; "    " ) & Substitute ( ValueListItems ( Get ( FileName ) ; vlName ) ; [ "    " ; " " ] ; [ ¶ ; " " ] )
];
Case(
$count = 1 ; Substitute ( vlNames ; ¶ ; "    " ) & ¶ & vlValues & ValueListForExport ( ) ;
$count ≤ ValueCount ( vlNames ) ; vlValues & ValueListForExport ( ) ;
Let ( $count = "" ; "" )
)
)

// ===================================
/*

    This function is published on FileMaker Custom Functions
    to check for updates and provide feedback and bug reports
    please visit http://www.fmfunctions.com/fid/263

    Prototype: ValueListForExport( )
    Function Author: Daniele Raybaudi (http://www.fmfunctions.com/mid/38)
    Last updated: 22 August 2010
    Version: 1

*/
// ===================================

 

 

 

 

 

 

 

Top Tags

Text Parsing  (33)
List  (32)
Date  (28)
XML  (26)
Format  (23)
Sql  (22)
Dev  (20)
Debug  (17)
Layout  (15)
Interface  (15)
Text  (14)
Variables  (12)
Filter  (11)
Layout Objects  (11)
Design  (10)
Array  (8)