Split data from two columns - phones
hi
I have a situation when l have a file that has two columns with phone data:
Phone Phone2
99998888 0411888999
0408999888
88887777
0401777666
I want to take any mobile number in either column and move to a new column called Mobile Phone and the other Phone so end result is
Mobile Phone Home Phone
0411888999 99998888
0408999888
88887777
0401777666
Any assistance appreciated.
thanks
0
Answers
This will likely only work for Australia and New Zealand but what I would do is determine the phone number type first, using the phone validation step.
you'll need to surface two new columns in your data accordingly from dual pass of the phone validation step
Note that I chose Vaid Phone as the Validation Type
The slot number transform hides the superfluous columns and adds a new column called Mobile Number
You start with just the two columns
and after this first step and action you get this
the challenge is going to be if both phone1 and phone2 have mobile numbers, then what do you do?