Manuals/calci/EXTRACTNUMBERS

EXTRACTNUMBERS(string)

• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle string} is the string from which you want to extract numbers.

Description

• EXTRACTNUMBERS is used to extract numbers from the entered string.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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

• EXTRACTTEXT

References

String

• List of Main Z Functions

• Z3 home