Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!newsfeed.tele2net.at!aioe.org!.POSTED!not-for-mail
From: Helpful Harry <HelpfulHarry@BusyWorking.com>
Newsgroups: comp.databases.filemaker
Subject: Re: Filemaker - sorting
Date: Mon, 23 Feb 2015 08:54:39 +1300
Organization: Aioe.org NNTP Server
Lines: 42
Message-ID: <230220150854399780%HelpfulHarry@BusyWorking.com>
References: <89ec3722-5afd-4f2a-8a25-80fe64981d82@googlegroups.com> <6d152$54e51a54$52d9780b$41805@news.ziggo.nl> <4a033d70-c3fd-4af0-8032-9caa631d3ae4@googlegroups.com> <b4f66$54e5257b$52d9780b$22726@news.ziggo.nl> <d8348a80-09e3-4c88-8dcf-077f25c8e70f@googlegroups.com> <1m03jx7.1xq6d774g07b1N%dempson@actrix.gen.nz> <614e3a6f-30cd-4e35-8a10-eb1a6492f37b@googlegroups.com> <1m03o0y.kb988mtm6xi9N%dempson@actrix.gen.nz> <e235bb69-7dae-4489-8e89-8dd0c5c9c2bc@googlegroups.com>
NNTP-Posting-Host: u/tpd5b4NRgx14qbELVqwg.user.speranza.aioe.org
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Complaints-To: abuse@aioe.org
User-Agent: Thoth/1.5.4 (Carbon/OS X)
X-Notice: Filtered by postfilter v. 0.8.2
Xref: csiph.com comp.databases.filemaker:2012

In article <e235bb69-7dae-4489-8e89-8dd0c5c9c2bc@googlegroups.com>,
<viking.1943@hotmail.com> wrote:
> 
> Is there anyone out there who can do some programming and write something
> that will enable me to do something that the basic Filemaker program
> apparently does not have any provision for?
> 
> I want to establish a new field, that is not a problem, but the only present
> way to put information in that field is to type it in, so if there are 50,000
> records it has to be done 50,000 times. Very impractical. I would like to be
> able to do it with one command, such as replace '    ' with 'abcd' next xxxx
> number of lines. 
> 
> In Filemkaer now you can go to the edit command and then go to "find, 
> replace" and this can be accomplished. HOWEVER you need to have something to
> find for it to be replaced. I want to be able to enter something where 
> nothing presently exists only I want to do it many times.  


1.  Create the new field as a Calculation field and set the 
    calculation as whatever text you want.
    i.e.
            NewField     (Calculation, Text Result)
                = "MyTextHere"

2.  Click the OK buttons to close all of the create field 
    windows until you are back at your usual FileMaker layout
    window. FileMaker will create the field with and 
    automatically enter the "MyTextHere" data for each
    record.

3.  Go back into the create fields window and change
    NewField to be a normal Text field (instead of a 
    Calculation field).

4.  Click the OK buttons to close all of the create field
    windows until you back at your usual FileMaker layout
    window. FileMaker will retain the calculated data 
    "MyTextHere" in NewField in each record.


Helpful Harry  :o)