Trying to pull in part numbers that end with number in a BAQ

Yahoo Archive
1
Hi,
I thought this query might fit in well. I know MATCHES can use wild cards . (fullstop) and *.  But what if you were looking for a range like a SQL LIKE clause eg [0-9][0-9]  (two characters but can only be 0 to 9)?  Is there a way to do this in ABL? or am I better off just putting it into C# and be done with it.

We are on 9.05.701.

I am trying to work out a way to identify if users have inadvertently put a credit card number into a Case or Call description.

Cheers
Simon Hall
2

9.05.702A

 

I’m trying to select only part numbers that end with a number in an updateable BAQ so we can update those parts.  We have parts that have a suffix of CS and I don’t want those in my query.  Searched the archives, but I couldn’t find an answer to this.  I found how to trim/parse a field to display but that isn’t what I was looking for.  Can anyone help with this?

 

Bethany Rye
PTI Engineered Plastics Epicor Business Analyst


3

We are version 8.03.409C

In Phrase Builder, criteria, you can choose the PartNum check a box for “Not” and there is an Operator for BEGINS and MATCHES.  I think you can use MATCHES *CS and without the * after CS it might only have those ending in CS?

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Bethany Rye
Sent: Tuesday, January 14, 2014 4:05 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Trying to pull in part numbers that end with number in a BAQ

 

 

9.05.702A

 

I’m trying to select only part numbers that end with a number in an updateable BAQ so we can update those parts.  We have parts that have a suffix of CS and I don’t want those in my query.  Searched the archives, but I couldn’t find an answer to this.  I found how to trim/parse a field to display but that isn’t what I was looking for.  Can anyone help with this?

 

Bethany Rye
PTI Engineered Plastics Epicor Business Analyst



4
Thanks Karen! That worked! I was trying to do that yesterday but wasn't
using the * (just CS).



Bethany Rye
PTI Engineered Plastics Epicor Business Analyst

<http://www.teampti.com/>


50900 Corporate Drive


Macomb, MI 48044-1008


Tel

586.263.5100


<mailto:brye@...> brye@...


www.teampti.com



CONFIDENTIALITY NOTICE: This electronic message (including any attachments)
contains information from PTI Engineered Plastics, Inc. which may be
privileged, confidential or otherwise protected from disclosure. This e-mail
transmission is intended for a specific individual and purpose is protected
by law. If you are not the intended recipient, you should delete this
message, and you are hereby notified that any disclosure, copying, or
distribution of this message, or the taking of any action based upon it, is
strictly prohibited. This information is intended only for the use of
individual(s) or entity to whom it is intended even if addressed
incorrectly. If you have received this message in error, please notify us
immediately (1-586-263-5100) and destroy the original message and all
copies. Thank you for your compliance.



[Non-text portions of this message have been removed]