Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved Match pattern in PB filter

  1. How-to
0
Votes
Undo
  1. Nguyen Xuan Huy
    Nguyen Xuan Huy
  2. PowerBuilder
  3. Thursday, 18 March 2021 16:37 PM UTC

Hi ,

 

I have a question related Match pattern in PB.

Is "match" work like "REGEXP_LIKE" of oracle?

"select 'jj' from dual where REGEXP_LIKE( 'ada;abc;yrhfjs;37;hgs', '(abc)+*([3][6-9]|[4-9][0-9])')"

Does "match" have group expression '()' and alternation operator '|' ?

 

I would like to do the same for filtering datawindow by MATCH PB Function. Thanks

 

Best regard

Huy

Changemenu
PowerClient Deployment Server
Responses (2)
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Thursday, 18 March 2021 19:12 PM UTC
  2. PowerBuilder
  3. # 1

The Help documentation for the Match PowerScript function and the Match DataWindow expression function do not list either the group expression or alternation operator as supported.

That being said, however, I agree with Olan; try it with a test case.

Regards, John

Comment
There are no comments made yet.
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Thursday, 18 March 2021 17:58 PM UTC
  2. PowerBuilder
  3. # 2

I think that the MATCH is like the Oracle REGEXP_LIKE.

It's a quick test: just run it and see if you get what you need!  :)


Later -

Olan

Comment
Arnd Schmidt
  1. Arnd Schmidt
  2. Thursday, 18 March 2021 19:07 PM UTC
Like the Oracle REGEXP_LIKE.

At least the alternation | is not documented.

https://docs.appeon.com/pb2019/powerscript_reference/ch10s405.html

  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.