SYNTAX TO ADD INTERNATIONAL DIALLING CODE

Posted by researcher on Feb 22, 2023; 11:43am
URL: http://spssx-discussion.165.s1.nabble.com/SYNTAX-TO-ADD-INTERNATIONAL-DIALLING-CODE-tp5741118.html

Dear SPSS people I would be extremely grateful if someone can suggest syntax to do following I have about 1,000 UK mobile numbers which are mostly 11 digits , without UK dialling code (+44) e.g. they look like this 07970471126 But I need to create a new variable which includes UK international dialling code i.e. to add +44 and drop the first zero in the number so that the above would become [phone] This is needed to prepare a distribution list for an SMS survey in Qualtrics A small proportion of the numbers have 10 rather than 11 digits but they are valid numbers Fairly urgent project =- all thoughts very welcome Thanks