Search amounts in database dumps

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

Posts: 2
Joined: Tue Jul 24, 2007 2:25 am

Search amounts in database dumps

Postby CRAIGER » Tue Jul 24, 2007 2:36 am

I am testing to see if Textpipe Pro can help us find amounts in database dumps.

The main problem is that an amount can have different format because different international formats.

230,000.00 (normal US Format)
230.000,00 (normal EU format)
230000.00 (abbr US format)
230000,00 (abbr EU format)

Now the dump files can look like:

1001|John Doe|3902,230,000.00,10101,new york,usa|

You see the problem with the format because the comma (,) before the amount value.
Now dumps have already been made in wrong format, so I have to deal with it.

The dump format is my problem and is not what this question is about, so ignore it.

I would like a general Pattern to search for all amount formats (both EU and US, general and abbr).
But also I would like to get this to a INT (numeric value) and then compare it, so for example i can search for orders above $10,000.00 US Dollars etc.

Any help, even short, is appreciated!

Thank you,


User avatar
DataMystic Support
Site Admin
Posts: 2139
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia

Postby DataMystic Support » Tue Jul 24, 2007 4:36 pm

You could try combining 4 separate EasyPatterns:

[ ( 1+ digits or comma, period, 2 digits ) or
( 1+ digits or period, comma, 2 digits ) or
( 1+ digits, period, 2 digits ) or
( 1+ digits, comma, 2 digits ) ]

Simon Carter, - Insulin dose calculator for Type 1 diabetes - 250,000 free software downloads - send huge email attachments

Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: Baidu [Spider] and 1 guest