08-15-2011 08:46 AM
I have just imported about 2000 records and I noticed that our mobile cell numbers is missing the leading zero.
For example: imported number = 410565773 correct number = 0410565773
is there a way i can do a global search and check the field and if it's incorrect add the zero?
I was thinking if the field contains 9 digits and the first digit = 4 then insert zero before the left most digit.
08-15-2011 03:52 PM
I would be inclined to go back to the spreadsheet and resolve before the import or if you go to www.designr1.com they have a tool called swiss army knife whihc is capable of doing this.
12-19-2011 06:53 AM