topic Using Field Calculator vb to check for name with /n in the string in Developers Questions

Using Field Calculator vb to check for name with /n in the string

TiffanySelvidge1 — Thu, 07 Jan 2016 19:17:43 GMT

I am calculating values for a field (Score) based upon the names from another field (Modified). One name is "blaugh\nblaugh". Field Calculator keeps treating the name as having a new line command.

I have tried using Like, Right, Contains, etc but the Field calculator does not seem to be able to use those commands. I am stumped.

Ex1: elseif [Modified] = "blaugh\nblaugh" then Score =7

Ex2: elseif Right( [Modified], -6) = "blaugh" then Score =7

Ex3: elseif [Modified] LIKE "*nblaugh" then Score =7

I am using vb in ModelBuilder and ArcCatalog 10.3.1

Any help will be appreciated.

Re: Using Field Calculator vb to check for name with /n in the string

DarrenWiens2 — Thu, 07 Jan 2016 19:30:18 GMT

Try:

elseif InStr([Modified], vbNewLine) then Score =7

Re: Using Field Calculator vb to check for name with /n in the string

TiffanySelvidge1 — Thu, 07 Jan 2016 19:53:38 GMT

It still doesn't work.

Field Calculator accepts the code but does not recognize any relevant records.

Re: Using Field Calculator vb to check for name with /n in the string

TiffanySelvidge1 — Thu, 07 Jan 2016 20:21:37 GMT

Darren,

Got it!

I took your code and modified it to:

elseif InStr( [Modified], nblaugh) then Score =7

Thank you very much for your help. I had been puzzling over that problem for some time.