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)
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement