To extract the specific numbers before the phrases “-firm paid”, “-bank”, and “-firm paid 555” in Alteryx, you can use regular expressions (regex). Here’s how you can achieve this:
Extracting Numbers Before “-firm paid”:
Use the Regex Tool in Alteryx.
Set the Regular Expression to: .*-(\d+)-firm paid.*
Select the Parse option for output.
This will extract the numbers before the phrase “-firm paid” from your description column.
Extracting Numbers Before “-bank”:
Similarly, use the Regex Tool.
Set the Regular Expression to: .*-(\d+)-bank.*
Again, select the Parse option for output.
This will extract the numbers before the phrase “-bank” from your description column.
Extracting Numbers Before “-firm paid 555”:
Once more, use the Regex Tool.
Set the Regular Expression to: .*-(\d+)-firm paid 555.*
Choose the Parse option for output.
This will extract the numbers before the phrase “-firm paid 555” from your description column.
Remember to adjust the column names and field names according to your Alteryx workflow. Happy data wrangling! 🚀
Also, you can combine all three conditions into a single regular expression. Here’s how you can do it:
.*-(\d+)-(firm paid|bank|firm paid 555).*
Explanation:
.* matches any characters (except newline) zero or more times.
-(\d+) captures one or more digits after a hyphen.
(firm paid|bank|firm paid 555) matches either “firm paid”, “bank”, or “firm paid 555”.
The entire expression extracts the numbers before any of these phrases in your description column.
Feel free to use this combined regex in your Alteryx workflow! 🎉
