String and number manipulation
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
Hi, I have written some code which in turn write some other code. However,
I am evaluating cells for heading and numbers, once found each number
indicates a particular variable for the new code. the problem I having is
that in 90% of the cases the numbers are simply 5 digits long and can easily
be stored as a normal variable. I am having problems however, in the other
10% of cases where there are two or three of these numbers which are
seprated by a '/'. To make life easier these numbers are always going to be
5 digits long. Can anyone help me to split these number up. My suspician
is that I am going to have to hold the value as a string - take the parts of
the string that corrrespond to the first, middle, or last 5 characters and
then cast this number back into an integer or Long varaible. Does this
process sound correct to anyone - or is there another way I have not thought
about?
.
Relevant Pages
- Re: How to convert extra long strings into their equivalent Hex Strings in VBA (Word 2K)
... numbers (upto 18 digits max) into its equivalent Hex String ... Public Function ExpressServiceCode(ByVal ServiceTag As String) As String ... 'the number dblTemp in the specified base, ... Dim lngTemp As Long ...
(microsoft.public.vb.general.discussion) - Re: BigNum -- Floating Point
... The 'N' is the number of decimal digits. ... The internal representation is really just a string of bits. ... the number of shifts for various multiples of ten: ... The 'exponent' is very closely related to ...
(comp.programming) - Patterns in pi, copyright law, and philosophy
... Whether the offset of a string found in pi can be used as a form on ... then calculate how many digits of pi one would need to raise the ... "An infinite series of numbers is not an exhaustive set of numbers. ... finite string of digits occurs within the decimal expansion of pi, ...
(sci.math) - Re: Patterns in pi, copyright law, and philosophy
... The digits of pi are widely believed to be "normal", in the sense that every n digit combination of digits is equally likely, and pass all reasonable tests of randomness. ... The mean length of the offset must at least be equal or greater than the length of the string you are looking for. ... Pi has an infinite representation as a decimal. ... finite string of digits occurs within the decimal expansion of pi, ...
(sci.math) - Re: Required Field for 7 Numeric digits only
... Function IsNumber(ByVal Value As String) As Boolean ... > works with verifying that it has 7 digits and is a numeric filled> textbox ... > Private Sub TextBox1_KeyPress ... > Dim IsValid As Boolean ...
(microsoft.public.excel.programming) |
|
