PO Box Patterns

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

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

PO Box Patterns

Post by 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: 2206
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: PO Box Patterns

Post by 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: 705
Joined: Sun Dec 09, 2007 2:49 am
Location: UK

Re: PO Box Patterns

Post by 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: 2206
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: PO Box Patterns

Post by 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

Post Reply

Who is online

Users browsing this forum: No registered users and 18 guests