Change to uppercase all tables dataHow to join data in postgis tables to form layer with subset of attributesQGIS Raster Calculator: Need values to be set to 0 instead of no dataQGIS Vector Data with blank attribute tablesGetting layers to html with mouseover for all layers?How to open and save QGIS datasource with/to lower case fields?Using Title Case on Everything Except Last 2 CharactersUpdating attribute field with random string valueJoin Multiple Tables to a Spatial Map without using DatabaseExpression to change an attribute each X number of rowsSQL query : finding a word in a shapefile
Can the Conjure Barrage spell stack with the Disarming Attack or Trip Attack Battle Master maneuvers?
To exponential digit growth and beyond!
How to eliminate gap at the start and at the end of a line when it's drawn along a side of a node's bounding box?
What all did Brienne write about Jaime?
regarding the latex for this probabilistic formula
How many wires should be in a new thermostat cable?
How to tease a romance without a cat and mouse chase?
How do I write real-world stories separate from my country of origin?
Why is this python script running in background consuming 100 % CPU?
Is it normal to "extract a paper" from a master thesis?
How to become an Editorial board member?
Why do testers need root cause analysis?
Why did Drogon do this?
Salesforce bug enabled "Modify All"
One word for 'the thing that attracts me'?
Is there an idiom that means that you are in a very strong negotiation position in a negotiation?
Is there a word for pant sleeves?
Goldfish unresponsive, what should I do?
What is this dime sized black bug with white on the segments near Loveland Colorodao?
Team member is vehemently against code formatting
Keeping the dodos out of the field
Is the default 512 byte physical sector size appropriate for SSD disks under Linux?
A nasty indefinite integral
Ratings matrix plot
Change to uppercase all tables data
How to join data in postgis tables to form layer with subset of attributesQGIS Raster Calculator: Need values to be set to 0 instead of no dataQGIS Vector Data with blank attribute tablesGetting layers to html with mouseover for all layers?How to open and save QGIS datasource with/to lower case fields?Using Title Case on Everything Except Last 2 CharactersUpdating attribute field with random string valueJoin Multiple Tables to a Spatial Map without using DatabaseExpression to change an attribute each X number of rowsSQL query : finding a word in a shapefile
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I have 190 layers in shape file with attribute filled in lower case. I want to change data of all tables in uppercase using Qgis.
I am able do to do it one by one using upper in expression.
How to do for all layers in one go?
qgis qgis-3
asked 1 hour ago
Sachin KumarSachin Kumar
15012
add a comment |
I have 190 layers in shape file with attribute filled in lower case. I want to change data of all tables in uppercase using Qgis.
I am able do to do it one by one using upper in expression.
How to do for all layers in one go?
qgis qgis-3
asked 1 hour ago
Sachin KumarSachin Kumar
15012
add a comment |
I have 190 layers in shape file with attribute filled in lower case. I want to change data of all tables in uppercase using Qgis.
I am able do to do it one by one using upper in expression.
How to do for all layers in one go?
qgis qgis-3
asked 1 hour ago
Sachin KumarSachin Kumar
15012
I have 190 layers in shape file with attribute filled in lower case. I want to change data of all tables in uppercase using Qgis.
I am able do to do it one by one using upper in expression.
How to do for all layers in one go?
qgis qgis-3
qgis qgis-3
asked 1 hour ago
Sachin KumarSachin Kumar
15012
asked 1 hour ago
Sachin KumarSachin Kumar
15012
asked 1 hour ago
Sachin KumarSachin Kumar
15012
asked 1 hour ago
Sachin KumarSachin Kumar
15012
asked 1 hour ago
Sachin KumarSachin Kumar
15012
15012
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You need to use pyqgis to loop over all the field names to change their case to uppercase.
The following snippet can be used to change all field names in one shapefile into uppercase
uri = r"F:AhmadTestPTCities.shp"
vlayer = iface.addVectorLayer(uri, "cities", "ogr")
for field in vlayer.fields():
name = field.name()
with edit(vlayer):
idx = vlayer.fields().indexFromName(name)
vlayer.renameAttribute(idx, name.upper())
del vlayer
Before:
After running the code:
The above code was used inside QGIS 3.4.5 with pyqgis 3. If you want to loop over the 190 shapefile, you need to use os.walk().
answered 26 mins ago
ahmadhanbahmadhanb
24.5k32257
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%2f323273%2fchange-to-uppercase-all-tables-data%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You need to use pyqgis to loop over all the field names to change their case to uppercase.
The following snippet can be used to change all field names in one shapefile into uppercase
uri = r"F:AhmadTestPTCities.shp"
vlayer = iface.addVectorLayer(uri, "cities", "ogr")
for field in vlayer.fields():
name = field.name()
with edit(vlayer):
idx = vlayer.fields().indexFromName(name)
vlayer.renameAttribute(idx, name.upper())
del vlayer
Before:
After running the code:
The above code was used inside QGIS 3.4.5 with pyqgis 3. If you want to loop over the 190 shapefile, you need to use os.walk().
answered 26 mins ago
ahmadhanbahmadhanb
24.5k32257
add a comment |
You need to use pyqgis to loop over all the field names to change their case to uppercase.
The following snippet can be used to change all field names in one shapefile into uppercase
uri = r"F:AhmadTestPTCities.shp"
vlayer = iface.addVectorLayer(uri, "cities", "ogr")
for field in vlayer.fields():
name = field.name()
with edit(vlayer):
idx = vlayer.fields().indexFromName(name)
vlayer.renameAttribute(idx, name.upper())
del vlayer
Before:
After running the code:
The above code was used inside QGIS 3.4.5 with pyqgis 3. If you want to loop over the 190 shapefile, you need to use os.walk().
answered 26 mins ago
ahmadhanbahmadhanb
24.5k32257
add a comment |
You need to use pyqgis to loop over all the field names to change their case to uppercase.
The following snippet can be used to change all field names in one shapefile into uppercase
uri = r"F:AhmadTestPTCities.shp"
vlayer = iface.addVectorLayer(uri, "cities", "ogr")
for field in vlayer.fields():
name = field.name()
with edit(vlayer):
idx = vlayer.fields().indexFromName(name)
vlayer.renameAttribute(idx, name.upper())
del vlayer
Before:
After running the code:
The above code was used inside QGIS 3.4.5 with pyqgis 3. If you want to loop over the 190 shapefile, you need to use os.walk().
answered 26 mins ago
ahmadhanbahmadhanb
24.5k32257
You need to use pyqgis to loop over all the field names to change their case to uppercase.
The following snippet can be used to change all field names in one shapefile into uppercase
uri = r"F:AhmadTestPTCities.shp"
vlayer = iface.addVectorLayer(uri, "cities", "ogr")
for field in vlayer.fields():
name = field.name()
with edit(vlayer):
idx = vlayer.fields().indexFromName(name)
vlayer.renameAttribute(idx, name.upper())
del vlayer
Before:
After running the code:
The above code was used inside QGIS 3.4.5 with pyqgis 3. If you want to loop over the 190 shapefile, you need to use os.walk().
answered 26 mins ago
ahmadhanbahmadhanb
24.5k32257
answered 26 mins ago
ahmadhanbahmadhanb
24.5k32257
answered 26 mins ago
ahmadhanbahmadhanb
24.5k32257
answered 26 mins ago
ahmadhanbahmadhanb
24.5k32257
24.5k32257
add a comment |
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%2f323273%2fchange-to-uppercase-all-tables-data%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
