nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Regex Match issue

Cela

Hi everyone,

I am trying to formulate the proper expression for the following condition:

The cell value should consisit of the combination: 2 capital letters ([A-Z]), 9 alphanumeric values (\w) and 1 digit (\d)

An example of the allowed cell value would be 'GB1w87p30f40'.

I tried a few variations of the expression I thought would work but I can't seem to put it together properly.

Would appreciate it if somebody could help me out here.

Thanks in advance!

Expression

Accepted answers

FrederikE

Hey @Cela,

This should work: ^[A-Z]{2}\w{9}\d$

Screenshot 2023-10-13 122614.png

FYI, ChatGPT is very good for such straight-forward Regex.

caltang

Nevermind... did some random data here:

^[A-Z]{2}\w{9}\d$

All comments

caltang

Please provide relevant data to this use case, and kindly provide your criteria in as much detail as possible. If you have a workflow built halfway, kindly export that over as well.

FrederikE

Hey @Cela,

This should work: ^[A-Z]{2}\w{9}\d$

Screenshot 2023-10-13 122614.png

FYI, ChatGPT is very good for such straight-forward Regex.

caltang

Nevermind... did some random data here:

^[A-Z]{2}\w{9}\d$

Cela

@caltang Thanks for the quick response! I am basically checking the cell values of a specific column to see if the condition is met. This checkup happens in inside the Table tool by editing the column rule for the specific column. If the condition is not met, I want to turn the background color crimson, else it shall turn green.

My issue doesn't lie with the entire expression but with the format of the condition itself:

If !REGEX_Match([Field1], >MISSING EXPRESSION HERE<) then "background-color: crimson" else "background-color: green" endif

Hope it helps to clarify what I meant initially!

Cela

Perfect, thanks guys!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15905

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703