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!

Categories:

Building flows

All responses (3)

Answers (1)

Sort by

Verified answer

MF-12051538-0 406 on at

Like
a
(0)

Report
Copy link

Link copied!

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')
v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mlauit ,

Has your problem beed solved?

If not, could you provide some specific sample?

Best Regards.

Wearsky
mlauit 10 on at

Like
a
(0)

Report
Copy link

Link copied!

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!