Mdtryhht

Can one be a co-translator of a book, if he does not know the language that the book is translated into?

Is it inappropriate for a student to attend their mentor's dissertation defense?

How can I tell someone that I want to be his or her friend?

SSH "lag" in LAN on some machines, mixed distros

A reference to a well-known characterization of scattered compact spaces

How to prevent "they're falling in love" trope

Fully-Firstable Anagram Sets

Why does Kotter return in Welcome Back Kotter

How could indestructible materials be used in power generation?

Forgetting the musical notes while performing in concert

What mechanic is there to disable a threat instead of killing it?

When a company launches a new product do they "come out" with a new product or do they "come up" with a new product?

Can a virus destroy the BIOS of a modern computer?

Assassin's bullet with mercury

Alternative to sending password over mail?

What's the difference between 'rename' and 'mv'?

If human space travel is limited by the G force vulnerability, is there a way to counter G forces?

Took a trip to a parallel universe, need help deciphering

How to draw the figure with four pentagons?

What's the point of deactivating Num Lock on login screens?

Why does Arabsat 6A need a Falcon Heavy to launch

Brothers & sisters

Could gravitational lensing be used to protect a spaceship from a laser?

Should I tell management that I intend to leave due to bad software development practices?

Copying/replacing first letter in column of attribute table in ArcMap with field calculator and Python Parser? [on hold]

Rounding column in attribute table using ArcGIS Field Calculator?Replacing attribute table entries using Python scriptFinding and copying text with Field Calculator in ArcGIS for Desktop?ArcGIS field calculator Python generate random point names from attribute tableReplacing multiple values in attribute table field using ArcGIS field calculator and python parser?Replacing values with non-English characters in attribute table field using ArcGIS field calculator and python parser?Make ArcMap label using the first letter from each word in an attributeReclassifying Vector Field using python parser in field calculatorSplitting second word of attribute using Python Parser of ArcMap Field Calculator?Extracting numbers from string field but omit some unnecessary cells using Python Parser of ArcMap Field Calculator?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

How to copy / replace the first letter in a column if that letter is "N" and replace with "C" in the field name "DISTRICT" inside the attribute table in ArcMap using Python inside the field calculator?

arcgis-desktop arcmap field-calculator python-parser

share|improve this question

edited 6 hours ago

PolyGeo♦

53.9k1781245

asked 10 hours ago

Anthony StokesAnthony Stokes

947

put on hold as off-topic by Dan C, Kadir Şahbaz, csk, BERA, ahmadhanb 1 hour ago

This question appears to be off-topic. The users who voted to close gave this specific reason:

• "When seeking help to debug/write/improve code always provide the desired behavior, a specific problem/error and the shortest code (as formatted text, not pictures) needed to reproduce it in the question body. Providing a clear problem statement and a code attempt helps others to help you." – Dan C, Kadir Şahbaz, csk, BERA, ahmadhanb

If this question can be reworded to fit the rules in the help center, please edit the question.

add a comment | 

0

How to copy / replace the first letter in a column if that letter is "N" and replace with "C" in the field name "DISTRICT" inside the attribute table in ArcMap using Python inside the field calculator?

arcgis-desktop arcmap field-calculator python-parser

share|improve this question

edited 6 hours ago

PolyGeo♦

53.9k1781245

asked 10 hours ago

Anthony StokesAnthony Stokes

947

put on hold as off-topic by Dan C, Kadir Şahbaz, csk, BERA, ahmadhanb 1 hour ago

This question appears to be off-topic. The users who voted to close gave this specific reason:

• "When seeking help to debug/write/improve code always provide the desired behavior, a specific problem/error and the shortest code (as formatted text, not pictures) needed to reproduce it in the question body. Providing a clear problem statement and a code attempt helps others to help you." – Dan C, Kadir Şahbaz, csk, BERA, ahmadhanb

If this question can be reworded to fit the rules in the help center, please edit the question.

add a comment | 

How to copy / replace the first letter in a column if that letter is "N" and replace with "C" in the field name "DISTRICT" inside the attribute table in ArcMap using Python inside the field calculator?

arcgis-desktop arcmap field-calculator python-parser

share|improve this question

edited 6 hours ago

PolyGeo♦

53.9k1781245

asked 10 hours ago

Anthony StokesAnthony Stokes

947

share|improve this question

edited 6 hours ago

PolyGeo♦

53.9k1781245

asked 10 hours ago

Anthony StokesAnthony Stokes

947

share|improve this question

edited 6 hours ago

PolyGeo♦

53.9k1781245

asked 10 hours ago

Anthony StokesAnthony Stokes

947

edited 6 hours ago

PolyGeo♦

53.9k1781245

edited 6 hours ago

PolyGeo♦

53.9k1781245

asked 10 hours ago

Anthony StokesAnthony Stokes

947

asked 10 hours ago

Anthony StokesAnthony Stokes

947

4 Answers
4

active

oldest

votes

4

The general format for overall string replace in Python in the Field Calculator is

= !stringvar!.replace("substring to find", "new substring")

If you want to only change the first initial for all records, you could build this based on a slice of the string.

= "C" + !stringvar![1:]

If you only want to change the first initial if it starts with a "N", then you're getting into conditional statements (if/then) and should wrap this in a function for use within the Field Calculator. Build this in the codebook/pre-Logic script code.

def replaceIfN(fieldtochange):
 if fieldtochange.lower().startswith("n"): # handles both n and N
 return "C" + fieldtochange[1:]
 else: # no change made
 return fieldtochange

Run this with

 = replaceIfN(!DISTRICT!) 

See http://desktop.arcgis.com/en/arcmap/10.3/manage-data/tables/calculate-field-examples.htm

share|improve this answer

answered 10 hours ago

smillersmiller

2,229217

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The conditional statement is the solution I was looking for.
  
  – Anthony Stokes
  9 hours ago
  

  
  
  
  

add a comment | 

6

You don't even have to write any code!

Simply edit the table and do a find and replace on the selected field.

Example of replacing B with XXX.

Result of replacement

share|improve this answer

answered 10 hours ago

HornbyddHornbydd

27.1k32957

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I need to know how to copy / replace the first letter in a column if that letter is "N" and replace with "C" using python inside the field calculator. I don't want to replace every instance of "N". This would require some code.
  
  – Anthony Stokes
  9 hours ago
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Well... if you look at the image, what does Text match say... You can use @Jackson_Dunn's approach if you intend to wrap the field calculate in say modelbuilder. If you just want to replace the first N with C then my approach is less painful and quicker.
  
  – Hornbydd
  9 hours ago
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I see what you mean. This is the fastest way without code but I like to always know the python equivalent.
  
  – Anthony Stokes
  9 hours ago
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Are imgur images always going to be on the site, or is there a risk of them not loading at some distant point in the future? If the latter, please elaborate on your answer (e.g. Select "Start of Field" for Text match)
  
  – smiller
  8 hours ago
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  I didnt know of find and replace, nice!
  
  – BERA
  7 hours ago
  

  
  
  
  

 | 
show 2 more comments

1

You can add a number to the python replace code to determine how many instances to change (in your case just one):

!District!.replace("C", "N", 1)

share|improve this answer

edited 6 hours ago

PolyGeo♦

53.9k1781245

answered 7 hours ago

Jackson DunnJackson Dunn

192

New contributor

Jackson Dunn is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks @Jackson Dunn. I'd be curious as to performance between the string replace number of instances vs. string slicing. I suspect in this case it's minimal but may be worth testing on larger fields or more complex replacements.
  
  – smiller
  6 hours ago
  

  
  
  
  

add a comment | 

0

Using vbscript instead if you're working in ArcGIS Desktop, The code is:

REPLACE ([DISTRICT],"C","N",1,1)

Where :

• the first 1 equals the line position (first character)


• and the second 1 is amount of characters to change (only need to change one letter per row, not all C's and N's).

share|improve this answer

edited 6 hours ago

PolyGeo♦

53.9k1781245

answered 10 hours ago

Jackson DunnJackson Dunn

192

New contributor

Jackson Dunn is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This is the VB script solution so thank you for that but I was wondering how to solve it using python in the field calculator.
  
  – Anthony Stokes
  10 hours ago
  

  
  
  
  

add a comment | 

4

The general format for overall string replace in Python in the Field Calculator is

= !stringvar!.replace("substring to find", "new substring")

If you want to only change the first initial for all records, you could build this based on a slice of the string.

= "C" + !stringvar![1:]

If you only want to change the first initial if it starts with a "N", then you're getting into conditional statements (if/then) and should wrap this in a function for use within the Field Calculator. Build this in the codebook/pre-Logic script code.

def replaceIfN(fieldtochange):
 if fieldtochange.lower().startswith("n"): # handles both n and N
 return "C" + fieldtochange[1:]
 else: # no change made
 return fieldtochange

Run this with

 = replaceIfN(!DISTRICT!) 

See http://desktop.arcgis.com/en/arcmap/10.3/manage-data/tables/calculate-field-examples.htm

share|improve this answer

answered 10 hours ago

smillersmiller

2,229217

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The conditional statement is the solution I was looking for.
  
  – Anthony Stokes
  9 hours ago
  

  
  
  
  

add a comment | 

4

The general format for overall string replace in Python in the Field Calculator is

= !stringvar!.replace("substring to find", "new substring")

If you want to only change the first initial for all records, you could build this based on a slice of the string.

= "C" + !stringvar![1:]

If you only want to change the first initial if it starts with a "N", then you're getting into conditional statements (if/then) and should wrap this in a function for use within the Field Calculator. Build this in the codebook/pre-Logic script code.

def replaceIfN(fieldtochange):
 if fieldtochange.lower().startswith("n"): # handles both n and N
 return "C" + fieldtochange[1:]
 else: # no change made
 return fieldtochange

Run this with

 = replaceIfN(!DISTRICT!) 

See http://desktop.arcgis.com/en/arcmap/10.3/manage-data/tables/calculate-field-examples.htm

share|improve this answer

answered 10 hours ago

smillersmiller

2,229217

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The conditional statement is the solution I was looking for.
  
  – Anthony Stokes
  9 hours ago
  

  
  
  
  

add a comment | 

The general format for overall string replace in Python in the Field Calculator is

= !stringvar!.replace("substring to find", "new substring")

If you want to only change the first initial for all records, you could build this based on a slice of the string.

= "C" + !stringvar![1:]

If you only want to change the first initial if it starts with a "N", then you're getting into conditional statements (if/then) and should wrap this in a function for use within the Field Calculator. Build this in the codebook/pre-Logic script code.

def replaceIfN(fieldtochange):
 if fieldtochange.lower().startswith("n"): # handles both n and N
 return "C" + fieldtochange[1:]
 else: # no change made
 return fieldtochange

Run this with

 = replaceIfN(!DISTRICT!) 

See http://desktop.arcgis.com/en/arcmap/10.3/manage-data/tables/calculate-field-examples.htm

share|improve this answer

answered 10 hours ago

smillersmiller

2,229217

= !stringvar!.replace("substring to find", "new substring")

= "C" + !stringvar![1:]

def replaceIfN(fieldtochange):
 if fieldtochange.lower().startswith("n"): # handles both n and N
 return "C" + fieldtochange[1:]
 else: # no change made
 return fieldtochange

 = replaceIfN(!DISTRICT!) 

share|improve this answer

answered 10 hours ago

smillersmiller

2,229217

answered 10 hours ago

smillersmiller

2,229217

answered 10 hours ago

smillersmiller

2,229217

6

You don't even have to write any code!

Simply edit the table and do a find and replace on the selected field.

Example of replacing B with XXX.

Result of replacement

share|improve this answer

answered 10 hours ago

HornbyddHornbydd

27.1k32957

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I need to know how to copy / replace the first letter in a column if that letter is "N" and replace with "C" using python inside the field calculator. I don't want to replace every instance of "N". This would require some code.
  
  – Anthony Stokes
  9 hours ago
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Well... if you look at the image, what does Text match say... You can use @Jackson_Dunn's approach if you intend to wrap the field calculate in say modelbuilder. If you just want to replace the first N with C then my approach is less painful and quicker.
  
  – Hornbydd
  9 hours ago
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I see what you mean. This is the fastest way without code but I like to always know the python equivalent.
  
  – Anthony Stokes
  9 hours ago
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Are imgur images always going to be on the site, or is there a risk of them not loading at some distant point in the future? If the latter, please elaborate on your answer (e.g. Select "Start of Field" for Text match)
  
  – smiller
  8 hours ago
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  I didnt know of find and replace, nice!
  
  – BERA
  7 hours ago
  

  
  
  
  

 | 
show 2 more comments

6

You don't even have to write any code!

Simply edit the table and do a find and replace on the selected field.

Example of replacing B with XXX.

Result of replacement

share|improve this answer

answered 10 hours ago

HornbyddHornbydd

27.1k32957

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I need to know how to copy / replace the first letter in a column if that letter is "N" and replace with "C" using python inside the field calculator. I don't want to replace every instance of "N". This would require some code.
  
  – Anthony Stokes
  9 hours ago
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Well... if you look at the image, what does Text match say... You can use @Jackson_Dunn's approach if you intend to wrap the field calculate in say modelbuilder. If you just want to replace the first N with C then my approach is less painful and quicker.
  
  – Hornbydd
  9 hours ago
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I see what you mean. This is the fastest way without code but I like to always know the python equivalent.
  
  – Anthony Stokes
  9 hours ago
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Are imgur images always going to be on the site, or is there a risk of them not loading at some distant point in the future? If the latter, please elaborate on your answer (e.g. Select "Start of Field" for Text match)
  
  – smiller
  8 hours ago
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  I didnt know of find and replace, nice!
  
  – BERA
  7 hours ago
  

  
  
  
  

 | 
show 2 more comments

You don't even have to write any code!

Simply edit the table and do a find and replace on the selected field.

Example of replacing B with XXX.

Result of replacement

share|improve this answer

answered 10 hours ago

HornbyddHornbydd

27.1k32957

share|improve this answer

answered 10 hours ago

HornbyddHornbydd

27.1k32957

answered 10 hours ago

HornbyddHornbydd

27.1k32957

answered 10 hours ago

HornbyddHornbydd

27.1k32957

1

You can add a number to the python replace code to determine how many instances to change (in your case just one):

!District!.replace("C", "N", 1)

share|improve this answer

edited 6 hours ago

PolyGeo♦

53.9k1781245

answered 7 hours ago

Jackson DunnJackson Dunn

192

New contributor

Jackson Dunn is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks @Jackson Dunn. I'd be curious as to performance between the string replace number of instances vs. string slicing. I suspect in this case it's minimal but may be worth testing on larger fields or more complex replacements.
  
  – smiller
  6 hours ago
  

  
  
  
  

add a comment | 

1

You can add a number to the python replace code to determine how many instances to change (in your case just one):

!District!.replace("C", "N", 1)

share|improve this answer

edited 6 hours ago

PolyGeo♦

53.9k1781245

answered 7 hours ago

Jackson DunnJackson Dunn

192

New contributor

Jackson Dunn is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks @Jackson Dunn. I'd be curious as to performance between the string replace number of instances vs. string slicing. I suspect in this case it's minimal but may be worth testing on larger fields or more complex replacements.
  
  – smiller
  6 hours ago
  

  
  
  
  

add a comment | 

You can add a number to the python replace code to determine how many instances to change (in your case just one):

!District!.replace("C", "N", 1)

share|improve this answer

edited 6 hours ago

PolyGeo♦

53.9k1781245

answered 7 hours ago

Jackson DunnJackson Dunn

192

New contributor

Jackson Dunn is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

!District!.replace("C", "N", 1)

share|improve this answer

edited 6 hours ago

PolyGeo♦

53.9k1781245

answered 7 hours ago

Jackson DunnJackson Dunn

192

New contributor

Jackson Dunn is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

edited 6 hours ago

PolyGeo♦

53.9k1781245

edited 6 hours ago

PolyGeo♦

53.9k1781245

answered 7 hours ago

Jackson DunnJackson Dunn

192

New contributor

Jackson Dunn is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

answered 7 hours ago

Jackson DunnJackson Dunn

192

0

Using vbscript instead if you're working in ArcGIS Desktop, The code is:

REPLACE ([DISTRICT],"C","N",1,1)

Where :

• the first 1 equals the line position (first character)


• and the second 1 is amount of characters to change (only need to change one letter per row, not all C's and N's).

share|improve this answer

edited 6 hours ago

PolyGeo♦

53.9k1781245

answered 10 hours ago

Jackson DunnJackson Dunn

192

New contributor

Jackson Dunn is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This is the VB script solution so thank you for that but I was wondering how to solve it using python in the field calculator.
  
  – Anthony Stokes
  10 hours ago
  

  
  
  
  

add a comment | 

0

Using vbscript instead if you're working in ArcGIS Desktop, The code is:

REPLACE ([DISTRICT],"C","N",1,1)

Where :

• the first 1 equals the line position (first character)


• and the second 1 is amount of characters to change (only need to change one letter per row, not all C's and N's).

share|improve this answer

edited 6 hours ago

PolyGeo♦

53.9k1781245

answered 10 hours ago

Jackson DunnJackson Dunn

192

New contributor

Jackson Dunn is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This is the VB script solution so thank you for that but I was wondering how to solve it using python in the field calculator.
  
  – Anthony Stokes
  10 hours ago
  

  
  
  
  

add a comment | 

Using vbscript instead if you're working in ArcGIS Desktop, The code is:

REPLACE ([DISTRICT],"C","N",1,1)

Where :

• the first 1 equals the line position (first character)


• and the second 1 is amount of characters to change (only need to change one letter per row, not all C's and N's).

share|improve this answer

edited 6 hours ago

PolyGeo♦

53.9k1781245

answered 10 hours ago

Jackson DunnJackson Dunn

192

New contributor

Jackson Dunn is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

REPLACE ([DISTRICT],"C","N",1,1)

share|improve this answer

edited 6 hours ago

PolyGeo♦

53.9k1781245

answered 10 hours ago

Jackson DunnJackson Dunn

192

New contributor

Jackson Dunn is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

edited 6 hours ago

PolyGeo♦

53.9k1781245

edited 6 hours ago

PolyGeo♦

53.9k1781245

answered 10 hours ago

Jackson DunnJackson Dunn

192

New contributor

Jackson Dunn is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

answered 10 hours ago

Jackson DunnJackson Dunn

192