Question

I have a dictionary of phone numbers in a .csv file. There are multiple formats xxx-xxx-xxxx, xxxxxxxxxx, and (xxx) xxx-xxxx. I want to clean them up into one standard format in python.

Answer 1

numbers.csv

97834561234,(976) 456-9785,978-976-3421,9875612334,765-897-3241,(965) 432-6532

#source code:

data=open("numbers.csv","r")
numbers=data.read().split(",")
data.close()
new_number=[]
for i in range(len(numbers)):
   num=""
   for j in range(len(numbers[i])):
       if(numbers[i][j].isdigit()):
           num=num+numbers[i][j]
   new_number.append(num)
print(new_number)
f=open("new_numbers.csv","a+")
f.write(",".join(new_number))
f.close()
  

#output:

#if you have any doubt comment below..if you like give thumbs up....