Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [regular-expression]

The tag has no usage guidance.

0
votes
1answer
103 views

ArcGIS Data Reviewer Regular expression to limit the number of characters (Text Length) in a field

Using ArcGIS Data Reviewer on top of ArcMap 10.5, I am trying to write a regular expression in table checks that will only allow 5 characters or Less in a field otherwise the value should be ...
3
votes
0answers
80 views

Grouping and sorting a list of equipment using an aggregate function in the print composer

I'm using QGIS as a spatial database for a construction site and we are now checking the installed equipment. The inspection requires us to have a list of the equipment ID to inspect for each type of ...
2
votes
1answer
148 views

How to clean data in attribute table in QGIS 2.18.14?

I have a 'name' field with composite name; numbers and words e.g. "1237, Café" I managed extract the part number with Field Calculator and make a new field (see 1) with this expression left( "...
3
votes
3answers
199 views

Regular expression to extract road labels from OSM other_tags ref

Extended question to the issue: Regular expression substring for labelling The answers I've found on the link above were fine for "simple" road labels. Unfortunately, I don't have a big SQL-...
6
votes
3answers
736 views

Using degree symbol in Label Expressions of ArcMap? [closed]

I am trying to use the labeling process to display latitude and longitudes for a set of data points. To make the labels appear formal, I wish to add the degree symbol (°) to the labels. My python ...
1
vote
1answer
68 views

Postgis Query to join based on two individual table to matching two individual table with value being seperated by 'comma" in both table

I have polygon(properties) in postgis table and have a info of excel which need to join on posting table property. But it's not simple join it based on two column with matching individual column with ...
4
votes
1answer
266 views

Regular Points for interpolation

I want to create a windmap. So I created a csv with coordinates with values for wind speed and direction, these represent my weather stations. I loaded the csv up in QGIS and marked a station. Then I ...
0
votes
1answer
1k views

How can I convert a UNIX timestamp to a datetime format within the GeoEvent extension?

I assume that this can only be done with the use of a Field Calculator processor. However, there is little documentation about how to insert functions and about date- and time transformation in ...
4
votes
1answer
922 views

What regular expression engine does QGIS use?

Where can I find the documentation about QGIS regular expression engine and how to craft a pattern with it. I see the following regex functions documented regexp_replace regexp_substr regexp_matches ...
2
votes
1answer
551 views

Regular expression substring for labelling

I downloaded OSM .pbf raw data for Germany. Right now I'm trying to create label badges for german highways. German highways have names starting with the letter 'A' followed by a number with up to ...
0
votes
1answer
144 views

Data Reviewer Regular Expression for HHMM time format

I am using Data Reviewer to check to see if a string field is in the time format HHMM using the regular expression check. I think I have the correct logic with this: ^([0[0-9]|1[0-9]|2[0-4])[0-5][0-9]...
5
votes
1answer
989 views

Replace non-ASCII characters in QGIS Field Calculator

I want to replace all non-standard characters from fields in a dbf table in QGIS. From https://stackoverflow.com/questions/20078816/replace-non-ascii-characters-with-a-single-space I see we can use ...