I'm looking to extract the call history from Vodafone invoices, and a simply copy and paste job from the invoice isn't quite hitting the mark.
What I'm getting from the copy+paste process is the following:
[TABLE="width: 355"]
<tbody>[TR]
[TD="colspan: 2"]
[/TR]
[TR]
[TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]
[/TR]
</tbody>[/TABLE]
What I'm trying to achieve is to have the columns split out correctly from the export (or alternatively, using excel formulas to do the job).
Once, this process is done, I'm looking to extract my phone contacts from IOS 10.2 (on a iPhone 5S) and from gmail so that I can either v-lookup or index match the phone numbers to the contact names.
How can I go about achieving this?
What I'm getting from the copy+paste process is the following:
[TABLE="width: 355"]
<tbody>[TR]
[TD="colspan: 2"]
Date Time Number Type Duration You pay
[/TD]
[/TR]
[TR]
[TD]
00:00:15 $0.000
[/TD][TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]
19-Feb 08:24:15 AM PHONE NUMBER National Non Mobile 00:01:24 $0.000
[/TD][/TR]
</tbody>[/TABLE]
What I'm trying to achieve is to have the columns split out correctly from the export (or alternatively, using excel formulas to do the job).
Once, this process is done, I'm looking to extract my phone contacts from IOS 10.2 (on a iPhone 5S) and from gmail so that I can either v-lookup or index match the phone numbers to the contact names.
How can I go about achieving this?
