# Questions tagged [leading-zero]

78 questions

1

votes

1

answer

47

Views

### Format Numbers with possible leading zeroes in PHP

I'm having a hard time to figure out, how to format a range of number correctly.
Lets say I have an array with the following values:
array( 1, 2, 001, 02, 012 );
How can I change the output of each value to fit the following format?
0 => 1
1 => 2
2 => 0.01
3 => 0.2
4 => 0.12
I'm not looking for a lo...

1

votes

3

answer

48

Views

### Delete files from 00012 to 00441 using Terminal

This is my Bash version:
3.2.57(1)-release
I found that this MIGHT possible using terminal rm code, but it doesn't work for me
Here is a picture of the first files:
Picture of a bunch of Files
Typing rm _{00012..00441} I get this error:
Terminal Error
Seems like the code us unable to use the leading...

1

votes

4

answer

2.6k

Views

### How to print numbers in hex with leading zero

Is there a better method to display a number in hex with leading 0? I tried:
i.to_s(16)
but
2.to_s(16) #=> '2'
where I expect '02'. I tried the print format:
'%02x' % i
which works for 2, but
'%02x' % 256 #=> '100'
where I want '0100'. So I came up with this:
class Integer
def to_hex_string
('%0x'...

1

votes

1

answer

271

Views

### Convert uint32 to string and add leading 0s

I need to convert uint32 to a string and add leading zeroes to a fixed length. How can I do that?
Here's my code:
var unixTs uint32 = 1446455472
var randomInt uint32 = 58964981
var expiredTs uint32 = 2
unixTsStr := fmt.Sprint('%010d', unixTs)
randomIntStr := fmt.Sprint('%08d', randomInt)
expiredTsSt...

1

votes

1

answer

335

Views

### Leading zeros after exporting to csv from SQL query

I have a SQL script which outputs data to csv file. The script works fine however the leading zero is stripped from the phone number when I export to csv.
SQL:
SELECT RTRIM(Mobile_Telephone) AS Mobile_Number FROM TABLE
Datatype: char(20), not null
I am exporting data to csv using SSIS package
Can y...

1

votes

3

answer

77

Views

### Removing Leading Zeros Part 2

SQL Server 2012
I have 3 columns in my table that will be using a function. '[usr].[Udf_OverPunch]'. and substring.
Here is my code:
[usr].[Udf_OverPunch](SUBSTRING(col001, 184, 11)) as REPORTED_GAP_DISCOUNT_PREVIOUS_AMOUNT
This function works appropriately for what I need it to do. It is basically...

1

votes

1

answer

187

Views

### Return string with leading zeros in PHP

Similar to this unsolved question
My PHP output requires JSON_NUMERIC_CHECK enabled, however there is one string nick column in my database that needs to be returned originally as a string. Values in that column can contain numbers and there's no length restriction. Code example:
$response['players'...

1

votes

1

answer

0

Views

### Converting from HEX string to int without removing leading zeroes on Python

I need help on converting HEX string to int. I have a big data input, but,
Here's one example from the data:
def convert_hex_to_int(n:int, interval:int):
splitted = [hex(n)[2:][i:i + interval] for i in range(0, len(hex(n)[2:]), interval)]
return [float(int(hex(unpack('H', int(i, 16)))[0]), 16)) for...

1

votes

2

answer

62

Views

### Count or Return Leading 0's in PHP Regex

If I have
$num = '00000567';
I want to use PHP's preg match or split to split off the 0's so I can count them or count the 0's and have the regex return the variable. Can anyone help me out as the net have very few hits about leading 0's and mostly they're about removing them

1

votes

2

answer

87

Views

### Trimming leading zeros with regex

I'm struggling to get a regex expression to work.
I need to allow the following transforms based on the existence of leading zeros...
001234 -> 1234
1234 -> 1234
00AbcD -> AbcD
001234.1234 -> 1234.1234
001234.000002 -> 1234.2
001234/000002 -> 1234.2
I've found the expression matches works well for t...

1

votes

2

answer

1.2k

Views

### Create leading zero in Oracle

I am using Adempiere which has database Oracle
I have window called Stock Code from table called M_StockCode
The fields are Code and Description.
Currently, Code data type is Number and Description is Varchar2
I want to input Sparepart with Code 01, and Body Repair with Code 02.
As I input the data...

1

votes

2

answer

170

Views

### shell script to add leading zeros in middle of file name

I have files with names like 'words_transfer1_morewords.txt'. I would like to ensure that the number after 'transfer' is five digits, as in 'words_transfer00001_morewords.txt'. How would I do this with a ksh script? Thanks.

1

votes

1

answer

81

Views

### Looping zero-padded numbers in swift - Xcode

Under the SKSpriteNode class, you can do the following to animate an object
private func animate(){
var playerTextures:[SKTexture] = []
for i in 1...3 {
playerTextures.append(SKTexture(imageNamed: 'image00\(i)'))
}
let playerAnimation = SKAction.repeatActionForever(
SKAction.animateWithTextures(play...

1

votes

1

answer

67

Views

### Pythonic way to create list of address letter/numbers from an input address range like 1-12A

Simple case: For a given string input like '1-12A', I'd like to output a list like
['1A', '2A', '3A', ... , '12A']
That's easy enough, I could use something like the following code:
import re
input = '1-12A'
begin = input.split('-')[0] #the first number
end = input.split('-')[-1]...

1

votes

2

answer

290

Views

### Remove Leading Zeros Except last Zero

Database - SQL Server 2012
I am currently using the following code:
substring(
SUBSTRING(col001, 59, 8),
patindex(
'%[^0]%',
SUBSTRING(col001, 59, 8)
),
10
) as TOTAL_DETAIL_RECORD_COUNT
A lot of substrings, I know but it is working for the most part. There is one catch though. Some of the colu...

1

votes

2

answer

88

Views

### Remove leading zeros when reading a csv file

I have a CSV file that looks something like this -
Location ID Location Name
3543459 A
20541 B
C320 C
... ..
When I read the file using pd.read_csv, I get something like this -
Location ID Location Name
03543459 A
0020541 B
000C320 C
... ..
Ho...

1

votes

3

answer

1.5k

Views

### Printing leading zeros in a number in C [closed]

I'm working on a project and I want my program to read a strictly 5 digits number with a leading zero.
How can I print the number with the leading zero included?
Plus: how can I provide that my program reads 5 digits including a zero as a leading number?

1

votes

2

answer

838

Views

### CSV Leading Zeros [duplicate]

This question already has an answer here:
CSV Exporting: Preserving leading zeros
4 answers
I got the CSV file which may have some columns with leading Zeros .
If viewed in Excel leading zeros are not shown as they are treated as number .
Later this CSV has to be send to Sage 50 as import record.
M...

1

votes

2

answer

903

Views

### Efficiently Store Decimal Numbers with Many Leading Zeros in Postgresql

A number like:
0.000000000000000000000000000000000000000123456
is difficult to store without a large performance penalty with the available numeric types in postgres. This question addresses a similar problem, but I don't feel like it came to an acceptable resolution. Currently one of my colleagues...

1

votes

4

answer

417

Views

### How to add a zero in front of an integer value [duplicate]

This question already has an answer here:
Add leading zeroes to number in Java? [duplicate]
5 answers
I'm trying to calculate the future time when a user inputs hours and minutes separated by a space.
I'm stuck on when the user inputs minutes that calculates the future minutes to be less than 10....

1

votes

4

answer

2.1k

Views

### Most efficient way to remove leading zeros from Swift 3 string

I have a string such as '00123456' that I would like to have in an string '123456', with the leading zeros removed.
I've found several examples for Objective-C but not sure best way to do so with Swift 3.
Thanks

6

votes

1

answer

1.3k

Views

### Number to string with leading (left padded) zeros in Julialang

It seems as an easy question, but I cannot find the answer anywhere. If I have an integer variable, how can I transform it to a string with leading zeros?
I want something as the code below:
n = 4
string_size = 3
println(fleading(n, string_size))
# result should be '004'
Where fleading would be som...

5

votes

3

answer

7.9k

Views

### Incrementing a number and adding a leading zero in Bash

The problem is with the numbers 08 and 09. I've Googled this and found out the reason that 08 and 09 are problematic, but no solution.
This is a nonsensical example used to briefly describe my problem without getting into the details.
cursorDay=2;
let cursorDay=$cursorDay+1;
case '$cursorDay' in
1)...

1

votes

1

answer

1.1k

Views

### Adding leading zeroes to dataframe column using sprintf in R [duplicate]

This question already has an answer here:
How to add leading zeros?
8 answers
I have a dataframe and want the number variable to be four digits long, in order to do this I need to add between 1-3 leading zeroes, the method I chose to do this is the sprintf function, as it is immaterial that the num...

5

votes

2

answer

119

Views

### How is Leading Zero working in php?

Let's suppose I have a code which outputs $i as
$i = 016;
echo $i / 2;
//ans will be 7
I know that the leading zero indicates an octal number in PHP, but how is it interpreted, how can it be executed? Can somebody share its execution step by step? What is the role of parser here? I have researched...

3

votes

4

answer

750

Views

### Remove leading zeros in middle of string with regex

I have a large number of strings on the format YYYYYYYYXXXXXXXXZZZZZZZZ, where X, Y, and Z are numbers of fix length, eight digits. Now, the problem is that I need to parse out the middle sequence of integers and remove any leading zeroes. Unfortunately is the only way to determine where each of the...

2

votes

1

answer

165

Views

### Strange behavior in C when calculating sum of digits with leading zeroes

I just wanted to write a minimalistic program in C to calculate the sum of digits of some natural number (the sum of digits is defined as follows: sumOfDigits(123) = 6, sumOfDigits(0) = 0, sumOfDigits(32013) = 9, and so on).
So far, everything is ok with the following code snippet. For example, for...

2

votes

1

answer

2.5k

Views

### SAS proc import missing leading zero

I am trying to import numbers from csv file to sas dataset with proc import ( SAS ) , but all my leading zero are disappear after the import.
For example,
'0123456' after import I would get only '123456'

3

votes

4

answer

151

Views

### How to recognize single digit in string to insert leading zero?

In Python, I have a string with either two digits or one digit:
8 5E 9C 52 30 0
In every one digit in the string, I would like to add a leading zero to it (e.g. convert 5 to 05) and make it two digits.
Thought of splitting, .split(‘ ‘), and checking each one by one and converting each one digit...

4

votes

2

answer

75

Views

### add leading 0 at a specific position in a string (R)

I have a list of strings of this kind:
f

2

votes

1

answer

298

Views

### Getting leading zero displayed without quotes

I want to remove single but when I remove it, then leading zero is not displayed.
I want leading zero to be displayed but without quotes.
My column data type is varchar :
SELECT CONCAT('\'',U.user_gov_id) as User_gov_id ,
U.user_first_name , U.user_last_name , CONCAT('\'', U.user_mobile ) as Mobil...

1

votes

3

answer

88

Views

### reading a file in C: leading zeros

In my program I'm trying to read two values per line from a textfile.
It works well with my code below, but when I face numbers with leading zeros, it stores every zero as one value.
I want to be able to read in e.g. '007' as plain '7', but I still want to be able to read a '0' as a value.
Anyone...

3

votes

1

answer

1.4k

Views

### Padding zeros with FileHelpers

I am using FileHelpers to create NACHA files. Example below
Many of the properties are numeric with leading zeros so they have been defined as strings. Is there an attribute that can pad the leading zeros in the Class property, similar to the way FieldTrim/TrimMode works to remove whitespace?
[Fixe...

23

votes

5

answer

18.5k

Views

### SQLite function to format numbers with leading zeroes?

I’ve got an SQLite database that will need to contain products. Those products have a fixed-format composite product number, consisting of category, group and product number (cccccc.gg.ppp). Every time a new product is inserted, the new product number should be built using the category and group...

3

votes

4

answer

74

Views

### Adding leading 0s in r

I have a large data frame that is filled with characters such as:
x

4

votes

4

answer

362

Views

### R— Add leading zero to string, with no fixed string format

I have a column as below.
9453, 55489, 4588, 18893, 4457, 2339, 45489HQ, 7833HQ
I would like to add leading zero if the number is less than 5 digits. However, some numbers have 'HQ' in the end, some don't.(I did check other posts, they dont have similar problem in the 'HQ' part)
so the finally des...

3

votes

6

answer

975

Views

### Remove leading zeros in IP address using Python

Remove unnecessary zeros in IP address:
100.020.003.400 -> 100.20.3.400
001.200.000.004 -> 1.200.0.4
000.002.300.000 -> 0.2.300.0 (optional silly test)
My attempt does not work well in all cases:
import re
ip = re.sub('[.]0+', '.', ip_with_zeroes)
There are similar question but for other lan...

4

votes

4

answer

27.6k

Views

### How to display the leading zero's in a number of oracle

I have an oracle column(artnr) contains a length of 1 which is of type number(9). I want to update the number as following...
Example :
If number is 0 then it should be 00000
If number is 1 then it should be 00001
If number is 12 the it should be 00012
Remember : here 00000,0000, and 00012 are of nu...

2

votes

2

answer

544

Views

### Import .csv file to MSAccess table without losing leading zeros

My objective is to automate the import of a .csv file into an Access table, retaining all data in the csv file, specifically leading zeros.
The csv file will have a varying number of columns every time, so the table it needs to be imported into will have to be created on the fly.
Also, the decision...

4

votes

9

answer

3.5k

Views

### Remove leading zero and delimiter char for BigDecimal

Our application can get following numbers:
0.1
0.02
0.003
etc.
These values treated by our code as BigDecimal,as far we operate with money.
There is form on web UI, where user should view these floating parts of prices, transformed to following ones:
1
02
003
The question is,how to trim leading zero...