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; } } }

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

TiffanySelvidge1

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.

Find more posts tagged with

Accepted answers

TiffanySelvidge1

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.

All comments

DarrenWiens2

Try:

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

TiffanySelvidge1

It still doesn't work.

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

TiffanySelvidge1

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.

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.