This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
on 02-01-201801:17 PM - edited on 03-08-201901:15 PM by SydneyF
Most people are familiar with the use of scientific notation, which provides a convenient way of representing very large number. This notation can be expressed in several ways, so that a number like 5,230,000,000 can be written as 5.23. Often this is condensed even further using the E notation (common in programming languages), so that 5,230,000,000 can be written as 5.23e9 or 5.23E9.
However, this notation can also be represented with a d or D instead of an e or E. The “D” notation is common to Fortran implementations and generally represents double precision numbers. This notation is much less common than the E notation, but Alteryx does recognize it.
Text Input Tool
So why is this important? It is worth keeping this in mind if you are working with strings such as Unique Identifiers or Address data. This may seem easy to spot (the picture above simply converts this notation into the decimal representation of the number). However, if the string were 4D-585 (That's 585 decimal places), as opposed to the 1D-003, the precision of that number would cause the Text Input Tool to hang up.