Copying/replacing first letter in column of attribute table in ArcMap with field calculator and Python Parser?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?
Is it possible to create light that imparts a greater proportion of its energy as momentum rather than heat?
I Accidentally Deleted a Stock Terminal Theme
How could indestructible materials be used in power generation?
Watching something be written to a file live with tail
What's the point of deactivating Num Lock on login screens?
Is it inappropriate for a student to attend their mentor's dissertation defense?
Why can't we play rap on piano?
Combinations of multiple lists
Anagram holiday
What to put in ESTA if staying in US for a few days before going on to Canada
Why does Arabsat 6A need a Falcon Heavy to launch
UK: Is there precedent for the governments e-petition site changing the direction of a government decision?
Today is the Center
Twin primes whose sum is a cube
Can a rocket refuel on Mars from water?
SSH "lag" in LAN on some machines, mixed distros
How badly should I try to prevent a user from XSSing themselves?
What reasons are there for a Capitalist to oppose a 100% inheritance tax?
Has there ever been an airliner design involving reducing generator load by installing solar panels?
How can I make my BBEG immortal short of making them a Lich or Vampire?
How can I tell someone that I want to be his or her friend?
What is going on with Captain Marvel's blood colour?
Famous Pre Reformation Christian Pastors (Non Catholic and Non Orthodox)
How can saying a song's name be a copyright violation?
Copying/replacing first letter in column of attribute table in ArcMap with field calculator and Python Parser?
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;
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
edited 3 hours ago
PolyGeo♦
53.9k1781245
asked 7 hours ago
Anthony StokesAnthony Stokes
947
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
edited 3 hours ago
PolyGeo♦
53.9k1781245
asked 7 hours ago
Anthony StokesAnthony Stokes
947
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
edited 3 hours ago
PolyGeo♦
53.9k1781245
asked 7 hours ago
Anthony StokesAnthony Stokes
947
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
arcgis-desktop arcmap field-calculator python-parser
edited 3 hours ago
PolyGeo♦
53.9k1781245
asked 7 hours ago
Anthony StokesAnthony Stokes
947
edited 3 hours ago
PolyGeo♦
53.9k1781245
asked 7 hours ago
Anthony StokesAnthony Stokes
947
edited 3 hours ago
PolyGeo♦
53.9k1781245
edited 3 hours ago
PolyGeo♦
53.9k1781245
edited 3 hours ago
PolyGeo♦
53.9k1781245
53.9k1781245
asked 7 hours ago
Anthony StokesAnthony Stokes
947
asked 7 hours ago
Anthony StokesAnthony Stokes
947
asked 7 hours ago
Anthony StokesAnthony Stokes
947
947
add a comment |
add a comment |
4 Answers
4
active
oldest
votes
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
answered 6 hours ago
smillersmiller
2,229217
The conditional statement is the solution I was looking for.
– Anthony Stokes
6 hours ago
add a comment |
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
answered 7 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
6 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
6 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
6 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
5 hours ago
1
I didnt know of find and replace, nice!
– BERA
4 hours ago
|
show 2 more comments
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)
edited 3 hours ago
PolyGeo♦
53.9k1781245
answered 4 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
3 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).
edited 3 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.
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
7 hours ago
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "79"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f317805%2fcopying-replacing-first-letter-in-column-of-attribute-table-in-arcmap-with-field%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
4 Answers
4
active
oldest
votes
4 Answers
4
active
oldest
votes
active
oldest
votes
active
oldest
votes
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
answered 6 hours ago
smillersmiller
2,229217
The conditional statement is the solution I was looking for.
– Anthony Stokes
6 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
answered 6 hours ago
smillersmiller
2,229217
The conditional statement is the solution I was looking for.
– Anthony Stokes
6 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
answered 6 hours ago
smillersmiller
2,229217
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
answered 6 hours ago
smillersmiller
2,229217
answered 6 hours ago
smillersmiller
2,229217
answered 6 hours ago
smillersmiller
2,229217
answered 6 hours ago
smillersmiller
2,229217
2,229217
The conditional statement is the solution I was looking for.
– Anthony Stokes
6 hours ago
add a comment |
The conditional statement is the solution I was looking for.
– Anthony Stokes
6 hours ago
The conditional statement is the solution I was looking for.
– Anthony Stokes
6 hours ago
The conditional statement is the solution I was looking for.
– Anthony Stokes
6 hours ago
add a comment |
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
answered 7 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
6 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
6 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
6 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
5 hours ago
1
I didnt know of find and replace, nice!
– BERA
4 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
answered 7 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
6 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
6 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
6 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
5 hours ago
1
I didnt know of find and replace, nice!
– BERA
4 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
answered 7 hours ago
HornbyddHornbydd
27.1k32957
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
answered 7 hours ago
HornbyddHornbydd
27.1k32957
answered 7 hours ago
HornbyddHornbydd
27.1k32957
answered 7 hours ago
HornbyddHornbydd
27.1k32957
answered 7 hours ago
HornbyddHornbydd
27.1k32957
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
6 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
6 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
6 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
5 hours ago
1
I didnt know of find and replace, nice!
– BERA
4 hours ago
|
show 2 more comments
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
6 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
6 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
6 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
5 hours ago
1
I didnt know of find and replace, nice!
– BERA
4 hours ago
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
6 hours ago
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
6 hours ago
1
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
6 hours ago
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
6 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
6 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
6 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
5 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
5 hours ago
1
1
I didnt know of find and replace, nice!
– BERA
4 hours ago
I didnt know of find and replace, nice!
– BERA
4 hours ago
|
show 2 more comments
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)
edited 3 hours ago
PolyGeo♦
53.9k1781245
answered 4 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
3 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)
edited 3 hours ago
PolyGeo♦
53.9k1781245
answered 4 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
3 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)
edited 3 hours ago
PolyGeo♦
53.9k1781245
answered 4 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.
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)
edited 3 hours ago
PolyGeo♦
53.9k1781245
answered 4 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 3 hours ago
PolyGeo♦
53.9k1781245
edited 3 hours ago
PolyGeo♦
53.9k1781245
edited 3 hours ago
PolyGeo♦
53.9k1781245
53.9k1781245
answered 4 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 4 hours ago
Jackson DunnJackson Dunn
192
answered 4 hours ago
Jackson DunnJackson Dunn
192
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.
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.
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
3 hours ago
add a comment |
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
3 hours ago
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
3 hours ago
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
3 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).
edited 3 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.
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
7 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).
edited 3 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.
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
7 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).
edited 3 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.
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).
edited 3 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 3 hours ago
PolyGeo♦
53.9k1781245
edited 3 hours ago
PolyGeo♦
53.9k1781245
edited 3 hours ago
PolyGeo♦
53.9k1781245
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
answered 7 hours ago
Jackson DunnJackson Dunn
192
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.
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.
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
7 hours ago
add a comment |
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
7 hours ago
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
7 hours ago
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
7 hours ago
add a comment |
Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f317805%2fcopying-replacing-first-letter-in-column-of-attribute-table-in-arcmap-with-field%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
