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?
How can saying a song's name be a copyright violation?
Doing something right before you need it - expression for this?
How much of data wrangling is a data scientist's job?
Can one be a co-translator of a book, if he does not know the language that the book is translated into?
A reference to a well-known characterization of scattered compact spaces
Can a virus destroy the BIOS of a modern computer?
1960's book about a plague that kills all white people
Why is Collection not simply treated as Collection<?>
Alternative to sending password over mail?
What is going on with Captain Marvel's blood colour?
How to take photos in burst mode, without vibration?
Stopping power of mountain vs road bike
Does casting Light, or a similar spell, have any effect when the caster is swallowed by a monster?
Why is consensus so controversial in Britain?
Is "remove commented out code" correct English?
Why can't we play rap on piano?
Why doesn't H₄O²⁺ exist?
Is it legal for company to use my work email to pretend I still work there?
Etiquette around loan refinance - decision is going to cost first broker a lot of money
Facing a paradox: Earnshaw's theorem in one dimension
Reserved de-dupe rules
What's the difference between 'rename' and 'mv'?
Python: return float 1.0 as int 1 but float 1.5 as float 1.5
Will google still index a page if I use a $_SESSION variable?
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 6 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
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
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
6 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');
);
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 6 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
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
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 6 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
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
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 6 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 6 hours ago
HornbyddHornbydd
27.1k32957
answered 6 hours ago
HornbyddHornbydd
27.1k32957
answered 6 hours ago
HornbyddHornbydd
27.1k32957
answered 6 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
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
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
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
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
5 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
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
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
6 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
6 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
6 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
6 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
6 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
6 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');
);
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');
);
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');
);
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');
);
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
