If one has a field with values like
The number part can be any length - okay something reasonable like less
Can and/or cannot have a space in the field.
Then the start of alpha characters. Only the American 26 character
alphabet. Upper or lower case.
Can I solve the problem of taking the numeric part and putting into another
field by itself AND then putting the character part into an additional
field. At the moment I do not think we need to convert the CASE on the
Or would this problem better be solved in COBOL using the INSPECT statement?
Open to sending a Home Depot Card of a reasonable amount of $$$ "say $40"
to anyone who can give me a quick solution.
This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact