Jump to content
We've recently updated our Privacy Statement, available here ×

Calculated Field - if a field contains certain characters


chorsell_1

Recommended Posts

Hi, i am trying to create a calculated field.   For example i have fields which contain ABC 01, ABC 02 etc.

What i want is to have a new field calculated based on whether a field has 01 in it.

I can do it if i say field equals ABC 01 (in other words the whole value) by using something like this if(public_incidentreportdonotuse_212.tenancyname_c358 == 'ABC 01','MALL1', if(public_incidentreportdonotuse_212.tenancyname_c358 == 'ABC 02','Mall2'))

But not by just looking for part of the value.   The reason i need this is i may have 100 values with a different ABC but with 01 at the end. 

 

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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

×
×
  • Create New...