Answered

Contains using mixed alpha-num

(0) Share

Report

Posted on by mlauit

I have several conditions set up, most of which work as expected, finding text or finding numbers as '1234. There are a few that need to look for mixed letters and numbers like D-57 or 3-8 and they are getting missed. Can someone help with the formatting to allow me to pick these up?

Thanks!

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

MF-12051538-0 400 on at

Like (0)

Report

Re: Contains using mixed alpha-num

Hi @mlauit ,

The column that you are filtering with 'contains' is likely set up as a text column. If so, can you make sure that the search text is wrapped in single quotes?

For example contains(columnname, 'D-57')

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Re: Contains using mixed alpha-num

Hi @mlauit ,

Has your problem beed solved?

If not, could you provide some specific sample?

Best Regards.

Wearsky

Was this reply helpful? Yes No
mlauit 10 on at

Like (0)

Report

Re: Contains using mixed alpha-num

Thanks Nutty. I have now wrapped everything in single quotes, before I only had a leading quote. I did find another problem where it was using some kind of code instead of the actual value. I have made the changes and now just waiting for more reports to come in. Thanks for the help!

Was this reply helpful? Yes No