June 8, 200421 yr 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 ...
June 8, 200421 yr 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
June 8, 200421 yr Author 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!!
June 8, 200421 yr 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.
Create an account or sign in to comment