Using a Wildcard in Report Writer

[Michelle D.]

The following is an example of what I need to accomplish on various reports:

Where Order Type (F4211) [BC] is equal to 'SO'
and Sales Catalog Section (F4211) [BC] is equal to '
*7* '

Notice the wildcards before and after the "7." I know you can't do this
using data selection, does anyone have any workarounds?

Thank you,
Michelle Dulay
ERP Coordinator
Pump & Engine Control Systems
Goodrich Corporation
[email protected]

LIVE ON:
OneWorld B7322 with the MFG Mini-Cum, coexistent with World A7.3
AS400 V4R3 Enterprise Server
Windows NT SQL V6.5 Deployment Server
SynQuest V5.07.02
Oracle
NT Logic - between AS400 (OneWorld) and HP9000 (SynQuest)

UPGRADING TO:
OneWorld Xe, SP 15.1, Update 2, ESU JD10371, JD11176, & JD12031
Windows 2000 Deployment / Enterprise
SQL 2000

 

[Frosty the Coder]

Would a RANGE work? (7bb through 799)?

Corning Data Services
[email protected]

(office) (716) 853-6215 <------------------------------
(cell) (716) 472-3589
(home) (716) 662-7171



Gene Piekarski, Jr

AS/400, B733, SP11.2, NT client
AS/400, B733, SP14, W2000 client
XE, SP15.1

 

[Michelle D.]

Yes, a RANGE would work where the wildcard is only at the end. I also need
to have a wildcard either at the beginning and the end or just at the
beginning.

 

[Frosty the Coder]

Re: RE: Using a Wildcard in Report Writer

As a non-code solution, could you establish
another cat code to group all your *7*'s
(or are your users loathe to do that)?

Gene

Gene Piekarski, Jr

AS/400, B733, SP11.2, NT client
AS/400, B733, SP14, W2000 client
XE, SP15.1

 

[Michelle D.]

RE: RE: Using a Wildcard in Report Writer

Gene,

Thank you for the suggestion, however, I'm going to run into this problem
for all kinds of different things. The sales cat code was just an example.

FYI - What I'm doing is converting AS/400 queries to UBE's (we're switching
platforms when we upgrade to Xe - see my signature info).

Michelle Dulay
ERP Coordinator
Pump & Engine Control Systems
Goodrich Corporation
[email protected]

LIVE ON:
OneWorld B7322 with the MFG Mini-Cum, coexistent with World A7.3
AS400 V4R3 Enterprise Server
Windows NT SQL V6.5 Deployment Server
SynQuest V5.07.02
Oracle
NT Logic - between AS400 (OneWorld) and HP9000 (SynQuest)

UPGRADING TO:
OneWorld Xe, SP 15.1, Update 2, ESU JD10371 & JD11176
Windows 2000 Deployment / Enterprise
SQL 2000

 

[Frosty the Coder]

RE: RE: Using a Wildcard in Report Writer

Michelle,

All I can say is "good luck".

If you do come up w/a "neat" solution, please post it here.

Gene



Gene Piekarski, Jr

AS/400, B733, SP11.2, NT client
AS/400, B733, SP14, W2000 client
XE, SP15.1

 

[flyingmg]

I couldn't think of any solution in RDA. But you could write a very simple and generic C business funtion. It will include three parameters, string1, string2 and flag. If string 1 is a part of string 2, return True. Otherwise, False.

If anyone wants the code, I can post it.

MG
B7332 SP13.3 Win2000/SQL2000

G
[email protected]