Read any dollar amount

Get help. Get answers. Let others lend you a hand.

Moderator: Mr_Noodle

Read any dollar amount Sat Nov 09, 2019 8:09 pm • by gacorrea
I'm trying to process several brokerage statements and read the account value at the end of the month.

I have already figured out how to read figures that are between $1,000.00 and $999,999.99. In other words, dollar amounts that have one comma and a decimal period.

But some statements include amounts that exceed $999,999.99 (i.e, they will contain two commas and one period).

Is there a way to read dollar amounts of any amount (just as Hazel can read dates of any format)?

Or need I create 3 separate rules:
(1) a 1st rule for amounts up to $999.99
(2) a 2nd rule for amounts up to $999,999.99; and
(3) a 3rd rule for amounts up to $999,999,999.99?

Thanks.
gacorrea
 
Posts: 4
Joined: Fri Oct 14, 2016 10:39 pm

Re: Read any dollar amount Mon Nov 11, 2019 11:33 am • by Mr_Noodle
In this case, you may need a separate patterns. Note that you can include these in separate conditions, but all in the same rule. Look up "nested conditions" in the help.
Mr_Noodle
Site Admin
 
Posts: 8197
Joined: Sun Sep 03, 2006 1:30 am
Location: New York City

Re: Read any dollar amount Mon Nov 11, 2019 5:57 pm • by gacorrea
Mr_Noodle wrote:In this case, you may need a separate patterns. Note that you can include these in separate conditions, but all in the same rule. Look up "nested conditions" in the help.


Thank you Mr. Noodle. What would obviate all this would be if Hazel had the ability to recognize dollar amounts into a user-named variables, just as Hazel can recognize dates in differing formats. And if Hazel were able to do so, the ability to then write the numeric contents of that variable to a user-defined text file would be extremely useful.

FYI, what I am ultimately trying to do is get a dollar amount in a pdf file posted automatically to an Excel file.
gacorrea
 
Posts: 4
Joined: Fri Oct 14, 2016 10:39 pm

Re: Read any dollar amount Tue Nov 12, 2019 11:06 am • by Mr_Noodle
I'll look into adding more number matching options, like recognizing thousands separators.
Mr_Noodle
Site Admin
 
Posts: 8197
Joined: Sun Sep 03, 2006 1:30 am
Location: New York City

Re: Read any dollar amount Tue Nov 12, 2019 1:41 pm • by gacorrea
Mr_Noodle wrote:I'll look into adding more number matching options, like recognizing thousands separators.


That would be fabulous! I bet scores of users would benefit. Thank you!
gacorrea
 
Posts: 4
Joined: Fri Oct 14, 2016 10:39 pm


Return to Support