Difference between revisions of "Manuals/calci/EXTRACTTEXT"
Jump to navigation
Jump to search
(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...") |
|||
| Line 17: | Line 17: | ||
#EXTRACTTEXT(67895) = (No text. Hence no output) | #EXTRACTTEXT(67895) = (No text. Hence no output) | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|v=qJQHU51xW50|280|center|Text}} | ||
==See Also== | ==See Also== | ||
Latest revision as of 15:06, 21 March 2019
EXTRACTTEXT(string)
- is the string from which you want to extract text.
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
- EXTRACTTEXT("abc123") = abc
- EXTRACTTEXT("House Number 4566") = HouseNumber
- EXTRACTTEXT("how are you?") = howareyou?
- EXTRACTTEXT("1***%%%1") = ***%%%
- EXTRACTTEXT(67895) = (No text. Hence no output)
Related Videos
See Also
References