07-29-2015 04:02 AM
I am using sas dataflux data management studio. i have mobile number col which has invalid mobile number. can u tell me how to build expression so that i can get the valid mobile number.
08-02-2015 02:39 PM
I assume you are asking how you can standardize the format of the phone number. This is best handled by using one of the "Phone" standardization definitions through the Standardize node in a data job in Data Management Studio. Choose a standardization definition that suits the locale/location from where the phone number originates. It's also possible to write custom expression code (and even regular expression code) in the Expression node but the standardization definition takes care of parsing the number for you ahead of any standardization routine.