Re: Exporting Text field line entries to individual records

In article
<10405d52-fb1f-4a67-a7e7-fcac940d3fc9@xxxxxxxxxxxxxxxxxxxxxxxxxxx>,
"Teresa K." <teresa.kabourek@xxxxxxx> wrote:

FMPro V6.04
Windows XP

Been doing alot of searching on this group, and have not come up with
anything like this.

I have a text field that my people enter in all their software code
that is affected by work on a Software Problem (SP). The SP has it's
own unique control number.
--------------------------------------------
EXAMPLE

SP: 221705
Field Name: Module_Affected
type: Text

Stuff that is entered in the field, followed by a carriage return:
abc.ada
mickey.java
donald.txt
puppy.cc
--------------------------------------------

What I want to do is be able to export this text field in a manner
that I can re-import each individual filename that was entered in the
Software_code field into a child database I've established so that
each filename now is it's own record, with the SP number also being
exported in a manner that each child record will contain it as well so
that my portal will pull in the record correctly based on the SP key.

--------------------------------------------
EXAMPLE of what I need in Child-database after export/import

Record 1
SP: 221705
Module_Affected: abc.ada

Record 2
SP: 221705
Module_Affected: mickey.java

Record 3
SP: 221705
Module_Affected: donald.txt

Record 3
SP: 221705
Module_Affected: puppy.cc

--------------------------------------------

Am I asking the impossible? I just don't see a method to do with the
FMP V6.0, and haven't a clue as to other ways I can search for this
situation on this google group. I wouldn't mind doing this all
manually, except that are thousands of SP's in this database, and some
of them of hundreds of lines of code being affected by work on them.

Any and all help would be appreciated. Thanks!

- Teresa K.

Mac or PC? Really easy with Applescript. On a PC you might do it with a
calculation field that selects text between carriage returns.

Or (haven't tried this, just brainstorming): Export the text field to a
text document, then import that document to the other database. It
should treat the carriage returns as record dividers. To get the control
number to go with it you might need a calculation field that appends
that to each new entry in the text field, separated by a comma.
.

Relevant Pages

  • Re: Exporting Text field line entries to individual records
    ... calculation field that selects text between carriage returns. ... Better would be not to bother exporting them at all and have a Script that ... Funny you should write about re-organizing the original database, ...
    (comp.databases.filemaker)
  • RE: Database running over network runs extremely slow
    ... I have reports built into the database that track the entry ... you are searching (or using in your DLOOKUPs criteria parameter)? ... of the DLookups to looped recordset searches, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: How many names and addresses can you have for ID card
    ... large amount of database space, ... Searching CLOBs is thus memory and CPU-intensive, ... A directory system a la LDAP or X.500 would be a much more natural ... An entry may have any number of atrributes which are ...
    (uk.legal)
  • Re: Is there anynone who knows a chatting site or someting like this? - Face Matching
    ... and then you would search your database to find matching ... advance by searching the internet retrieving ... URL and the feature vector to your database. ... You would compare the ...
    (sci.image.processing)
  • RE: non relational database
    ... I commend you for letting the person who designed the database live - very ... In terms of splitting the strings, if each bit of data is delimited ... by a carriage return, you could write a VBA function that reads ... special character you may not be able to use it. ...
    (microsoft.public.access.modulesdaovba)