adding '+' to all the numbers as a prefix (numbers are stored in a csv file) using a python script -


goal

all numbers in csv file exported hotmail stored 91123456789 whereas complete call need dial +91123456789. these contacts converted batch of vcf files , exported phone. want add + contacts @ beginning.

approach

write python script can indefinite number of contacts.

pre-conditions

none of numbers in csv file have + in them.

problem

(a) there posibility number may have 91 in like: +919658912365. makes adding plus difficult.

explanation:i adding problem, if 91 there @ beginning of number can add simple checking 2 consecutive digits , if match 91 can add + else don't need add + , can move on next pair of digits.

(b) fields seprated comma's. want add + prefix in front of field has header mobile , not in other field set of digits 91 may appear(like in landline numbers or fax numbers)

research

i tried excel, process take unreasonable amount of time(like 2 hours!)

specs

i have 400 contacts. windows xp sp 3

please me solve problem.

something below??

import csv  row in csv.reader(['num1, 123456789', 'num2, 987654321', 'num3, +23456789']):     phonenumber = row[1].strip()     if not phonenumber.startswith('+'):         phonenumber = '+' + phonenumber     print phonenumber 

Comments

Popular posts from this blog

Delphi XE2 Indy10 udp client-server interchange using SendBuffer-ReceiveBuffer -

Qt ActiveX WMI QAxBase::dynamicCallHelper: ItemIndex(int): No such property in -

Enable autocomplete or intellisense in Atom editor for PHP -