Extract Numbers

Description

This activity extracts numerical values from a given text column based on user-specified transformations.

Input

Data only

Output

Transformed data

Configuration Fields

• Column Specifies the column containing text data from which numbers will be extracted.
• Extract Mode Defines the mode used to extract numbers.
  • Options
    1. Several Extract multiple numbers separately.
    2. JSON Array Extract numbers as a JSON array.
    3. Expand Notation Converts numbers with notation (e.g., 1K to 1000).
    4. Decimal Separator Specifies decimal representation.
• Output Column Specifies the column where the extracted numbers will be stored.
• Include Original
  • Enabled Includes the original column in the output.
  • Disabled Includes only the transformed columns in the output.
• Separator Specifies the character to separate extracted values.(rendered for Decimal separator mode)

Sample Input

Transaction Details
Order #1234, Amount: $45.67
Invoice 56789 - $120.50
Product ID: 998, Price: $30.00

Sample Configuration

Sample Output

Transaction Details	Extracted Numbers_1	Extracted Numbers_2
Order #1234, Amount: $45.67	1234	45.67
Invoice 56789 - $120.50	56789	120.50
Product ID: 998, Price: $30.00	998	30.00

---