07-14-2015 10:15 AM
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.
Need further help from the community? Please ask a new question.