Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #2310

Re: Finding Numbers in Text Fields

Show all headers | View raw

Charles H. Sampson schreef op 6-5-2015 om 19:42:
> The tutorial for the day is on finding strings of digits in text fields.
> If I simply use the string of digits as the search value I invariably
> get the "No records match this set of find requests." message. I guessed
> that enclosing the string of digits in quotes ("123") would do it.
> Sometimes it does, usually it doesn't.
>
> I just want to know what the technique is. I don't expect it to make
> sense. As a long-time system software developer (mostly compilers, some
> operating systems), I know that searching for any string in a text field
> should search for that string, the only exceptions being characters that
> have special meaning. I suspect that FileMaker is making the mistake of
> converting the string ot digits into internal numeric form (often called
> binary) and searching to that value in the field, which will almost
> never succeed.
>
> Charlie
>
You have to work around that. Perhaps using a patterncount function.

text= abc123def
findstring = "123"
cfind = patterncount (text , findstring) result as number
if cfind greater 0 you have a match

Ursus

-- 
met vriendelijke groeten,
Erik Appeldoorn

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

Thread

Finding Numbers in Text Fields csampson@inetworld.net (Charles H. Sampson) - 2015-05-06 10:42 -0700
  Re: Finding Numbers in Text Fields Martin Τrautmann <t-usenet@gmx.net> - 2015-05-06 17:53 +0000
  Re: Finding Numbers in Text Fields Howard Schlossberg <howard@nospam.fmprosolutions.com> - 2015-05-06 12:02 -0700
    Re: Finding Numbers in Text Fields csampson@inetworld.net (Charles H. Sampson) - 2015-05-08 02:28 -0700
  Re: Finding Numbers in Text Fields Erik Appeldoorn <ursus.kirk@gmail.com> - 2015-05-06 21:52 +0200

csiph-web