\GET.TAGS

Return all tags from the given cell.

Syntax: \GET.TAGS(reference) => array
=LAMBDA(text,
	LET(
		ct, UNICHAR(917631),
		ts, TEXTSPLIT(text,ct,,1) & ct,
		MAP(ts,LAMBDA(x,
			REDUCE("",SEQUENCE(LEN(x)),LAMBDA(acc,val,
				LET(
					v, RIGHT(LEFT(x,val),1),
					c, IF(v<>"",UNICODE(v),0),
					acc & IF(AND(c>917535,c<917631),UNICHAR(c-917504),"")
				)
			))
		))
))

Documentation

Returns a horizontal array of all tags added to the value of the cell passed in the reference.


0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Scroll to Top