AVAYA PDS User Group Bulletin Board Post New Topic  Post A Reply
my profile | directory login | register | search | faq | forum home

  next oldest topic   next newest topic
» AVAYA PDS User Group Bulletin Board » General » Logical Operator ( Selection Statement)

   
Author Topic: Logical Operator ( Selection Statement)
JAY
Member
Member # 524

Icon 1 posted      Profile for JAY   Author's Homepage     Send New Private Message       Edit/Delete Post   Reply With Quote 
I am trying to create a selection which takes into account the last digit of a customers account number.

Ie:
Account #
123456789
123456788
123456782
123456783

If the last digit of the account number is >5 then select.

Anyone provide me with some suggestions.

Thanks

From: Toronto | Registered: Jul 2007  |  IP: Logged | Report this post to a Moderator
ademczak
Administrator
Member # 2

Icon 1 posted      Profile for ademczak     Send New Private Message       Edit/Delete Post   Reply With Quote 
********5,********6,
Try the above * means anything, if you do not have space on the line (if your acct numbers are long) use an or to do the rest

From: Pittsburgh | Registered: May 2005  |  IP: Logged | Report this post to a Moderator
JAY
Member
Member # 524

Icon 1 posted      Profile for JAY   Author's Homepage     Send New Private Message       Edit/Delete Post   Reply With Quote 
Trying to avoid a long statement, was hoping something simpler existing using > or < operators.

I used the below
********5,********6,********7,********8,.

When running this statement the extract takes about 30min on a total list of 220K accts.

From: Toronto | Registered: Jul 2007  |  IP: Logged | Report this post to a Moderator
ademczak
Administrator
Member # 2

Icon 1 posted      Profile for ademczak     Send New Private Message       Edit/Delete Post   Reply With Quote 
What Rev are you on and what CPU?
30 minutes is a long time for that many accounts.

From: Pittsburgh | Registered: May 2005  |  IP: Logged | Report this post to a Moderator
JAY
Member
Member # 524

Icon 1 posted      Profile for JAY   Author's Homepage     Send New Private Message       Edit/Delete Post   Reply With Quote 
V12 PDS

HP C8000
64Bit
4 gig Memory

From: Toronto | Registered: Jul 2007  |  IP: Logged | Report this post to a Moderator
AndyLee
Member
Member # 17

Icon 1 posted      Profile for AndyLee   Author's Homepage     Send New Private Message       Edit/Delete Post   Reply With Quote 
Try 12345678[6-9] - This works for me on v12
From: Birmingham, UK | Registered: May 2005  |  IP: Logged | Report this post to a Moderator
AndyLee
Member
Member # 17

Icon 1 posted      Profile for AndyLee   Author's Homepage     Send New Private Message       Edit/Delete Post   Reply With Quote 
I forgot to add that I usually use ????????[5-9] One ? for each digit of the account number,then the [] represent a range for the last digit. You can use the [] with different content [1,3,5,7,9] to select only odd numbers and combinations [1-3,6,8-9,0]
From: Birmingham, UK | Registered: May 2005  |  IP: Logged | Report this post to a Moderator
ademczak
Administrator
Member # 2

Icon 1 posted      Profile for ademczak     Send New Private Message       Edit/Delete Post   Reply With Quote 
You should be okay so something stuck in memory or if a core dump is taking up to much space….. I think I’ve seen something like that before.... means a call to suport
From: Pittsburgh | Registered: May 2005  |  IP: Logged | Report this post to a Moderator
   

Reply
Message:

HTML is enabled.
UBB Code™ is enabled.

Instant Graemlins
   


Post New Topic  Post A Reply Close Topic   Feature Topic   Move Topic   Delete Topic next oldest topic   next newest topic
 - Printer-friendly view of this topic
Hop To:


Contact Us | AVAYA PDS User Group Home Page

Copyright © 2009, MUG Enterprise LLC - All Rights Reserved

Powered by Infopop Corporation
UBB.classic™ 6.7.2