If then condidition

Question

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?

Qiu · Answer

@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.

0123-Feras95p.yxmd

ShankerV · Answer

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

Solution 2 - If then condidition.yxmd

ShankerV · Answer

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

If then condidition.yxmd