Manuals/calci/REMOVENUMBERS

Revision as of 15:12, 22 February 2019 by Devika (talk | contribs) (→‎Examples)
REMOVENUMBERS(String)


  • is the string from which numbers are to be removed.


Description

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


Examples

  1. REMOVENUMBERS("abc123") = abc
  2. REMOVENUMBERS("House Number 4566") = HouseNumber
  3. REMOVENUMBERS("how are you?") = howareyou?
  4. REMOVENUMBERS("1***%%%1") = ***%%%
  5. REMOVENUMBERS("67a895") = a

Related Videos

GESTEP

See Also

References

String