🚀 go-pugleaf

In <92097.125511HLM6@psuvm.psu.edu> HLM6@psuvm.psu.edu writes:

>If you have a FM layout that looks like this:

> ========== ========== ==========
> | Field1 | | Field2 | | Field3 |
> ========== ========== ==========
>            |        |
>            ==========
>            |        |
>            ==========

>Where Field1 and Field3 are normal fields, and Field2 is a repeating field,
>your text file must look like this:

>Data1<tab>Data2a<gs>Data2b<gs>Data2c<tab>Data3

><gs> is called a "group separator.  It's ascii value (decimal) is 29.  I don't
>know how you can create this format from Excel.

Microsoft Word can cut and paste this <gs> character with no problem.  I've
done several imports into repeating fields using this.

I didn't read the original article, but if you're trying to go from Excel to 
Filemaker.  I'd create a column between each column which is to repeat, then
fill this column with a special character or series of characters '@#$'.  Then
export as a tab delimited file and load into Word.  You can then do a 
find/replace using ^t@#$^t replaced with <gs> (the special character).

I believe there is a special character option in Word to create a character 
based on it's ASCII code.  If you have problems with this, you can make a little
Filemaker db with a repeating field and export it into Word.  You will then see
this <gs> character and be able to cut and paste it...

I'd be happy to give you a further hand through E-mail...

(<=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=>)
Darren J. Wiebe                         | Internet:  djwiebe@ccu.umanitoba.ca
Box 141, Station L                      | AppleLink: CDA0010T
Winnipeg, Manitoba, Canada  R3H 0Z4     | Quote: 'scuse me,
Disclaimer:  Disclaimer!  I don't need  |            while I puke and die!
              no stinkin' disclaimer!   |                   -The Dead Milkmen
(<=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=>)