Manuals/calci/REMOVETEXT

From ZCubes Wiki
Revision as of 04:07, 1 June 2017 by Swapna (talk | contribs) (Created page with "<div style="font-size:30px">'''REMOVETEXT(string)'''</div><br/> *<math>string</math> is the string from which text is to be removed. ==Description== *REMOVETEXT is used to...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
REMOVETEXT(string)


  • is the string from which text is to be removed.


Description

  • REMOVETEXT is used to remove text from the entered string.
  • can be a combination of characters, text, numbers etc. entered in double quotation marks.


Examples

  1. REMOVETEXT("abc123") = 123
  2. REMOVETEXT("House Number 4566") = 4566
  3. REMOVETEXT("how are you?") = (all text removed. hence blank output)
  4. REMOVETEXT("1***%%%1") = 11
  5. REMOVETEXT("67a895") = 67895


See Also


References

String