I assume you are talking about character type values.
Then you may check for occurs("-",value)>0 or just use:
value= chrtran(value,"-","")
To append 0's you may use padl() or padr() functions, like:
value=padl(value,Length_you_need,"0")
>My data arrives is two different formats:
>
>9999-99-999-9999
>and/or
>9999999999999
>
>1. How can I check to see which format it is arriving in?
>
>2. Based off the format that it arrives in, be able to appen 0's to those particular records that dont fill all the way (i.e. 123456, or 1234-56)
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only