Re: Help with extracting text

From	JayBee <Jennifer_Beecroft@hotmail.com>
Newsgroups	comp.databases.filemaker
Subject	Re: Help with extracting text
Date	2012-03-23 02:47 -0700
Organization	http://groups.google.com
Message-ID	<4b8c5df0-d5a3-4c8c-b18a-dcb6b285c2e0@fk28g2000vbb.googlegroups.com> (permalink)
References	<f23e7788-f858-48ce-925a-29b1cdd318c2@fk28g2000vbb.googlegroups.com> <HelpfulHarry-2303121314060001@203-118-187-217.dsl.dyn.ihug.co.nz>

Show all headers | View raw

I mean Harry I tried the code you gave me last time for my checkbox
set field:

  WordsOnly      Calculation, Text Result, Unstored
   = Trim(
       Substitute(
         Substitute(
            Substitute(
              Substitute(
                Substitute(
                  Substitute(
                    Substitute(
                      Substitute(
                        Substitute(
                          Substitute(
                            Substitute(TextField; "0"; "");
                            "1"; "");
                          "2"; "");
                        "3"; "");
                      "4"; "");
                    "5"; "");
                  "6"; "");
                "7"; "");
             "8"; "");
           "9"; "");
         "R "; "R")
       )

and the result was empty in the target field, so my 'testfield1' and
'ctestfield2' were me trying to understand it in it's simplest form to
see if it would help me to get it to work for my checkbox set field.

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