Re: Validation of text

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance




onedaywhen wrote:
Klatuu wrote:
Is it possible to validate entered text so that it must start with a
predefine letter, say 'H', followed by a numeric value of varying length?
The basic pattern is

NOT LIKE 'H*[!0-9]*'

Further thought: you may want to avoid 'leading' zeros in the numeric
portion e.g. basic pattern:

NOT LIKE 'H*[!0-9]*' AND NOT LIKE 'H0*'

Jamie.

--

.



Relevant Pages

  • Re: outputting random boolean values
    ... am sorry but I do not yet understand how to avoid this. ... While writing to the buffer during a regeneration, ... while the driver was replacing the old pattern in the buffer with the ... then a portion of old data, and then a portion of new data again. ...
    (comp.lang.labview)
  • finding zeros of data
    ... y=amplitude) and when I plot it, it's essentially a varying ... sinusoidal pulse. ... I am familiar with fzero as a method of doing this ... the zeros with an automatic process? ...
    (comp.soft-sys.matlab)
  • Re: Extracting Values and Trimming Text
    ... I'm going to assume that all number sets in the string can be of varying ... lengths (even though the 1st set are all 4 digits). ... If there might be leading zeros then a different approach will be needed. ...
    (microsoft.public.excel)
  • Re: Fwd: How to read bad blocks error message & marking of same
    ... > Got about 7 of these with varying values. ... > zeros to that block hasn't sat well with me. ... > point me in the right direction to use these values to fix my disk problem ... for Genesis Software - http://www.gsoft.com.au ...
    (freebsd-hackers)
  • cartesian product...
    ... I need to do a Cartesian product, ... I've dropped in that portion of my C++ code in hopes ... Otherwise, I'm going to have to rethink my solution, which I really ... would like to avoid. ...
    (comp.lang.cpp)