Search In multiple fields 1

[ajr1705]

I am trying to write a formula so that it searches through
Multiple fields to find values in address fields.

I want use the formula to extract only these that meet the selection.

E.g.
Fields are say add1, add2, add3 etc

I want to search for the string "GAHANA" or "ENGLAND", this could be in upper or lower case.
I would also like to may be take the first 3 digit and compare that.

Any help would most appreciated

 

[Turkbear]

Hi,
If the # of fields is known then just create a test for each field something like:

(
UPPERCASE({add1}) like '*GAHANA*' or UPPERCASE({add1}) startswith  'GAH'
)
OR 
(
UPPERCASE({add1}) like '*ENGLAND*' or UPPERCASE({add1}) startswith  'ENG'
)

Repeat as needed for each possible field..

Then get the design changed..



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

It searches and does what? Highlights them, filters the rows to only those found, or?

You can use the record selection formula with a LIKE predicate, such as:

{table.add1} like "*" + {?MyParameter}
or
{table.add2} like "*" + {?MyParameter}
or
{table.add3} like "*" + {?MyParameter}

Which would limit the rows returned to the report to those which had that text within one of those fields.

-k

 

[synapsevampire]

Ooops, you should use:

{table.add1} like "*" + {?MyParameter} + "*"
or
{table.add2} like "*" + {?MyParameter} + "*"
or
{table.add3} like "*" + {?MyParameter} + "*"

-k