Jump to content

how to use wildcard in a calculated field?


This topic is 6585 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi everyone,

Is it possible to use wildcard in a calculated field? What I mean is, instead of:

or

(Field A=1 and File B::Name="Dimitri") or

(Field A=1 and File B::Name="Dany") or

(Field A=1 and File B::Name="Daniel") or

(Field A=1 and File B::Name="Dan") or

(Field A=1 and File B::Name="Dimanuk") , 1, "")

Write something like:

Case(Field A=1 and File B::Name="D*", 1, "")

I know this is not the right syntax, but you get the idea. I want to use the wildcard like in search.

Thanks in advance

Link to comment
Share on other sites

This topic is 6585 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.