Jump to content

Import Field Names from Tab File


LindaG
 Share

This topic is 6434 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a tab-delimited file and the first record is the field name. I want to create an fp5 file with the same field names. Dragging the file to Dev. 6 creates a record out of the names. crazy.gif

When I start by creating a new file, it wants the field names. ooo.gif

And I can't import until I create a file! wink.gif

I searched forums ... I really did. But I admit I only looked for an hour, trying every keyword I could think of. Still, here I am ... Please tell me I won't have to manually create 205 field names for a migration file? Lie if you have to ... smirk.gif

Link to comment
Share on other sites

OK -

How about converting this Tab delimited file to an Excel spreadsheet, with the first row containing your field names?

Then you can drag that straight onto Developer 6 and it will create a new file with your field names.

No manual creation required (except opening into Excel of course )

HTH

Link to comment
Share on other sites

For the one or two of you that don't have Excel, you can get the same effect by converting the first line of the text file into the format of a Merge file. Move the 1st line out into its own file, then substitute commas for tabs.

You will get basically:

fieldname1,fieldname2,fieldname3, etc.. (no leading spaces, no quotes)

Open the 1 line file with FileMaker.

You've got a file with the field names.

Import the rest of the lines.

Obviously easier to open with Excel.

Link to comment
Share on other sites

This topic is 6434 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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