Match textpattern to match two words in a string
I am trying to set a textpattern to match two parts found in a string
First Part is before Second Part. Wonderful!
Every string which contains 'First Part' and 'Second Part' should match.
Using a reqular expression I'd go with: ^(?=.*\bFirst Part\b)(?=.*\bSecond Part).*$
But that expression as a textpattern does not match.
How to accomplish this using the Powerscript Match function?
If you want to test that your string contains First Part then Second Part, you can use the match function like this :
Match(ls_Test, "First Part.*Second Part")
But maybe you want something more ?