Exporting Two Records From One

[fmsavey]

I need to be able to export two records from one. Using a calculation field I did the following:

export = field1 & "¶" & field2.

I then do an export of the field "export". When I attempt to load this file back into FM the return character is not recognized as a record delimiter. Does anyone know of a way to accomplish this?

By the way, if I open this file using Wordpad and then save it, and then import it into FM, field1 and field2 are brought in as separate records. Problem is I cannot script the Wordpad part.

Thanks everyone for your help!

[Fitch]

A plugin such as Troi File or MooPlug can do this easily.

Or: you probably could put together a VBScript, batch file or something to poke your text file.

Or: script multiple exports or imports, or record creation pre-export or post-import.

[comment]

Another way to do this would be to export as XML, with a suitable stylesheet.

However, the very need indicates a possible flaw in the file structure. If two separate records are required for the export, why aren't there two records to begin with?

[fmsavey]

I am importing data from Adobe pdf forms. Each form can have multiple records. I use FM to parse the information into usable records.

Any recommendations on a crash course in style sheet writing?

[comment]

I don't think there is such a thing.

Why don't you create the required records in Filemaker, before exporting them (or whatever you need to do with them)?

[Cabinetman]

I was able to do it............

Basically just use the export field contents with your calc field.

Here's an example

export_2_records.zip