Groups > microsoft.public.excel.programming > #110750

Remove leading zeros from string

Newsgroups	microsoft.public.excel.programming
Date	2018-10-13 04:08 -0700
Message-ID	<dddc43bc-8bc0-4e02-93fc-83c322b486a1@googlegroups.com> (permalink)
Subject	Remove leading zeros from string
From	Tatsujin <tatsujin.3.r@gmail.com>

Show all headers | View raw

Suppose I have a string like this:

"32 01 22 88 03"

I need to remove all the leading zeros in the string.  The result should be:

"32 1 22 88 3"

What's the easiest way to go about this?  Thanks!

Mr. T

Back to microsoft.public.excel.programming | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

Remove leading zeros from string Tatsujin <tatsujin.3.r@gmail.com> - 2018-10-13 04:08 -0700
  Re: Remove leading zeros from string Claus Busch <claus_busch@t-online.de> - 2018-10-13 13:19 +0200
  Re: Remove leading zeros from string Ramon-México <cesaramon@gmail.com> - 2018-10-13 21:00 -0700
    Re: Remove leading zeros from string GS <gs@v.invalid> - 2018-10-14 01:55 -0400
      Re: Remove leading zeros from string Tatsujin <tatsujin.3.r@gmail.com> - 2018-10-14 02:33 -0700
        Re: Remove leading zeros from string GS <gs@v.invalid> - 2018-10-14 09:52 -0400
          Re: Remove leading zeros from string GS <gs@v.invalid> - 2018-10-14 10:09 -0400

csiph-web