Questions tagged [leading-zero]
are zeros (0) used to fill a field that do not increase the numerical value of the data, e.g. for 5: 05, 005, etc.
13
questions
0
votes
0
answers
21
views
Fomat Widget Expressions in QGIS
I want something basic; like I do in excel or access. The user enters a value and excel formats it. If it's a phone number and I want it in '####-#######' format; or if it is a number and I want to ...
- 11
1
vote
1
answer
286
views
Adding leading zeros to string value in QGIS [duplicate]
I have a "field" with string values like
field
new field
3
0003
5
0005
22
0022
999
0999
What is the right expression for the QGIS Field calculator to get a 4-character string-field ...
- 1,903
7
votes
4
answers
808
views
Removing leading zero from string in QGIS
How can I in QGIS through Expression calculator remove leading zeroes i.e. the 0 leading from a string?
Original_Value
New_Value
09
9
0150
150
09850
9850
054a23
54a23
5837
5837
Something like ...
- 1,054
1
vote
1
answer
230
views
Coordinates with leading zeros ignored in QGIS [closed]
I am using Irish national Grid (EPSG: 29902) with X and Y coordinates. Some coordinates start with leading '0's. Example: X= 081800 Y=339700. When imported in to QGIS, the leading zero of the ...
- 11
3
votes
3
answers
2k
views
Keeping leading zeroes in QGIS in big files
I am trying to load a file with many columns into QGIS. With both .txt and .csv format the leading zeroes of some data values get lost. However, I need the leading zeroes to merge the file with a map.
...
- 311
10
votes
4
answers
4k
views
Getting ArcGIS to include leading zeros in text field
I am entering characters in a text field that is essentially a 5 number "ID". I need leading zeros to be included in the value, but every time I enter or calculate the field, the leading ...
- 103
5
votes
2
answers
1k
views
Map places with ZIP codes that have leading zeros using CartoDB
I have a large set of data that has several places on the East coast that have leading Zeros in the ZIP. How do I map these when leading zeros are automatically removed?
- 53
2
votes
2
answers
9k
views
Removing leading zeroes (0) when labelling in ArcGIS Desktop
I am trying to do a simple labelling exercise however bit confused how to on how to remove unwanted '0' values.
I have field with road number displayed like: 0000647, 000652, 0000000236
I would like ...
- 21
2
votes
1
answer
2k
views
Removing zeros in string at different places with QGIS Field Calculator
I'd like to take the values from the "MAP_PAR_ID" attribute and populate a new field without zeros (including leading zeros) in that field, e.g.:
MAP_PAR_ID
New_Field
0160011000
16-11
...
- 2,044
12
votes
2
answers
6k
views
How to format labels with leading zeroes?
I'm trying to display a number next to a symbol in QGIS 2.0.1 - The numbers are from an integer-field in a PostgreSQL database.
The goal is that single digit numbers get a leading 0 (zeros). Examples:
...
- 1,163
8
votes
3
answers
4k
views
Converting numeric fields into strings with leading zeros
I'm trying to define an action in QGIS using on of my fields but I have some problems with its format.
I have a numeric string like '5' and I need to have a format like '005'. I've tried function ...
- 115
3
votes
6
answers
19k
views
Adding "0" to front of all values in column using ArcGIS Field Calculator
In ArcInfo 10.1 I have a table for each state with Zip Code values. The 5-digit Zip Codes that start with "0" have been reduced to 4-digits. I cannot figure out how to add a "0" to ...
- 6,876
5
votes
4
answers
6k
views
Concatenating numbers and adding in leading zeros
I have three text fields populated as follows: 1, 9, 1 that I need to concatenate into a field that looks like 01.09.01. Getting to 1.9.1 is easy but can anyone help out with how to formulate it so ...
- 51