Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

export field with multiple selections in value lis

concrete
in Value Lists

Featured Replies

I have a field with a value list and check boxes to select multiple values from this list.

if I export the file with this field to a tab delimited text file, I get all the selection within that field seperated with a "space".

Is it possible to get a "comma' and a "space" there.

that would make things a lot more understandable.

i hope this is clear...

thx

It's not actually a space that it's putting in. Filemaker puts carriage returns between the multiple items in a checkbox field, but it converts them to vertical tabs when it exports. What you need to do is create a calculated field cChkBoxExport with this formula:

Substitute(TheOriginalField,"

  • Author

thx bob

you're a life saver

i was fiddling around with the Substitute thing, but i didn't know i had to look for a carriage return

many thx

Create an account or sign in to comment

https://fmforums.com/topic/14728-export-field-with-multiple-selections-in-value-lis/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.