Difference between revisions of "Using Sounds Like Criteria in Reports"

From SmartWiki
Jump to: navigation, search
Line 1: Line 1:
 +
{{SeqReportPageHeader}}
 +
 
You can use sounds like criteria within a report to find values that are similar phonetically to the value entered. This uses the '''[http://en.wikipedia.org/wiki/Soundex soundex]''' phonetic algorithm feature.
 
You can use sounds like criteria within a report to find values that are similar phonetically to the value entered. This uses the '''[http://en.wikipedia.org/wiki/Soundex soundex]''' phonetic algorithm feature.
  

Revision as of 13:39, 26 April 2013

caption Click here to watch a video on SmartSimple's integrated reporting subsystem.

You can use sounds like criteria within a report to find values that are similar phonetically to the value entered. This uses the soundex phonetic algorithm feature.

  • In the Calculated Field you should enter:
soundex([this])
  • And in the Criteria:
=soundex(???)

Soundex.png

The column with this syntax is not normally displayed in the report, as it will display the soundex phonetic representation of the value rather than the word.

Note:

  • The Soundex function is intended to work well with strings that are in the English language only. Strings in other languages may not produce reliable results.
  • Soundex may not provide consistent results with strings that use multi-byte character sets, including UTF-8.




Previous.png Using Wildcard Criteria in Reports Specifying Multiple Criteria in Reports

Next.png

Retrieved from ‘https://wiki.smartsimple.com/index.php?title=Using_Sounds_Like_Criteria_in_Reports&oldid=13771’