Trying to identify the dollar amount in a line of text

Hi - I am working to try and gather a dollar amount figure from a text string within a workflow. I have included a sample of 5 rows of text to illustrate the format of text string (see below). TRANSFER is always present, and the "(" indicates a negative number.

Alteryx example.jpg

What I am trying to achieve is having a new column with just the dollar amounts (see Output column below).

Any suggestions on modules and instructions would be greatly appreciated.

Datasets

Accepted answers

Qiu

@scott_fuller
Thank you for the additional information.
I just tried with my flow, it seems to work as it is

Keywork I am using is the sign "$" and end of digit.

All comments

binu_acs

@scott_fuller One way of doing this

Regex_09052024.yxmd

scott_fuller

Wow - thanks for such a quick reply. Does the logic work regardless of length of the dollar amount? I ask because the amount can be as little as a few million dollars to multiple billions of dollars.

When trying the solution above the new column of data was all [null]. I don't really understand what the expression is actually doing, so hard to edit to make it work.

Qiu

@scott_fuller
I noticed that there is also decimal point and also space between "(" and "$", so maybe we can try as this based on flow @binu_acs

Regex_09052024-r1.yxmd

scott_fuller

Thanks - So there is not always a "(" in the field. Perhaps there is a way to gather the data between key words.

The first word in each field is "TRANSFER" and then the bit of information I am after followed by the word "FROM". Is there a way to extract anything between those 2 words as a separate column?