Questions tagged [wildcard]

A wildcard character is a character that can substitute for one or more other characters.

Filter by
Sorted by
Tagged with
13 votes
3 answers
13k views

Using multiple wildcard parameters with arcpy.ListFeatureClasses

I know there has to be a way to do this but I'm having trouble figuring out how to do so. I would like to create a list of feature classes to perform operations on however, I want to have the list ...
standard's user avatar
  • 622
10 votes
2 answers
1k views

Using wildcards for column headers in QGIS Field Calculator?

I know you can use wildcards for fields like so (in the Field Calculator): case when "column" ILIKE '%example%' then 1 else 0 end Can you do something similar for the column headers themselves? I ...
Joseph's user avatar
  • 75.6k
5 votes
1 answer
5k views

Selection by attribute string with wildcard as part of name in ArcGIS Desktop?

I have an attribute field in my file geodatabase (GDB) where I'm trying to select all records that contain an underbar in the string field. The issue is that the underbar is considered a SQL wildcard ...
M.Smith's user avatar
  • 158
4 votes
1 answer
2k views

Using wildcard for field names of ArcPy Search Cursor?

How would you wildcard the field_names for a SearchCursor so that it only searched through rows for columns in a table that begin with the word "Layer"? For example: FCList = [] FCS = [u'Building', u'...
DanMilRiv's user avatar
  • 109
4 votes
1 answer
691 views

Iterative merging of .shp per folder through multiple folders using ArcGIS Pro ModelBuilder

In ModelBuilder for ArcGIS Pro, I'm trying to create an iterative model for merging pointfiles according to their names. This is a pre-processing step to handle echo-soundings, spread over one or ...
gydemov's user avatar
  • 63
4 votes
1 answer
1k views

Iterate over feature classes with multiple wildcards

Is there a way how to iterate over feature classes in Model Builder in ArcGIS 10.3 using a number of different wildcards? The wildcards I want to use are strings in the middle of the feature class ...
marquetca's user avatar
3 votes
1 answer
3k views

Using multiple wildcards within iterator of ArcGIS ModelBuilder?

I would like to know if it is possible to use multiple wildcards to select specific shapefiles when using the Iterate Feature Classes tool in ArcGIS ModelBuilder. I use this to select all shapes ...
JPD's user avatar
  • 1,658
2 votes
1 answer
626 views

Combining wildcard command along with %s in where clause statement for ArcPy?

I am trying to write a script where the user can search for a five digit zipcode using an input statement and a search cursor. The zipcodes in the file though are nine characters long (i.e. xxxxx-xxxx)...
Cara's user avatar
  • 147
2 votes
1 answer
9k views

CQL_FILTER not liking '%' wildcards

I am setting up a query against a layer on my GeoServer instance. My query string can become quite complex, and some statements require using multiple '%' wildcards. For starter's here's an example: ...
evv_gis's user avatar
  • 3,200
2 votes
1 answer
373 views

Wildcard for field in arcpy.GetParameterAsText

I have this parameters for my python script: import arcpy Layer1 = arcpy.GetParameterAsText(0) Tabela1 = arcpy.GetParameterAsText(1) Estado = arcpy.GetParameterAsText(2) Ano = arcpy....
vcruvinelr's user avatar
2 votes
1 answer
143 views

Using wild cards in GRASS to remove files

I have a bunch of files on a GRASS location, all named temp_something, that I want to delete. I tried to use the g.remove tool using the multiple option and typing temp* in, but it doesn't work out, ...
sig_renato's user avatar
2 votes
1 answer
64 views

When calculating a field in an attribute table, how can I find one value out of many fields when every other field has a null value?

I have 4,018 rows of data with about 50 fields. About 45 of those fields are the same variable, but the data came from different layers, so out of those 45 fields, only one has a value for the row, ...
Jared's user avatar
  • 23
2 votes
1 answer
2k views

Documentation on wildcard syntax, such as for use in arcpy.ListFeatureClasses()?

I was wondering if anyone knew where I could find some documentation on proper syntax for use of wildcards in arcpy, such as with the ListFeatureClasses function? I have been unable to locate any ...
moosology's user avatar
2 votes
1 answer
536 views

Parsing for numeric and character wildcards in a QGIS query

In an attribute table with a land use shapefile in my QGIS project there are complex combinations of numeric and alphabetic character. I wish to filter for a simple combination of numeric wildcards ...
Ecofuego's user avatar
2 votes
1 answer
171 views

Modelbuilder - iterate consecutive workspaces and select specific rasters from each

This is probably easiest explained with a picture, I'm trying to iteratively perform a calculation using specific rasters from each two consecutive folders in a folder. For example from above picture,...
Grasshopper's user avatar
2 votes
2 answers
817 views

Using wildcard argument with ArcPy?

I have a python code I'm running in ArcGIS 10.6 that replaces the data source path of all layers in the mxd with a new path. I'm trying to use a wildcard for the current workspace path as many layers ...
AJC's user avatar
  • 93
2 votes
2 answers
138 views

QuickOSM using wild cards on lines (rivers)

I'm trying to find all rivers with a name containing specific word (or part of it). F. ex. all 'Danube-' rivers, or 'Danu-', 'Dan-' and so. In another topic I've found useful query, which after ...
zero signal's user avatar
2 votes
1 answer
647 views

Iterating rasters in ModelBuilder - wildcard does not seem to work?

I've got some problem with the model below. I want to extract rasters from sde geodatabase, use one parameter from Copy Raster, and then export it to specified folder with preserved names as an ...
HFC's user avatar
  • 21
2 votes
0 answers
2k views

How to use CQL_FILTER as URL encoded parameter to compare a field containing numbers

I want to apply the CQL_FILTER parameter as an URL parameter in order to filter a field containing numbers (zip codes) starting with 79 (using 79% Wildcard) for instance. So I'm using this CQL_FILTER:...
Marcel Gangwisch's user avatar
2 votes
0 answers
101 views

Comparing columns in ArcMap with wildcard statement? [closed]

I need to compare a street centerline name column to a parcel centroid column that holds the street address. I would like to use a wildcard search so that I can match them by the street name despite ...
Scoobydoo's user avatar
1 vote
1 answer
160 views

Wildcard, number of characters (arcpy) [closed]

Is there any way to create a list based on the number of characters of the files? My current list goes like that rasterList = arcpy.ListRasters("*speed*","TIF") My files are speed01 speed02 ..... ...
GeoF's user avatar
  • 391
1 vote
1 answer
104 views

Using wildcard condition to find mean value from table in ArcPy?

I have a feature class with 20 fields and 13 of them have datas from year 2003 to 2015. I create a new field named 'mean' which will calculate the mean value only for the values from 2003 to 2015. All ...
vcruvinelr's user avatar
1 vote
2 answers
808 views

Using wildcard to represent specific number of characters in ArcPy?

I have a bunch of feature classes that are labeled in this pattern CL25_E6_5_4_3 CL266_E6_5_4 CL266_E6_5_4_2 CL4_E6_5 I want to make a list in ArcPy that contains all feature classes with the ...
Calavin's user avatar
  • 869
1 vote
1 answer
527 views

Reclassifying field using Python wildcard string search?

I have a point layer with 900K Tree Point records. In that layer I have field (d_Species) that contains the tree species of each record. I've created a field (SpecieValu) to assign a value (0-3) for ...
Kurt Cederholm's user avatar
1 vote
1 answer
125 views

Selecting attributes for field calculator by common name

I am trying to automate some of my GIS processes and have come across a snag in my automation. I am trying to understand the percent coverage of my suitability raster layer with my town boundaries ...
Adam 's user avatar
  • 43
1 vote
1 answer
390 views

Using a wildcard in an elif statement in pyscript...?

I’m trying label up a blank field with ‘yes’ or ‘no’ to the presence of names with either the word ‘Estuary’, ‘Loch’, or ‘Firth’ using * as a wildcard, in Field Calculator. I think I'm getting mixed ...
Cheekychives's user avatar
1 vote
1 answer
3k views

Using wildcard to select field by suffix and do a condition (endswith)

With this validation I get the fields from my active Layer and put into the parameter after select the layer if self.params[0].value: self.params[1].filter.list = [f.name for f in arcpy.ListFields(...
vcruvinelr's user avatar
1 vote
2 answers
471 views

Merging raster data in QGIS using wildcards

I have a problem merging raster data sets in QGIS, and I have searched various forums, but have not found a solution yet. An "ordinary" merge, for example merging the raster files ...
André Große-Stoltenberg's user avatar
0 votes
1 answer
1k views

Using wildcards to work around GDAL character limit

I am attempting to use the 'Merge' & 'Create VRT' tools in QGIS 2.0 on a folder with 3000+ raster tiles in. However whenever I try to perform this operation the following error appears: The ...
Canningmister's user avatar
0 votes
2 answers
94 views

Monthly statistics based on raster file name

I have a raster of a national park in Norway showing the temperature every day between the 1st of November 1999 and the 31st March 2015. I have created booleon images showing which pixels are above ...
user3652893's user avatar
0 votes
2 answers
2k views

Using wildcard within ArcGIS ModelBuilder to select raster files?

I already checked (almost) all other related topics I was not able to figure out how to solve my problem. I want to process certain rasters in many different subfolders. Within these folders I have ...
Franz's user avatar
  • 13
0 votes
1 answer
12k views

How to use wildcards for characters inside the name [closed]

I have shapefiles in that form RCs4s3s2c10_S2C10 RCs4s3s2c20_S2C20 RCs4s3s2c30_S2C30 RCs4s3s2c40_S2C40 RCs4s3s2c50_S2C50 RCs4s3s2c60_S2C60 RCs4s3s2cb_S2CB RCs4s3s2c10_1_S2C10 RCs4s3s2c20_1_S2C20 ...
Konstantin's user avatar
0 votes
1 answer
128 views

Wildcard star not working in GDAL 3.3.3

Using GDAL 3.3.3 on my windows 10 workstation I cannot use the wildcard *. With my old windows 7 workstation I used to be able to include the wildcard to search for all tiff files in a directory by ...
Robert Buckley's user avatar
-1 votes
1 answer
2k views

How to use a wildcard for a field to sort many shp

I want to use a wildcard for a field so as to sort a group of shapefiles. All of them have the same columns but there is one column in each of them with only the first 4 characters common. Is ...
Konstantin's user avatar