Difference between revisions of "Manuals/calci/DUPLICATE"

From ZCubes Wiki
Jump to navigation Jump to search
(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...")
 
 
Line 1: Line 1:
<div style="font-size:30px">'''DUPLICATE(Thing,Times,BreakEvery,Delimiter)'''</div><br/>
+
<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>Thing</math> is the text or number or array that needs to be duplicated  
 
*<math>Times</math> is the number of times to duplicate
 
*<math>Times</math> is the number of times to duplicate

Latest revision as of 15:06, 9 August 2018

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