Jump to content
Sign in to follow this  
janet K

Fixed Position Export

Recommended Posts

Is it possible to export data from a file in a fixed Position Format? I dont believe I can do this in an export. Maybe I can do it in a script, putting all the data into one field and just exporting that one field.

What I want to do is take a tab deliminated file that I get import it into filemaker and take it out in a fixed position format. So that the

Gender is Position 1-2

First Name is Positions 3-10

Last Name is in Position 11-15 and so on.

Any Ideas as to how to do this?

Thanks, Janet

Share this post


Link to post
Share on other sites

The way I've seen most people do it is just as you described.

Make a calculated field that puts all the data in the right place, taking care to pad the field values so that everything will always line up.

Do an export, and all you need to do is export one field.

good luck!

it isn't hard, just tedious.

Jerry

Share this post


Link to post
Share on other sites

cool.gif

Hello Janet,

YES!!! You can 'export' FileMaker data in 'fixed' length! Use the 'DBF' export option.

WARNINGS!

You will have to 'play' with this to make sure your data is 'exported' properly. If a field has more characters than you expect... then you will have troubles when 'importing' into another system. For example... let's say you design your system with the intention of no more than 12 characters in a 'lastNAME' field, but someone puts in 15 characters... when 'exported', this will create a problem.

You will also encounter troubles when exporting 'DBF' files... they don't include an 'end-of-record' delimitor.

SOME IDEAS...

- check to see if your other system will 'import' 'tab-delimited' files instead of 'fixed-length'

- create field 'validations' to 'warn' users if they exceed the maximum characters allowed

- create a text field with 'auto-enter' a carriage return character... export this as the end-of-record delimitor

- create an 'export' calc field that 'concats' all your data together with an end-of-record delimitor

Hope this helps!!!

Bob Kundinger

cool.gif

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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