topic Certain pattern in select option / range in Application Development and Automation Discussions

Certain pattern in select option / range

Former Member — Tue, 12 Aug 2008 14:27:25 GMT

For a certain field COMM1, I have to check if it contains a certain pattern 40050/####

where # = numeric characters.

For example:

COMM1 = AB40050/1234CD is valid,

COMM2 = 40050/12ABCD is not valid, since C and D are not numeric characters.

Is this possible via a range ?

Thanks for your feedback

Re: Certain pattern in select option / range

Former Member — Tue, 12 Aug 2008 14:31:18 GMT

Hello Kris,

Use the wildcard characters in SELECT statement

e.g.:

SELECT ............ WHERE comm1 LIKE '%40050/%' AND comm1 NOT IN (<f 1>, ......, <f n>).

Regards

Indu

Re: Certain pattern in select option / range

ThomasZloch — Tue, 12 Aug 2008 14:35:21 GMT

Don't think this is possible in just one go. You'll probably have to select the '40050/++++' pattern first and loop through the result set, using the known CO or CN '0123456789' operation on the relevant part to toss out unwanted results.

I'm curious if somebody has a better idea.

Thomas

Re: Certain pattern in select option / range

b_deterd2 — Tue, 12 Aug 2008 14:40:09 GMT

Hi,

You could try checking the pattern through regex (regulatory expressions).

The abap statement is FIND REGEX followed by the expression. It is a bit complicated but once you understand it it's quit helpful for validating input.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/866072ca-0b01-0010-54b1-9c02a45ba8aa

regards,

Bert

Re: Certain pattern in select option / range

Former Member — Tue, 12 Aug 2008 15:09:37 GMT

Thanks, but as I understood from the presentation REGEX is only available as of release 7.0 ?

Guess i will need to proceed as Thomas suggested, will let u know the outcome...

cheers

Re: Certain pattern in select option / range

Former Member — Thu, 14 Aug 2008 09:18:37 GMT

Wrote my own function module to check patterns in a string...