Number.*

Power Query Number.* column expressions.

class fabrictools.powerquery.number.Number[source]

Bases: object

Namespace for Power Query Number.* functions.

static FromText(expr: pyspark.sql.Column | str) → pyspark.sql.Column[source]

Convert text to a nullable number with US/FR decimal rules (Power Query Number.FromText).

Implements the invoicing script fxToNumber logic: strips non-numeric characters, detects thousand separators vs decimal comma/point, and parses accordingly.

Parameters:: expr (Column | str) – Spark column or string literal.
Returns:: Nullable double column expression.
Return type:: Column

Example

>>> from fabrictools import Table, Number
>>> df = Table.TransformColumns(df, [
...     ("Total Invoice amount without VAT", Number.FromText),
... ])