Difference between revisions of "ParseNumber"

Latest revision as of 20:10, 14 April 2018

ParseNumber(x, badVal, decimal)

It converts text «x» to a numeric value, if it has a number format (including dates or time) that is valid in Analytica. If not, e.g. ParseNumber("hello"), it returns Null, or «badVal» if specified. If «x» is already a number, it just returns the value «x».

If «x» uses a comma for the decimal point, such as "3.14", specify the «decimal» parameter to be ','. («decimal» requires Analytica 5.0)

Library

Text Functions

Example

ParseNumber('3.14') → 3.14

ParseNumber( x, x ) { Keeps cells that don't parse as text }

ParseNumber('3,14', decimal:',') → 3.14

Notes

If «x» is an array, it will try to parse each element of the array -- it fully supportsIntelligent Arrays, like most Analytica functions.

ParseNumber is often useful when reading data from flat files, using ReadCsvFile or ReadTextFile. [[ParseCSV] tries to parse numbers automatically (by default), so you don't need to use ParseNumber.

You can coerce a text to be numeric in other ways. For example, you can declare a function parameter with the qualifiers "Coerce Numeric". If the actual parameter is text, it will try to convert it to a number when it calls the function. The Number format of the variable that contains the call to the function determines how the value is interpreted. Usually, it should not be a date number format.

History

ParseNumber was introdued to Analytica 4.2 as a built-in function.
The «decimal» parameter was introduced in Analytica 5.0

@@ Line 18: / Line 18: @@
 == Notes ==
-An array can be passed, in which each cell of the array is parsed.
+If «x» is an array, it will try to parse each element of the array -- it fully supports[[ Intelligent Arrays]], like most Analytica functions.
-[[ParseNumber]] is often useful when reading data from flat files, using [[ReadCsvFile]] or [[ReadTextFile]]. You don't need to use [[ParseNumber]] when using [[ParseCSV]], since it parses it.
+[[ParseNumber]] is often useful when reading data from flat files, using [[ReadCsvFile]] or [[ReadTextFile]]. [[ParseCSV] tries to parse numbers automatically (by default), so you don't need to use [[ParseNumber]].
-Coercion to numeric can be accomplished in Analytica in other ways.  For example, you can declare a function parameter with the [[Function Parameter Qualifiers|qualifiers]] "coerce numeric".  Then a string value passed to that parameter is parsed.  The calling variable needs to have a non-date number format, since the number format of the calling object determines how the value is interpreted.
+You can coerce a text to be numeric in other ways.  For example, you can declare a function parameter with the [[Function Parameter Qualifiers|qualifiers]] "Coerce Numeric". If the actual parameter is text, it will try to convert it to a number when it calls the function.  The Number format of the variable that contains the call to the function determines how the value is interpreted. Usually, it should not be a date number format.
 ==History==
-* [[ParseNumber]] is new to [[What's new in Analytica 4.2?|Analytica 4.2]] as a built-in function, but an equivalent library function, [[ParseNum]] can be used in Analytica 4.1.
+* [[ParseNumber]] was introdued to [[What's new in Analytica 4.2?|Analytica 4.2]] as a built-in function.
 * The «decimal» parameter was introduced in [[Analytica 5.0]]