Set the Value List Items into a variable, copy and pasted into a text file. Then copy and pasted into the value list in the new file.
Set Variable [ $file; Get( FileName ) ]
Set Variable [ $names; ValueListNames ( $file ) ]
Set Variable [ $count; ValueCount( $names ) ]
Set Variable [ $i; Value:$i+1 ]
Exit Loop If [ $i>$count ]
Set Variable [ $$result;
GetValue ( $names ; $i ) ; ¶ ;
ValueListItems ( $file ; GetValue ( $names ; $i ) ) ; ¶ ; ¶
From another website - you want a list
Re: Exporting Value Lists
Sorry, I'm not entirely clear, but it looks as if that's going to form a long list of all the value list items from the file which is rather more than I'm after. I'm far from a Filemaker expert, but I don't see the place where it's copied to a text file.
To be honest, and I don't want to seem ungrateful, but that seems like a lot of work just to get Filemaker to export what it seems happy to admit are the actual field contents.
BUT, many thanks for the response.
I figured it out.
The field I was using was a calculation field whose result was defined as a number. Although FIlemaker will display this as text, it won't export it. I changed the type to text and all is well.
Thanks again, for the suggestion, though.