Page 1 of 1

Read any dollar amount

PostPosted: 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.

Re: Read any dollar amount

PostPosted: 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.

Re: Read any dollar amount

PostPosted: 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.

Re: Read any dollar amount

PostPosted: Tue Nov 12, 2019 11:06 am
by Mr_Noodle
I'll look into adding more number matching options, like recognizing thousands separators.

Re: Read any dollar amount

PostPosted: 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!