Search for specific strings

[johnca]

I need help determining if some specific strings are present in a field and return a yes if it is. I don't need them parsed out. The data looks like below with the expected inclusion or not. Numbers appear to be stored as text.

Rules are:

Numbers begin with 551 or 651 and 10 digits long.

Numbers begin with 751 or 851 or 951 and 8 digits long.

Value	Include?
01/01/15 - 01/16/15	no
01/27/16 - 02/23/16	no
2 Wall Brackets	no
202 - 649301703 - 001 Period 07/29/16 - 08/28/16	no
342-7278 163-4096 Period 06/01/16 - 07/05/16	no
2016 - 2017 Renewal Fee	no
8186, 8476, 8831	no
1720281 & 1720291	no
75100660/ 75100827	yes
511977911 - 01/12/16	no
4001745021 - 07/08/16	no
5510002648/ 5510006394	yes
5510005214/ 5510005788	yes
5510006967/ 5510007038/ 5510007030	yes
5510007016/5510004208	yes
5510007038/ 5510007678/ 5510007364/ 5510006967/ 5510007174/ 5510007030	yes
8772106120569243	no
Account Number: ABC02699025	no
Acct 202-649301702-001 Period 02/19/16 - 03/18/16	no
Acct 500000882 Period 08/22/15 - 09/21/15	no
Acct 500000882 Period 09/22/15 - 10/21/15	no
Acct 85175552691 10/20/15 - 11/19/15	no
Acct 8310005107651; 01/19/2016	no
Acct 3000317097117834672 Period 06/22/16 - 07/21/16	no
acct# 85175552691 Period 05/22/16 - 06/21/16	no
Client Number 762293	no
Contract# 8000011734	no
Cust# 10638269	no
Customer # 6000607033	no
Kitchen Supplies	no
MANAGEMENT FEE	no
Membership Dues	no
Order Number 9000251488	no
Plastic Cup Tumbler	no
Project 381533800IS	no
Quarterly Maintenance Service Contract	no
REFERRAL FEE	no
Registration Fees	no
Requisition 55900024515	no
75100454	yes
75100660	yes
75100663	yes
85100002	yes
85100029	yes
85100042	yes
5510000354	yes
5510000682	yes
5510001412	yes
5510002529	yes
5510002647	yes
6510000049	yes
6510000054	yes
55100000354	no

Thanks,

John

[johnca]

Miguel, this indeed does what I asked and even better, what I need. I've really only used ApplyMap and the alternate MapSubString is way more versatile...nice. I added a couple characters to the delimiter map as well. I will certainly use this function and method on some other data. Thank you!

And yes, gotta love Rob, and his QlikView Cook Book!

--john