RegEx to flag word starting with 8

[fnkankeu]

Hi,

I want to create a RegEx that flag the cell that have a word starting with 8.

I tried the RegEx below with the RegEx Tool but none of them seems to work.

- \<8

- ^8

Please help me.

Thanks

[DataNath]

Hey @fnkankeu if you just want to create a flag based on what the code starts with, there's no need for RegEx! Can just use something like the following:

StartsWith(ToString([Code]), '8')

Chucking in an edit here, just in case you're insistent on RegEx (or to just illustrate how if you're still curious). You could just change the expression to something like the following:

^8.*