Print Page - Criteria to search for a text string

Title: Criteria to search for a text string
Post by: Andrew Carrick on February 25, 2011, 10:28:52 AM

I want to search all Customer names for those with "Trust" in them, can somebody remind me what the Extra Criterion is for a string search? TIA

Title: Re: Criteria to search for a text string
Post by: Hans Manhave on February 25, 2011, 11:01:00 AM

ATC("Trust",ins.name)>0

This is a FoxPro reporting function. More FoxPro functions can be found from here:

http://msdn.microsoft.com/en-US/library/h0zw37w7(v=VS.80).aspx

Logic being that if it returns non-zero, it exists. Doesn't matter where it exists. Similar to the FIND() function in Excel.

Title: Re: Criteria to search for a text string
Post by: Andrew Carrick on February 25, 2011, 11:09:37 AM

Thanks Hans.

Title: Re: Criteria to search for a text string
Post by: Ian Blundell on February 25, 2011, 12:16:45 PM

You can also use
"Trust"$Ins.name

Title: Re: Criteria to search for a text string
Post by: Andrew Carrick on February 27, 2011, 12:19:19 PM

Thanks Ian.

Applied Users Forums

General Topics => Helpline => Topic started by: Andrew Carrick on February 25, 2011, 10:28:52 AM