Stack Overflow
Stack Overflow

Questions tagged [leading-zero]

276 questions
7
votes
4 answers

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…
C_Mu
  • 305
  • 4
  • 14
7
votes
2 answers

Reading in a .csv file removes leading zeros

I realize that reading a .csv file removes the leading zeros, but for some of my files, it maintains the leading zeros without my having to explicitly set colClasses in read.csv. On the other hand, what's confusing me is in other cases, it DOES…
user3755880
  • 375
  • 1
  • 5
  • 14
7
votes
7 answers

how to add leading zero to a text field in crystal reports

I'm trying to think of a way to add a leading zero to a string field value. For example I have 12345 but need a formula that would convert it to 012345. I'm new to Crystal as I know that this is probably a simple formula but cant seem to get it to…
Dagz200
  • 221
  • 7
  • 15
  • 25
6
votes
4 answers

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 -…
Karvy1
  • 959
  • 6
  • 14
  • 25
6
votes
2 answers

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?…
Jaymin
  • 1,643
  • 1
  • 18
  • 39
6
votes
4 answers

How to validate dates without leading zero on day and month?

I need to validate a precise date format in php. In my case the optimum date format should be: e.g. 1/1/2017 (without leading zeros) and the code should allow me to avoid the rest of date's format. The following code is what i wrote but with no…
Sergio Santopietro
  • 86
  • 1
  • 1
  • 5
6
votes
1 answer

R: Remove leading zeroes from the beginning of a character string

I have first referred to this question, but the answers did not help in my case. I have a list where each component contains elements starting with numbers, followed with words (characters). Some of the numbers at the beginning of the elements have…
panman
  • 1,179
  • 1
  • 13
  • 33
6
votes
3 answers

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…
CptSupermrkt
  • 6,844
  • 12
  • 56
  • 87
5
votes
4 answers

How to add leading zeros in a month columns in Pandas?

I looked through a lot of other questions but didn't see one that quite fit. Say I have the dataframe, df: Name Month Bob 5 Jim 7 Mary 12 I'm trying to write a for loop that would add a leading zero to the months with a single…
gf7
  • 145
  • 11
5
votes
1 answer

Leading zeros calculation with intrinsic function

I'm trying to optimize some code working in an embedded system (FLAC decoding, Windows CE, ARM 926 MCU). The default implementation uses a macro and a lookup table: /* counts the # of zero MSBs in a word */ #define COUNT_ZERO_MSBS(word) ( \ (word)…
lornova
  • 6,667
  • 9
  • 47
  • 74
5
votes
1 answer

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…
Bleeped
  • 469
  • 7
  • 16
5
votes
3 answers

Java ParseInt() - Catching Strings with a leading zero

Java's ParseInt method will happily parse decimal values supplied with a leading zero without throwing an exception, stripping the zero: int value = Integer.parseInt("050", 10); will result in the integer value 50. But, I have an application…
s-low
  • 706
  • 2
  • 8
  • 21
5
votes
4 answers

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…
Ramu Pedada
  • 51
  • 1
  • 1
  • 3
5
votes
3 answers

Javascript variable with leading zeroes

Javascript behaves differently with values having leading zeroes. alert(b) - prints different value. var a = 67116; var b = 00015; alert(a); alert(b); I am more interested to know What conversion is applied here by javascript inside alert(b) ? (If…
Kris
  • 719
  • 1
  • 11
  • 19
5
votes
2 answers

Keeping leading zeros using RODBC

I am trying to import data from an Access database into R. I would like to import the CIP codes for some majors, which can contain leading zeros. RODBC is converting the CIP code to a numeric value even though it is defined as text in Access. Can…
dmonder
  • 353
  • 4
  • 12
1
2
3
…
18 19