SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Data Flux Data Management Studio

Reply
Occasional Contributor
Posts: 6

Data Flux Data Management Studio

Hello All,

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.

SAS Super FREQ
Posts: 97

Re: Data Flux Data Management Studio

Posted in reply to ShammiKalsi

Hi,

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.

Ron

Ask a Question
Discussion stats
  • 1 reply
  • 307 views
  • 0 likes
  • 2 in conversation