Questions tagged [string]
A sequence of characters.
-2
votes
0answers
11 views
insert data into postgres table getting Array to string conversion php [closed]
Array to string conversion in C:\xampp\htdocs\letsstart\first_php.php on line 37
INSERT INTO public.metadata_xml( namedataset, nametheme, keywords, accessconstrain, userconstrain, purpose, datatype, ...
2
votes
3answers
72 views
Batch rename MODIS data?
I have MOD13Q1 NDVI images. Data are named in this format:
MOD13Q1.A2007049.h26v06.006.2015161224938_MODIS_Grid_16DAY_250m_500m_VI.tif
(YYYYDDD) Here 2007 is a year and 049 is day in year.
I ...
1
vote
0answers
32 views
String slicing in ArcMap dynamic text element
Is it possible to slice a string in ArcMap's HTML-like dynamic text elements?
I've got a string field "Code" with contents like 'A.3.5', I need to extract the number in the middle ('3' in this case). ...
1
vote
1answer
35 views
Creating drop-down list from dynamic field values in ModelBuilder?
I am trying to create a drop-down list containing all the values from a particular field, that I can use as an input for the Select by Attributes tool in ModelBuilder.
The answer I’ve seen to ...
0
votes
1answer
23 views
Map.addLayer automation
As in the Hillshade Example, I wanted to automate adding all Layer from one Image for visual inspection.
var band_names =Image.bandNames()
print(ee.String(band_names.get(0)))
for (var i = 0; i < ...
0
votes
1answer
31 views
.bandnames() as String
var bandname = ee.String(ee.ImageCollection.first().bandNames())
gets a print of:
using
ee.Image.regexpRename(bandname, new_name)
or using
var bandname = ee.String(bandname)
results in :
...
0
votes
2answers
38 views
String Formatting;-Calling values from a dictionary to select by attribute in fc
New to python. In the code below, I create a dictionary b={} and wish to call keys to select by attribute. All goes well until I am required to format strings to come up with whereclause. I am ...
3
votes
2answers
66 views
FME geometry conversion from string?
I have an xlsx file that has incorrect X, Y location. Essentially the false northing is out 5000000 and there's no decimal point. As you can see in the image below the current file format is on the ...
1
vote
1answer
78 views
Selecting multiple values from a string in ArcMap?
I have a text field containing values like "1A,2P,13,17,22,34".
I want to select the values that I need by a definition query of a layer.
For a single value worked using LIKE and % but I need to ...
4
votes
2answers
430 views
How to extract a part of string from fields in QGIS field calculator?
I want to create a new field in my attribute table. My goal: returning all digits between the / and _ characters of the field named "location" by applying the next expression:
regexp_substr( "Text", ...
0
votes
1answer
41 views
Dataset '{}' does not exist or is not supported in arcpy
I am trying to insert some variable into a simple arcpy call using .format(var1, var2) as I would in a string. I am new to using Python 3.6, so maybe there's been some change in how this is done. When ...
1
vote
1answer
35 views
Python Labelling in ArcGIS - Two Languages one string
I am trying to format a label in two languages in a way they appear on one line and not stacked in ArcGIS any ideas? Maplex Stacked label feature is not ticked so this does not help.
This is how they ...
0
votes
0answers
17 views
Return records with specific numbers/characters on right most side of string using select by attributes [duplicate]
I have a field called TripID that I want to use the select by attributes to return all records within TripID that end in 01 and 02 only and leave the others. What code should I use to return these ...
0
votes
2answers
778 views
Changing string to integer using ArcGIS Field Calculator?
I have a table with two fields. One field (type short) is empty. One field (type string) is full of digits. There are no random characters in that field, just digits. I want to convert the string ...
3
votes
2answers
77 views
If any of B contains all of A, then count # of times A is in all of B
BACKGROUND: Long time reader, first time poster. Looking for help using QGIS to score data in a CSV table that was yielded from processing the contiguous neighbors of every polygon from a file with ...
1
vote
0answers
264 views
Edit Field Name In Attribute Table (QGIS 3) [duplicate]
This seems like such a simple task, yet after researching how to execute it in QGIS I've been unsuccessful. I'm merely trying to rename columns in my attribute table. My existing field is currently ...
2
votes
1answer
52 views
split attribute using ArcGIS Field Calculator
I have a long string in one attribute. I want to be able to extract a small portion of it into a new attribute.
This is an example of the attribute:
"< html xmlns:fo="http://www.w3.org/1999/XSL/...
0
votes
1answer
225 views
If-then-else Statements and string errors?
I'm defining a string field based on contents of another string field.
Simply put, if the contents of field A contain this value, then fill field B with this text.
It throws a string related error ...
1
vote
2answers
242 views
Comparing string values in field calculator
I am trying to compare the values of 2 fields in my attribute table and update a 3rd field as a result. In the field calculator I have
CASE when (("Address") like ("COUNTYNAME" )) then 'Match'
...
0
votes
1answer
58 views
carto /cartocss : is there a function for “contains”?
I know how to set a specific color for a specific value (here specific_string) of a specific field (here field1)
#mydataset[field1="specific_string"] {
marker-fill: #000000;
But what if I want to ...
1
vote
3answers
508 views
What is the limit to a column (field) title string in ArcMap?
Is the column heading limited to 10 characters?
Is there a workaround besides changing the alias?
I hear that QGIS does not have this issue.
I downloaded shapefile data from https://egis-hud....
1
vote
0answers
99 views
Converting @layer_name tokens into Shapefile Attributes (Columns/Rows) using QGIS Expression Editor?
I'm a fairly novice Python user and I've been banging my head against this problem for a number of days now.
Assumptions I've made:
This is doable within QGIS, and does not need to be done ...
1
vote
0answers
440 views
Converting table asset data type from 'Long' to 'String'
I am attempting to generate 50 random points per land use class through Google Earth Engine. I have performed this operation before on an earlier instance, where the inputs were the following
(1) ...
2
votes
1answer
32 views
Using Field Calculator to correct the nomenclature of APN values
I am currently working (in ArcMap 10.4) with two datasets that use different nomenclature for their assessor parcel numbers (APN) values. In one dataset the APN is a string dataset with the format "...
0
votes
0answers
34 views
File Geodatabase: storing text in an integer field?
I recently downloaded a FGDB from NOAA at https://marinecadastre.gov/ais/
The FGDB contains a point feature class with ship locations. One of its attribute fields, named [Status], is of type Long ...
0
votes
1answer
100 views
Iterating field name in UpdateCursor?
I have a series of fields to check for a certain value, then calculate other fields with using UpdateCursor.
Fields are: SPECIES_CD_1, SPECIES_CD_2, etc.. up to SPECIES_CD_99
Here is the general ...
0
votes
0answers
19 views
Trouble with Tigerfiles, fields come in as string and not as integer?
I am trying to do something simple like make a choropleth map of poverty ranges, but when I bring the csv file into qgis, all the fields come in as string and I can't do any analysis on those ...
1
vote
0answers
50 views
Attribute table reformatting fields on programme close
I'm creating a density map using the graduated style in qgis. The data is created from the points in polygon tool, this is then saved as an integer (not sure why the plugin doesn't automatically do ...
0
votes
0answers
131 views
Add a string to a cell using graphical modeler
I want to add a new string to a shapefile using the Graphical Model Builder.
This would then request a string input (Such as "Address line 1") then add this to the attribute table in the shapefile.
...
1
vote
1answer
199 views
Remove first character from a string if it satisfies an if statement [closed]
I have a bunch of phone numbers and some contain a 1 in front of them e.g. "18885556607" and I would like to simply remove the 1. I can't just remove all first characters because there are numbers ...
4
votes
2answers
638 views
Extracting only number from address in QGIS Attribute Table
I want to print only the number part of the address field. I tried to use the "field calculator" with "regexp_substr" to extract just the number (only string before the first space) but couldn't ...
1
vote
1answer
235 views
ArcGIS query “dash” character multiple times in a string & replace/remove dash
Using ArcMap 10.2.2 and have a string field in an attribute table that has values such as:
xxxx-xxxx-x
xxxx-xxxx-x
xxxx-xxxx-x
xxxx-xxxx
xxxx-xxxx
xxxx-xxxx
I want to query for all records that have ...
5
votes
1answer
136 views
Test for (curly) brackets in expressions in QGIS 2.14.14 with strpos() weird results
When trying to find a strpos() of a substring containing curly brackets (or brackets anyway as far as I can see) I get 0 as a result.
Test for substring without {} works fine:
Test for substring ...
1
vote
1answer
798 views
Removing n first digits on a field attribute table using QGIS string functions
I'm looking for a QGIS function to remove the first n digits on a field attribute table using QGIS string function.
For exemple I have the following string in a QGIS attribute table:
742-004-SRV ...
1
vote
2answers
2k views
How do I convert a STRING to a Real? [duplicate]
So I am trying to join some data I have (just numbers) to a map on QGIS.
However it when I try to join the data to map it shows up as a string instead of a real.
It's a just a normal exel file. I ...
3
votes
1answer
67 views
Populating new field based on existing string field using ArcGIS Field Calculator?
My programming is really rusty at this point, and I am trying to do a simple calculation using a Codeblock, either VB or Python is fine. I have tried about 50 different variations on same theme, and ...
1
vote
0answers
82 views
Moving substring from end to beginning of string
Disclaimer: I'm very new to QGIS and using expressions.
I have a large data set that contains a time range (00:00-00:00) and 1-6 three-day abbreviations of days of the week (MON, TUE, WED, etc.). I ...
1
vote
1answer
91 views
How to fix Excel/Arcmap “data type mismatch” error?
I've had a polygon shapefile joined to an XLS file with no issue until today. Although the category of the column category is designated as "Number" in Excel, ArcMap recognizes the column as "String" ...
4
votes
4answers
114 views
Finding only records with numbers in a character string field?
I need to isolate those records containing numbers from a field with character string (it's a descriptive field). For example the string might be as follows:
"A residential development of 12 no. ...
1
vote
1answer
223 views
Searching value in string and replacing it with double quotes in ArcPy?
Adds a new field Match_PINCODE
Searches for a 6digit number in a string from Address field like "aaaaa,dsjfhdjfhd768543"
set "Match_PINCODE" field with the 6digit row by row.
Replaces 6digit number ...
2
votes
1answer
242 views
Using Field Calculator to assign consecutive letters for each feature?
I have a feature class generated in ModelBuilder using a transect script that contains multiple transects. Before moving on to further build the survey I would like to assign ID's to each feature in ...
9
votes
1answer
877 views
Obtaining specific part of string from field in QGIS attribute table?
I'm having a bit of trouble here with this situation.
I want "NumeroCamp" only to have the numbers are showing in "Text".
Is there any function in field calculator that could help me with that?
2
votes
2answers
341 views
Fixing address errors using Python Parser of ArcGIS Field Calculator?
I am working on a task that will calculate a field to fix errors stemming from the Standardize Addresses tool and human error with the input data.
The script is below. I'm getting Error 000989 "...
0
votes
3answers
54 views
Stop srcipt working if more than one value are selected
I have a script tool which has string mulivalue paparameter with a filter list.
For example in this case I want to stop script working after it detect that not only "AAA" parameter is selected but ...
1
vote
0answers
34 views
Why increasing decimal points not working for XY point features with sufficient precision length? [closed]
I am working with ArcMap 10.3.1 on a Lenovo ThinkPad (Windows 10). I want to display and copy x-y field values with more decimal positions (from 5 to 8; i.e. 34.3456 to 34.34561739), but after ...
2
votes
3answers
64 views
Query where one field includes the text string in another field
I am trying to query mailing address records that match physical address records, but the two fields sometimes have data in a different format. For example, the property's mailing address may be ...
2
votes
2answers
170 views
Stop script working after two specific values are selected
I have a script tool that runs after values from multivalue box are selected.
The code is okay and runs withou any mistakes.
But is it possible to make a kind of exception for selection of fields ...
4
votes
1answer
243 views
Decimal place in ArcGIS 10.3
In this attribute table, "DISTANCE" field name created with this python expression (in Field Claculator):
str( !Shape_Leng! ) + !field_name!
Everything works fine.
But I seek a way to get on 1 ...
2
votes
1answer
98 views
String output as an input dataset variable
I have a model which creates topology with rules and validate itself.
But I got used to working with layers in TOC and have a script in Calculate value tool that with a help of Parse path tool make a ...
2
votes
3answers
285 views
Sorting string column Qgis
I would like to order my field like "normal" but as this column is string it won't work.
I got "Emplacement réservé 105";"Emplacement réservé 106"; .... before "Emplacement réservé 20".
What should ...
