topic Re: Does anyone know how to use a wild card if then statement in field calculator? in Python Questions

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

DanCrawford — Fri, 05 May 2017 17:08:15 GMT

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!!!

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

JoshuaBixby — Fri, 05 May 2017 17:49:42 GMT

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.

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

DanCrawford — Fri, 05 May 2017 18:03:18 GMT

Quick testing seems to confirm that what you suggest works!

Thank-you Joshua!

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

JoshuaBixby — Fri, 05 May 2017 18:54:57 GMT

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