nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Does anyone know how to use a wild card if then statement in field calculator?

DanCrawford

I'm trying to setup a simple if then statement that uses a wildcard:

If [SPECIES_CD_2] = "B" Then ** this statement works but

If [SPECIES_CD_2] LIKE "B*" Then ** this statement doesn't

I've tried substituting %, #, & for the asterisk but I keep getting an error (sub or function not defined)

Help!!!

Find more posts tagged with

Accepted answers

JoshuaBixby

When working in the field calculator, you are either using VBScript or Python, I strongly recommend Python. The LIKE operator you are attempting to use is an SQL function. Python does not have a LIKE string function and I don't believe VBScript does either.

Your syntax indicates you are using VBScript. I believe If LEFT([SPECIES_CD_2],1) = "B" should mimic the LIKE statement you have provided.

All comments

JoshuaBixby

If my, or any other, response answers your question, please mark it Correct so others know you already have a workable solution.

DanCrawford

Quick testing seems to confirm that what you suggest works!

Thank-you Joshua!

JoshuaBixby

Your syntax indicates you are using VBScript. I believe If LEFT([SPECIES_CD_2],1) = "B" should mimic the LIKE statement you have provided.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.