PO Box Patterns

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

lg777
Posts: 7
Joined: Thu Dec 01, 2011 12:12 pm

PO Box Patterns

Postby lg777 » Thu Dec 01, 2011 12:15 pm

I need help with PO Box searches. Any combination of P.O. Box, PO BOX, P O Box, etc...

I tried some perl patterns I found on the internet and they don't work in Textpipe so maybe there's a better Easy Pattern method.

What I'm trying to do is look at an address field and if I see any mention of post office box as described above, I want to remove it.

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

Re: PO Box Patterns

Postby DataMystic Support » Fri Dec 02, 2011 12:03 pm

Can you paste the examples you found? There might be an easy fix.

A simple EasyPattern would be:

Code: Select all

[ ('P O' or 'PO' or 'P.O.' or 'P.O' ), ' Box' ]
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

DFH
Posts: 636
Joined: Sun Dec 09, 2007 2:49 am
Location: UK

Re: PO Box Patterns

Postby DFH » Tue Dec 13, 2011 3:18 am

Methinks the suggested EasyPattern doesn't cover the uppercase "BOX".

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

Re: PO Box Patterns

Postby DataMystic Support » Tue Dec 13, 2011 9:00 am

You're right David - normally you would not check the Match Case option, and just let TextPipe do its thing.

But in this case it is important to ignore false positives, so Match Case should be checked, and the EasyPattern changed to:

Code: Select all

[ ('P O' or 'PO' or 'P.O.' or 'P.O' ), 1+whitespace, ( 'Box' or 'BOX' ) ]
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: No registered users and 1 guest