topic Re: REGEX rule in VTA 8.5. Lower cased words were also matched when using REGEX:[A-Z] in SAS Data Science

REGEX rule in VTA 8.5. Lower cased words were also matched when using REGEX:[A-Z]

SASvtaUser — Mon, 01 Jul 2024 09:09:33 GMT

Hi all, I'm new to SAS VTA so some mercy please!

I'm trying to use REGEX rules to capture Uppercase or Proper case only, according to 8.5 user documentation:

"To add uppercase characters, use the following rule:"

REGEX:[A-Fa-f]

However I tried to define REGEX:0125\-[A-Z], but the match is in both lower and upper case, as shown in the attachment.

So first question is why lower case were also matched?

And second, if I want to match the proper cased words within a sentence, how may I do that?

Example: Stark Industries is a pioneering multinational conglomerate known for its cutting-edge advancements in technology and innovation. Founded by Howard Stark, it has grown into a global leader in aerospace, defense, and advanced manufacturing. With a commitment to pushing the boundaries of what's possible, Stark Industries continues to shape the future through its revolutionary products and solutions.

Say I would like to only match the words in bold in the above paragraph....

Loads of thanks!

Re: REGEX rule in VTA 8.5. Lower cased words were also matched when using REGEX:[A-Z]

rudfaden — Mon, 01 Jul 2024 09:37:13 GMT

You could try something like this

[A-Z]{1}[a-z]+\s[A-Z]{1}[a-z]+

Explanation
[A-Z]{1} - singe upper case letter
[a-z]+ - multiple lower case letters

\s a single space

[A-Z]{1} - singe upper case letter

[a-z]+ - multiple lower case letters

do the sam

Re: REGEX rule in VTA 8.5. Lower cased words were also matched when using REGEX:[A-Z]

SASvtaUser — Mon, 01 Jul 2024 09:49:32 GMT

Thank you!!! I will try out!!

Could also ask on why is REGEX:0125\-[A-Z] also returning lower case (0125-a) as a match?

Re: REGEX rule in VTA 8.5. Lower cased words were also matched when using REGEX:[A-Z]

rudfaden — Mon, 01 Jul 2024 10:02:04 GMT

No. [A-Z] should only match a single Uppercase letter

Re: REGEX rule in VTA 8.5. Lower cased words were also matched when using REGEX:[A-Z]

SASvtaUser — Tue, 02 Jul 2024 06:42:19 GMT

Update: I tried the proposed solution, still not working...

The issue is still, uppercase or lowercase words are matched regardless.

Re: REGEX rule in VTA 8.5. Lower cased words were also matched when using REGEX:[A-Z]

rudfaden — Tue, 02 Jul 2024 08:27:35 GMT

Sounds like a bug. I would contact SAS support.