If then condidition

[Feras95p]

Dear all,

I have 2 columns in excel file. One contains the phone number and other contains the country name. What I'm looking for is to check the code of the phone number if it's started with 966 then write in country column Saudi Arabia and so on ... So I'm looking for a workflow that check the first 3 digits in the phone number and based on that write the country name in the country's column.

Any help in that?    

[grazitti_sapna]

@Feras95p , You can use the formula tool and add if else statement as per your requirement, as shown below in the example. Please feel free to reach out in case you face any issue or need more help.

[ShankerV]

Hi @Feras95p 

Please find the expected output.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[ShankerV]

Hi @Feras95p 

As there was no sample input, assuming the raw data might contain the phone numbers in different format like below.

Output after run:

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[Qiu]

@Feras95p 
Hope I am not too late for the party.

In case you have more than one country name to look up, better to have a Reference Dictionary as your master file.