Our Preferred 5 Star Hosting Provider - Award Wining FileMaker Pro Hosting
Results 1 to 4 of 4
  1. #1
    FREE Member
    Join Date
    Sep 2009
    Posts
    14
    Location
    N. Hollywood, CA
    FileMaker Version
    FM 9
    OS
    Windows
    Skill Level
    Novice
    Downloads
    0
    Uploads
    0

    exporting and separating repeating fields

    Hi,

    I'm trying to figure out how to Export repeating fields to Excel. Each time I do all of the data is bunched together in one column rather than separate cells. There is a "box" separator, but I don't know how to replace it with a tab?
    Warning: This is an Old Thread
    This discussion is older than 420 days. information contained in it may no longer be current

  2. #2
    Senior Moderator - FMT Preferred Developer Consultant - New York - Worldwide AHunter3's Avatar
    Join Date
    Aug 2006
    Posts
    11,445
    Location
    New York and Nassau County, NY, USA
    FileMaker Version
    FM 9, FM 9 Server, FM 10, FM 11, FM 11 Server, FM 12, FM 12 Developer
    OS
    Windows & Mac
    Skill Level
    Developer
    Downloads
    0
    Uploads
    0

    Re: exporting and separating repeating fields

    People keep thinking I'm exaggerating. I'm not. Don't use repeating fields for your data.

  3. #3
    FREE Member brsamuel's Avatar
    Join Date
    Jun 2008
    Posts
    193
    Downloads
    0
    Uploads
    0

    Re: exporting and separating repeating fields

    You may be able to do a Search & Replace to exchange the "box" character. Try to copy the character, then paste it into Excel's Search & Replace dialogue box.

  4. #4
    FREE Member
    Join Date
    Sep 2009
    Posts
    14
    Location
    N. Hollywood, CA
    FileMaker Version
    FM 9
    OS
    Windows
    Skill Level
    Novice
    Downloads
    0
    Uploads
    0

    Re: exporting and separating repeating fields

    You're right - repeating fields are no bueno! I found a solution with a bit more digging.

    Thanks

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Separating number string to individual single digit fields
    By RohanBar in forum FileMaker Pro 11
    Replies: 3
    Last Post: 11-11-2012, 01:33 PM
  2. Exporting repeating fields into Excel?
    By ghostwriter11 in forum Microsoft Office & FileMaker
    Replies: 1
    Last Post: 10-16-2006, 08:03 PM
  3. Importing/Separating Repeating Fields
    By bnibe in forum FileMaker Pro 7.0
    Replies: 0
    Last Post: 04-27-2005, 02:02 PM
  4. Exporting Records to html/excel w repeating fields
    By familytrail in forum Older Versions of FileMaker Pro
    Replies: 1
    Last Post: 04-29-2003, 12:44 PM
  5. Exporting Records to html/excel w repeating fields
    By familytrail in forum Older Versions of FileMaker Pro
    Replies: 1
    Last Post: 04-29-2003, 12:40 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Welcome to the Original FileMaker Forum
With designated forums for almost every FileMaker topic...FileMaker Today is a free-to-join community where you can boost your FileMaker expertise, build better solutions and solve your technical challenges. If you're building FileMaker solutions, this is the place for you.
Follow FMT
We Are FMT
FMT is home of The World's leading FileMaker News Site, Worldwide Developer Directory, FileMaker Connect Community and so much more.