I have a field where they stored phone numbers, called "Sent Phone"
in my country the phone numbers have 8 characters
I made a field called "Length" ,to find out how many characters the field has "Sent Phone"
then I made a field called "New Phone" to classify only numbers that have 8 characters
I need to make a script that pastes the numbers that have 8 catechists in "New Phone" and if it doesn't have 8, put 0
ID | Sent Phone | Length | New Phone |
1 | 3 | 1 | 0 |
2 | 22 | 2 | 0 |
3 | 213 | 3 | 0 |
4 | 1 | 1 | 0 |
5 | 33445678 | 8 | 33445678 |
6 | 11 | 2 | 0 |
7 | 2 | 1 | 0 |
8 | 12569826 | 8 | 12569826 |
9 | 12560912 | 8 | 12560912 |
10 | 34235677 | 8 | 34235677 |
sorry for my bad English