Data parsing expectations
- Data can be expressed as either "e" or "E", for example, "7.1e20" and "7.1E20 are both accepted.
- Positive exponents can have or omit the "+" sign, for example "1.314E+1" and "1.314E1" are both accepted.
To accept E-Notation from the input, toggle the E-Notation toggle on the Input Schema.
The following table shows examples of the input and the output:
| Input | Output |
|---|---|
| 1.234567890E9 | 1234567890 |
| 1.2E1 | 12 |
| 1.2E1 | 12 |
| 1.2E1 | 12 |
| 1.201E1 | 12.01 |
| 1.21E1 | 12.1 |
| 1.22345678991E10 | 12234567899.1 |
| 1.234E1 | 12.34 |
| 1.234E2 | 123.4 |
| 1.234E3 | 1234 |
| 1.2340E4 | 12340 |
| 1.23400E5 | 123400 |
| -1.234E1 | -12.34 |
| -1.234E0 | -1.234 |
| -1.234E-1 | -.1234 |
| -1.234E-2 | -.01234 |
| -1.234E-3 | -.001234 |
| 5.2E-4 | .00052 |
| 0000.000054 | .000054 |
| 0.052 | .052 |
| 1.23 | 1.23 |
| 2222.356 | 2222.356 |