Extract mobile number in text

[BrahmanandaRao]

Hi

Guys in below excel sheet i have text data in column  B so in that i want mobile number 

its highlighted by red color for your understanding

[PaigeMiller]

Most of us will not or cannot download Excel files (or any files).

Please provide your data according to these instructions: https://blogs.sas.com/content/sastraining/2016/03/11/jedi-sas-tricks-data-to-data-step-macro/

[BrahmanandaRao]

Data like that only

[PaigeMiller]

---

@BrahmanandaRao wrote:
Data like that only

---

Then many of us can't help you. (But, yes you can, by putting in a little effort, turn your data into the format requested, and then we can help you)

[BrahmanandaRao]

I know solution in excel but i want SAS and Python

[PaigeMiller]

So put in a little effort and change it to a SAS data set and give it to us following the instructions. Then we can show you how to use SAS to extract the phone number.

[BrahmanandaRao]

I did solve using pandas
With same excel sheet without any format modifications after import the file

[Ksharp · Accepted solution]

proc import datafile='c:\temp\New Microsoft Office Excel Worksheet (3).xlsx' out=have dbms=xlsx replace;
run;
data want;
 set have;
 phone_number=scan(___VIT_AP_University_campus__Ina,-2,',');
run;