Views:

Description

Compares both strings and returns any missing pattern(s) of the 1st string. 

Signature

MatchListFindMissing('matchstring1','matchstring2')

Example 1

MatchListFindMissing('aaa,bbb,ccc,ddd,eee', 'eee,fff')
 Returns 'aaa,bbb,ccc,ddd'   

Example 2

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

Example 3

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

Example 4

MatchListFindMissing('', '')  Returns '?' 

Example 5

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

Parameters

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