Manuals/calci/EXTRACTNUMBERS

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


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


Description

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


Examples

  1. EXTRACTNUMBERS("abc123") = 123
  2. EXTRACTNUMBERS("House Number 4566") = 4566
  3. EXTRACTNUMBERS("how are you?") = (No Output)
  4. EXTRACTNUMBERS("1***%%%1") = 11

Related Videos

Numbers

See Also


References

String