Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #110753
| From | GS <gs@v.invalid> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: Remove leading zeros from string |
| Date | 2018-10-14 01:55 -0400 |
| Organization | A noiseless patient Spider |
| Message-ID | <ppulof$8l4$1@dont-email.me> (permalink) |
| References | <dddc43bc-8bc0-4e02-93fc-83c322b486a1@googlegroups.com> <8467ae2e-0389-433a-964c-9be21000076b@googlegroups.com> |
> El sábado, 13 de octubre de 2018, 6:08:39 (UTC-5), Tatsujin escribió:
>> 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
>
> ?Replace("32 01 22 88 03", "0", "")
Oops! That's going to replac *ALL* zeros; - the task is to replace *LEADING*
ZEROS ONLY!!
--
Garry
Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll 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