Re: Help with extracting text

Path	csiph.com!usenet.pasdenom.info!news.albasani.net!.POSTED!not-for-mail
From	Martin Τrautmann <t-usenet@gmx.net>
Newsgroups	comp.databases.filemaker
Subject	Re: Help with extracting text
Date	Wed, 21 Mar 2012 16:42:30 +0000 (UTC)
Organization	slrn user
Lines	33
Message-ID	<slrnjmk17m.lv.t-usenet@ID-685.user.individual.de> (permalink)
References	<f23e7788-f858-48ce-925a-29b1cdd318c2@fk28g2000vbb.googlegroups.com>
Reply-To	traut@gmx.de
X-Trace	news.albasani.net 63ort3vRA0Rf02E8UtS+jyGrwBvUfK24lMjGLUXus3B9CjmEHr0aU/+kguSnhBXb1A4+L4gBjQWCaqIXDLltxm+P+xi0cwk07hGj494UMWFZlWzrOp2kqLdEPWh5Q9fw
NNTP-Posting-Date	Wed, 21 Mar 2012 16:42:30 +0000 (UTC)
Injection-Info	news.albasani.net; logging-data="4uXYD7nEWu8rIH4LgchbVSWYnUmjSuHY/9r10hlP2tPav1Bhs1pp/8JvSbjQkOOlafAuXEIYANgbJucrgvAnogy1K5FTsRBRMviC/aI+SfZdXccfY25SM0Kg7bRTP8ez"; mail-complaints-to="abuse@albasani.net"
User-Agent	slrn/pre1.0.0-18 (Darwin)
X-No-Archive	Yes
Cancel-Lock	sha1:7NIXKEP1ea5e3CkdFrPvSOiqHtc=
Xref	csiph.com comp.databases.filemaker:686

Show key headers only | View raw

On Wed, 21 Mar 2012 09:33:09 -0700 (PDT), JayBee wrote:
>  How can I extract the text description bit?  Is there a way to do
>  this?
>  e.g. 01 and 02 are checked then another scripted button is clicked and
>  the words, apple and banana are copied to my other specified field.

simple solution:

middle(text,4,999)

basic solution:

middlewords(text,2,999)
... may fail on trailing non-characters (dot, brackets etc.)

more flexible solution:

trim(middle(text,position(text,right(abs(text+0),1,1)+1,999))
... will look for the last number within the text and will take the text
after.

I may tell you examples where each of those may fail - e.g. the last one
on

  2.20 red bananas

>  Hope you can help.
>  I'm working towards an awesome solution!

I don't know why you want to split something that is already available
within different fields.

- Martin

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

RE: Help with extracting text JayBee <Jennifer_Beecroft@hotmail.com> - 2012-03-21 09:33 -0700
  Re: Help with extracting text Martin Τrautmann <t-usenet@gmx.net> - 2012-03-21 16:42 +0000
    Re: Help with extracting text HelpfulHarry@BusyWorking.com (Helpful Harry) - 2012-03-22 11:24 +1200
  Re: Help with extracting text HelpfulHarry@BusyWorking.com (Helpful Harry) - 2012-03-23 13:14 +1200
    Re: Help with extracting text JayBee <Jennifer_Beecroft@hotmail.com> - 2012-03-23 02:42 -0700
    Re: Help with extracting text JayBee <Jennifer_Beecroft@hotmail.com> - 2012-03-23 02:47 -0700
      Re: Help with extracting text HelpfulHarry@BusyWorking.com (Helpful Harry) - 2012-03-24 12:08 +1200
        Re: Help with extracting text Howard Schlossberg <howard@nospam.fmprosolutions.com> - 2012-03-23 20:28 -0700
          Re: Help with extracting text HelpfulHarry@BusyWorking.com (Helpful Harry) - 2012-03-24 16:45 +1200
        Re: Help with extracting text Martin Τrautmann <t-usenet@gmx.net> - 2012-03-24 05:41 +0000
          Re: Help with extracting text Howard Schlossberg <howard@nospam.fmprosolutions.com> - 2012-03-24 10:15 -0700
            Re: Help with extracting text HelpfulHarry@BusyWorking.com (Helpful Harry) - 2012-03-25 09:40 +1200

csiph-web