Views:

Description

Compares two strings and returns any unique matching patterns/intersects.

Signature

MatchListFindIntersect('matchstring1','matchstring2')

Example 1 

MatchListFindIntersect('aaa,bbb,ccc,ddd,eee', 'bbb,hhh')
 Returns 'bbb'

Example 2

MatchListFindIntersect('aaa,bbb,ccc,ddd,eee', 'bbb,ddd')
 Returns 'bbb,ddd'

Example 3

MatchListFindIntersect('aaa,bbb,ccc,ddd,eee', 'bbb,ddd,fff,hhh')
 Returns 'bbb,ddd'

Example 4

MatchListFindIntersect('aaa,bbb,ccc,ddd,eee', '')
 Returns '?'

Example 5

MatchListFindIntersect(
  'aaa,bbb,ccc,ddd,eee,ddd,bbb',
  'bbb,hhh,cc,aAa,aáa')
Returns  'bbb'

 

 

Parameters

Name Type Description Required
fromdate xxxx xxxx xxxx
todate xxxx xxxx xxxx
interval xxxx xxxx xxxx