PO Box Patterns

Get help with installation and running here.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

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

PO Box Patterns

Post by lg777 »

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

Re: PO Box Patterns

Post by DataMystic Support »

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' ]
dfhtextpipe
Posts: 986
Joined: Sun Dec 09, 2007 2:49 am
Location: UK

Re: PO Box Patterns

Post by dfhtextpipe »

Methinks the suggested EasyPattern doesn't cover the uppercase "BOX".
David
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: PO Box Patterns

Post by DataMystic Support »

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' ) ]
Post Reply