In Sparkflows, we can use the “Multi Regex Extractor” processor to achieve this. Processor needs to be configured as below and it would extract the currency part.
To use the “Multi Regex Extractor” Processor:
Select the column in ‘InputColumnNames’ that contains the data. In this case we can select the column name that contains the amount data.
Specify output column name in ‘OutputColumnNames’ that would list the output data.
Specify the Regex pattern in ‘Patterns’ that would be used to extract data. Extracted data would be listed under the output column. In this case we can enter a pattern as ‘\w{0,3}’ this would extract the currency part from the data.
For more information read the Sparkflows Documentation here:
Hey Chris,
In Sparkflows, we can use the “Multi Regex Extractor” processor to achieve this. Processor needs to be configured as below and it would extract the currency part.
To use the “Multi Regex Extractor” Processor:
Select the column in ‘InputColumnNames’ that contains the data. In this case we can select the column name that contains the amount data.
Specify output column name in ‘OutputColumnNames’ that would list the output data.
Specify the Regex pattern in ‘Patterns’ that would be used to extract data. Extracted data would be listed under the output column. In this case we can enter a pattern as ‘\w{0,3}’ this would extract the currency part from the data.
For more information read the Sparkflows Documentation here:
https://docs.sparkflows.io/en/latest/user-guide/data-preparation/parse.html?highlight=multi%20regex%20extractor#multi-regex-extractor