Parsing dollar amount (comma vs no comma separator)

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

Moderator: Mr_Noodle

I just upgraded to the v5 Hazel thinking that I needed to start using lists and tables to solve for this. I can not figure out how to solve this.

I need to parse a PDF statement that has a value which sometimes is the hundreds and other times in the thousands. The difference is that the thousands value has the comma "," as a separator (1,903). In the instance where the value is in the hundreds, no comma.

Any idea of how to get this to work would be appreciated.

Comma (thousands) sample:
https://www.screencast.com/t/SSdFmtvjjoj

Non-comma sample:
https://www.screencast.com/t/s0PikOVql

The pattern I have defined that works for me for the thousands (comma) sample:
https://www.screencast.com/t/mgTFh7Zsu
iSilentP
 
Posts: 5
Joined: Sat Jun 02, 2012 1:48 pm

For now, you'll have to use separate patterns to match each case. I'll consider having options in the future where it can handle thousands separators.
Mr_Noodle
Site Admin
 
Posts: 11255
Joined: Sun Sep 03, 2006 1:30 am
Location: New York City

Thanks for the reply. I'll stop pounding my head against the wall---for now.
iSilentP
 
Posts: 5
Joined: Sat Jun 02, 2012 1:48 pm


Return to Support