Text to Numeric

Parse formatted numeric strings into proper numeric types, capturing the format metadata separately.

When to invoke

• A column contains values like $4.27, 1,234.56, €1.2M, 3.5%, (500) (accounting negative), 2.5K.
• Downstream analysis needs the column as float / int.

Procedure