Manuals/calci/EXTRACTTEXT

From ZCubes Wiki
Revision as of 14:06, 21 March 2019 by Devika (talk | contribs) (→‎Examples)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
EXTRACTTEXT(string)


  • is the string from which you want to extract text.


Description

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


Examples

  1. EXTRACTTEXT("abc123") = abc
  2. EXTRACTTEXT("House Number 4566") = HouseNumber
  3. EXTRACTTEXT("how are you?") = howareyou?
  4. EXTRACTTEXT("1***%%%1") = ***%%%
  5. EXTRACTTEXT(67895) = (No text. Hence no output)


Related Videos

Text

See Also


References

String