Description:
Delete specified members from a sequence.
Syntax:
|
A.delete(k) |
Delete the kth member. |
|
A.delete(p) |
Delete members whose sequence numbers exist in p; count backward when a member of sequence p is less than 0. |
Note:
The function deletes the kth member or the members whose sequence numbers exist in p from sequence A, and automatically updates the index, if any, and checks distinctness.
Parameter:
|
A |
A sequence. |
|
k |
A positive integer that indicates the position of a member to be deleted in the sequence. |
|
p |
An integer sequence with the length of n that specifies the positions of the members to be deleted. |
Option:
|
@n |
Return the deleted record or a record sequence of the deleted records. |
Return value:
Sequence
Example:
|
|
A |
|
|
1 |
=["a","c","d","e","f"] |
|
|
2 |
=A1.delete([2,4,5]) |
[a,d] |
|
3 |
=demo.query("select * from STUDENTS") |
|
|
4 |
=A3.delete@n(2) |
Return the deleted record.
|
|
5 |
=["a","c","d","e","f"].delete([3,-5]) |
Count backward to get the value [c,e,f] since one member of the sequence parameter is less than 0. |
Related function: