I'm hoping someone here is better versed in vcf files than I am, and this has an easy solution.

I've got a user going from a Blackberry (Z30) to an iPhone and wants everything porting across. Syncing the contact list to gmail resulted in 5 of the 1000 odd contacts on the Blackberry syncing, which I'm blaming the Blackberry for as it's a bit pants.

So, I've extracted the contacts from the backup file (a .bbb) as a csv. It's messed up a lot of the formatting and duplicated numbers. It had put something like +01274123456-+01274123456 in the same cell for all the numbers, so I've gone through and cleaned it up. I don't want to have to go through the data again, so I want to make sure I'm getting the format of the numbers correct for an export to vcf and something the iPhone's going to be able to read when the user goes to make a call.

The numbers are mostly mobiles and have brought the leading 44 across, and are currently like this:

44123456789

Would I need a '0' after the 44, or a + before the 44? How does it deal with brackets - could I have something like this: (44)0711111111?




 

what happens if you import this CSV into Google now? It's really good at cleaning up contacts if you can manage to get them in.

There's an idea. I'll try that in the morning.

Most informative. I'd like to see a chart like that demonstrating Sepp Blatter's fall from grace alongside the ups and downs of Dan Ackroyd's career.

I googled "regex superhero" for that.

Looks like it's worked. Though I'm unable to test if she can ring out using one of them, as the SIM details need transferring over from her old phone.

Still, some success!

Thanks Milko.  :-{)

You are most welcome.