Manuals/calci/DUPLICATE

From ZCubes Wiki
Revision as of 06:37, 2 May 2017 by Swapna (talk | contribs) (Created page with "<div style="font-size:30px">'''DUPLICATE(Thing,Times,BreakEvery,Delimiter)'''</div><br/> *<math>Thing</math> is the text or number or array that needs to be duplicated *<math...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
DUPLICATE(Thing,Times,BreakEvery,Delimiter)


  • is the text or number or array that needs to be duplicated
  • is the number of times to duplicate
  • is the point at which the string or array breaks
  • is the text or number or character that follows every number

Description

  • This function is used to duplicate the string or text for mentioned number of times.
  • The text can be broken at specific count.
  • Argument can be text, numbers, or any special characters like @,&...
  • is the number greater than zero. If not specified, '1' is considered as default.


Examples

  • DUPLICATE("DUPLICATE")=DUPLICATEDUPLICATE
  • DUPLICATE(5,8)=55555555
  • DUPLICATE(3,8,2)=33 33 33 33
  • DUPLICATE(3,8,2,"$")=3$3$ 3$3$ 3$3$ 3$3$


Related Videos

Repeat formula


See Also


References