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.