Groups | Search | Server Info | Login | Register

Groups > comp.databases.filemaker > #686

Re: Help with extracting text

Show all headers | 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