Manuals/calci/EXTRACTTEXT

Revision as of 03:12, 31 May 2017 by Swapna (talk | contribs) (Created page with "<div style="font-size:30px">'''EXTRACTTEXT(string)'''</div><br/> *<math>string</math> is the string from which you want to extract text. ==Description== *EXTRACTTEXT is us...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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)


See Also


References

String