AnsweredAssumed Answered

Transfer sections of text from a word document to Filemaker Pro fields

Question asked by RC1 on Apr 25, 2011
Latest reply on May 4, 2011 by RC1

Title

Transfer sections of text from a word document to Filemaker Pro fields

Post

Hello,

I have a large word document with over 3,000 pages. It is a log with daily entries with a date to start each day and below the date are multiple segments with text, each starting with the designation, “DVD.”

Word Document Example:

04/06/2011

DVD

-The Daily Show

Billy Crystal

-The Colbert Report

Lady Gaga

DVD

-WH Obama

Apr 6, 2011 

Program ID 298870-1

Category

Public Affairs Event

Format

Interview

Location

Washington, District of Columbia, United States

Date Aired

Apr 6, 2011

04/07/2011

DVD

-CBS News

 

-MSNBC News

 

DVD

CNN News

I would like to transfer specific text sections from the Word document into FileMaker Pro records.

Each “DVD” entry with the text below would go into a separate FileMaker Pro record, into the field named “Description” and it’s designated date (the date preceding it) would be put into the filed named ”Date” of the record.

So from the above word document example, the following FileMaker Pro records would be as follows:

Record 1 would have:

Date field:

04/06/2011

Description field:

DVD

-The Daily Show

Billy Crystal


-The Colbert Report

Lady Gaga

_________________________________

Record 2 would have:

Date field:

04/06/2011

Description field:

DVD

-WH Obama

Apr 6, 2011 

Program ID 298870-1

Category

Public Affairs Event

Format

Interview

Location

Washington, District of Columbia, United States

Date Aired

Apr 6, 2011

 _________________________________

Record 3 would have:

Date field:

04/07/2011 

Description field:

DVD

-CBS News


-MSNBC News

_________________________________

Record 4 would have:

Date field:

04/07/2011

Description field:

DVD

CNN News


(each date is highlighted in a purple color in the word document)

Is this possible to do in some sort of automated way (not manually by cutting and pasting) and how would I do that?

I read something about a plug-in called 360Works Scribe but don't realy know anything about it.

Thank you very much for anyone’s help on this!

Outcomes