How to remove leading Zeros

[RadhakrishnanR]

How to remove leading Zeros in the nvarchar datatype. I would like to do this using C#.

Example:

0001234
0000001234
00001234

Thanks in Advance...

Regards,
R.Radhakrishnan.

[Consola]

Hi Rad,

Try something like this:

string nvarchar = "0001234";
nvarchar = nvarchar.Replace("0", "");

[Hubibi]

Just cast to integer and cast again to string ;-)

I think it should work with:

            string sValue = "000123";
            int iTemp = Convert.ToInt32(sValue);
            sValue = Convert.ToString(iTemp);

[laitinen]

Hi Rad,

Try something like this:

string nvarchar = "0001234";
nvarchar = nvarchar.Replace("0", "");

How do you think this will work if the number contains a 0 anywhere but not in the beginning?

000202 will become 22.

Not a solution.

Laitinen

[Consola]

So true! As soon as Hubibi posted I realised that it was the leading zeros you wanted removed and not all zeros.

Use Hubibi's solution. That will work just fine

[laitinen]

Try this:

char[] charsToTrim = { '0'};
string nvarchar = "000012340";
string newString = nvarchar.TrimStart(charsToTrim);

Laitinen

[RadhakrishnanR]

Hi Laitinen,

Thanks a lot for your response...

Best regards,
Radhakrishnan

[laitinen]

Just cast to integer and cast again to string ;-)

I think it should work with:

            string sValue = "000123";
            int iTemp = Convert.ToInt32(sValue);
            sValue = Convert.ToString(iTemp);

Just to point out something that may seem like a detail: This will only work for integers in the range of a Int32. Therefore I think my proposal in post #6 is the way to go.

Laitinen

[ryanwilliams]

string paddedString = "000012340";
string newString = paddedString.TrimStart("0".ToCharArray());

[rliq]

It really depends on how long the NVARCHAR is, as a few of the above (especially the ones that convert through IntXX) methods will not work for:

String s = "005780327584329067506780657065786378061754654532164953264952469215462934562914562194562149516249516294563219437859043758430587066748932647329814687194673219673294677438907385032758065763278963247982360675680570678407806473296472036454612945621946";

Something like this would:

String s = "0000058757843950000120465875468465874567456745674000004000".TrimStart( new Char[] { '0' } );

// s = "58757843950000120465875468465874567456745674000004000"

[mavy-online]

string a = "000012340";
string b = a.TrimStart('0');


I like things simple, any reason not to remove leading 0's this way?

[andrewtheart]

Can someone give me the technical explanation why MySQL would pad "integers" with zeros if the datatype being applied to the value is varchar? (If that makes sense)

I had a comma separated value file with a column which contains records which were either 100% integer (304923094 for example), but some of the other records were hexadecimal / had characters (35GHQ153, for example). I imported the CSV file into MySQL using Navicat and specified that this column was to be datatype "Varchar 15". The hexadecimal values remained as they were in the CSV file, but the integer values got left padded with 0'sup to 15 total.

For example, RE122572 would import just like that, but 1258693 would import as 000000001258693

The left trim method works to fix this, but I want to understand exactly what's going on.

Thanks!
Andrew

[BioPhysEngr]

string a = "000012340";
string b = a.TrimStart('0');


I like things simple, any reason not to remove leading 0's this way?

That is the simplest; as far as I can tell.

[DataMiser]

If they are being padded with 0s it is likely for alpha sorting purposes.

1 2 3 4 5 6 7 8 9 10 11 ...

Will sort as 1 10 11 2 3 4 5 6 7 8 9 ...

With the leading 0s the sort will be in correct numerical order.

01 02 ...... 10 11

[HanneSThEGreaT]

This thread seems to get revived and revived. Please people - NEW MEMBERS - Start a new thread in future.