If cell begins with then

I'm looking for data that begins with "0110" followed by several more numbers and some letters. I want to say if the data begins with "0110", then "comment" else "". Right now I have

IF REGEX_Match([column],'^0110\d+') then "comment" else "" endif

However this is not picking up anything. I'm assuming it has something to do with the 'd' in the formula. How can I adjust this so that it will find the correct information? Thanks!

Regex

Accepted answers

mpennington

Yup, the extra space is the issue.

IIF(REGEX_Match([CPSC], '^0110\d+.*\s*'),'Comment','')

All comments

mpennington

Does this work for you?

IIF(REGEX_Match([column], '^0110\d+.*'),'Comment','')

sswift13

Thanks for your quick reply, however, that did not solve the issue for me.

mpennington

Can you provide some sample text and expected results? When I tested it with data as described, I got the result I was expecting. To be clear, the logic I am using is the exact 4 digits 0110 followed by at least 1 digit and then any number of digits or characters. I could be missing something.

sswift13

There is a space in my data which might be causing the problem.

cpsc.xlsx

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703