I am using FMP 11 and dealing with an older file that has repeating fields.
Is there any way of exporting the data and having a field for each entry.
There is a limit of two date entries for the field I am trying to do this
to, but every time I try an export, the two dates come out in one field and
I can not find a way to separate them into two separate fields.

Thanks

"Stephen Larivee" <larivees (AT) grafton (DOT) k12.ma.us> schreef in bericht
news:hu5tp4$fod$1 (AT) news (DOT) eternal-september.org...
Separate them before you export. I don't know of any other way.
Create two calcs like this cDate1<date; OldDate[1]>, cDate2<date;
OldDate[2]>
Use these for import.

--
Keep well / Hou je goed

Ursus

I am not getting anywhere...yet.
Do I create the two fields first? What is the meaning of "cDate"? Is that
the name of one of the new fields? What is the meaning of "date" right
after the < What is the meaning of OldDate? Is that the name of the
repeating field?

Do I use this calculation once for the first new field and then it will
populate both new fields??

The name of my repeating field with two occurrences is MMR.

I like your solution and it seems like it should work, but it is not, at
least the way I am entering it.

"Ursus" <ursus.kirk (AT) ziggo (DOT) nl> wrote

"Stephen Larivee" <larivees (AT) grafton (DOT) k12.ma.us> wrote


You'll need two new Calculation fields - one for each possible date.

I haven't got FileMaker on this computer to double-check the function name,
but form memory the fields should be:

Date1 Calculation, Date Result, unstored
= Get Repetition(MMR, 1)

Date2 Calculation, Date Result, unstored
= Get Repetition(MMR, 2)

You can then export these fields (along with all the other wanted fields of
course) instead of the original MMR one.


Another option is to use the original MMR field in the export, and then open
the exported file in a text editor and perform a Find-Replace to swap the
character that separates repeating field data, which I can't recall off-hand
what it is (vertical tab?) to the appropriate field delimiter (tab, comma,
etc.).


Helpfull Harry )

This worked great!! Quick and easy. Problem resolved.

I did try your 'another option' below but had no luck. There was a small
white rectange between the two dates but nothing I did could replace it with
a tab. I have a posting on a Word group to see what I am overlooking in
Word that is keeping me from doing this in Word.

Ursus, thank you also for your input, but I should be all set now

Thanks again, All!!!

"Your Name" <your.name (AT) isp (DOT) com> wrote

In article <hu6iu9$oed$1 (AT) news (DOT) eternal-september.org>, "Stephen Larivee"
<lariveesl (AT) yahoo (DOT) com> wrote:

In Word you might be able to copy that rectangle (which is really just a
placeholder for an unknown / undisplayable character) and paste it into
the Find box of the Find-Replace window. In the Replace box you can type
^t (or maybe /t) for the tab character, or you can copy-paste a tab from a
document.

It's easier to use a proper text editor (or text file manipluator like
GSAR) that allows you to search for hex or decimal character codes.

Helpfull Harry )

Stephen,
Although your problem has been solved I will still answer your other
questions.

Normally first letter of fieldnames are uppercase. A lower case c denotes a
calculation ( a lower g denotes a global, etc)

after the name follows a < wich starts specifying how the field is set up.

first parameter states the result of the calc (in this case the calc returns
a date)

the ; seperates first and second parameter

second parameter is the actual calculation.

In this case it has something extra added: the [ ] which holds the number of
the referred repetition. It is the same as GetRepetition(Field,RepNum) but
in my opinion easier to implement.

cDate<Date;MyTable:OldDate[1]> is the same as
cDate<Date;GetRepetion(MyTable:OldDate,1>

Then follows the > which closes the definition of the calc

--
Keep well / Hou je goed

Ursus

"Stephen Larivee" <lariveesl (AT) yahoo (DOT) com> schreef in bericht
news:hu6b33$kaf$1 (AT) news (DOT) eternal-september.org...