Search amounts in database dumps

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

CRAIGER
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.

Example:
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,

Craig

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

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 ) ]
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


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

Who is online

Users browsing this forum: Google [Bot] and 1 guest