Manuals/calci/DIFFERENCE - Revision history

Devika: /* See Also */

2018-12-11T20:59:22Z

Devika at 20:10, 18 May 2017

2017-05-18T20:10:45Z

Jayaram at 06:31, 30 March 2017

2017-03-30T06:31:40Z

Jayaram: Created page with "
'''DIFFERENCE(GivenSet1,GivenSet2)'''

*where $GivenSet1,GivenSet2$ are the arrays for which difference is to be found. ==Des..."

2017-03-30T06:31:19Z

Created page with "<div style="font-size:30px">'''DIFFERENCE(GivenSet1,GivenSet2)'''</div><br/> *where <math>GivenSet1,GivenSet2</math> are the arrays for which difference is to be found. ==Des..."

New page

<div style="font-size:30px">'''DIFFERENCE(GivenSet1,GivenSet2)'''</div><br/>
*where <math>GivenSet1,GivenSet2</math> are the arrays for which difference is to be found.

==Description==
*This function computes the difference of the two arrays.
*Function compares GivenSet1 array against GivenSet2 array and returns the values in GivenSet1 that are not present in the other array.
*DIFFERENCE function will consider text, numbers, or any special characters like @,&...
*Input other than numbers should be given in quotes.

==Examples==
#DIFFERENCE([1,2,3,4,5,0],[5,6,7,1,"a",8]) = 2 3 4 0
#DIFFERENCE(["@","&","*"],["@","&","*"]) = ''
#DIFFERENCE([1,2,3,"a","@","&","*"],["@","&","*"]) = 1 2 3 a

← Older revision		Revision as of 20:10, 18 May 2017
Line 12:		Line 12:
	#DIFFERENCE(["@","&",""],["@","&",""]) = ''		#DIFFERENCE(["@","&",""],["@","&",""]) = ''
	#DIFFERENCE([1,2,3,"a","@","&",""],["@","&",""]) = 1 2 3 a		#DIFFERENCE([1,2,3,"a","@","&",""],["@","&",""]) = 1 2 3 a
		+
		+	==See Also==
		+	*[[Manuals/calci/DISTINCT\| DISTINCT]]
		+	*[[Manuals/calci/DISTINCTSET\| DISTINCTSET]]
		+
		+	==References==
		+	*[https://www.w3schools.com/sql/sql_distinct.asp Difference]
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+	*[[ Z3 \| Z3 home ]]

@@ Line 12: / Line 12: @@
 #DIFFERENCE(["@","&","*"],["@","&","*"]) = ''
 #DIFFERENCE([1,2,3,"a","@","&","*"],["@","&","*"]) = 1 2 3 a
 ==See Also==

@@ Line 7: / Line 7: @@
 *DIFFERENCE function will consider text, numbers, or any special characters like @,&...
 *Input other than numbers should be given in quotes.
 ==Examples==

Manuals/calci/DIFFERENCE - Revision history

Devika: /* See Also */

Devika at 20:10, 18 May 2017

Jayaram at 06:31, 30 March 2017

Jayaram: Created page with "'''DIFFERENCE(GivenSet1,GivenSet2)''' *where GivenSet1,GivenSet2 are the arrays for which difference is to be found. ==Des..."

Jayaram: Created page with "
'''DIFFERENCE(GivenSet1,GivenSet2)'''

*where $GivenSet1,GivenSet2$ are the arrays for which difference is to be found. ==Des..."