Format

brophymj — Tue, 14 Jul 2015 14:15:09 GMT

I have a field Header1 ($20) of the form:

and where the cell is a string where the characters are number I want to convert to the format;

0000000001 where Header1 is 1

0000000134 where Header1 is 134

and so on.

for the cells where the string contains a mix of letters and number I want to leave them as they are.

I tried using this code:

Header1new = put(input(header1,20.),z10.);

This converts the numbers the way I want but it produces loads of errors for the non-numbers. Is there code that allows for this i.e.

if the string header 1 contains at least one character then do leave as is.

Thanks

Re: Format

ballardw — Tue, 14 Jul 2015 14:17:43 GMT

Almost there;

If anyalpha(Header1) = 0 then Header1new = put(input(header1,20.),z10.);

Tom — Tue, 14 Jul 2015 14:29:15 GMT

You need to test if it is a number. Also what about values that look like numbers such as:

1.5

12E5