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.

Exporting Data to Create a Fixed Length Flat File

Featured Replies

  • Newbies

I am using Filemaker 6.0 and need to export Order Data, Name, Address, City, State & Zip to create a fixed length flat file. The file I need to create must be 168 characters in length. I am importing orders from our website into filemaker and need to transfer them to our AS400 system. We have another system that reads order cards and creates an ALT.OUT file with the data. I need to duplicate this file to transfer the data. How do I format the file with fixed spaces?

Shane

Sounds like you need one calculated field that places the data in the expected character columns. You can then just export all the records from the single field.

Create an account or sign in to comment

Important Information

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

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.