Import Field Names from Tab File

[LindaG]

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.

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

And I can't import until I create a file!

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 ...

[andygaunt]

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

[ESpringer]

Ooh, that's neat, Andy!

[LindaG]

Andy, this is absolutely brilliant! You just saved me HOURS worth of work.

Thank you so much! Bang-zoom-done. And you didn't even have to lie!!

[Fenton]

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.