IF Statement for beginner

[Tommaso83]

Hi Everyone

Completely new here.

Trying to build my first workflow and missing some basics

I would need help for 3 formulas:

1) FORMULA n.1: if mobile number starts with +, then replace + with 00

2) FORMULA n.2: if company is "ABC" then create email address firstname.lastname@abc.co.uk

3) FORMULA n.3: if last name contains added msc, then remove msc (example: if last name is Smith msc, then keep only Smith)

Thank you for your help 😉

[jacob_kahn · Accepted solution]

Sure @Tommaso83 

Happy to assist a newbie to the Alteryx community!

So what I might do something in the attached workflow very quickly.

I'm sure you can do this in the formula tool and can try for you if you prefer

Thanks,

J

[jacob_kahn · Accepted solution]

@Tommaso83 

You can refer here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Replacing-multiple-values-in-one-strin... and here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-make-two-Replace-function-in-on... for more information on replace multiple string values.

The RegEx solution just allows it to be dynamic, so that you don't actually have to specify all of the possibilities.

J

[Tommaso83]

Morning awesome Alteryx community

I've got another question

What is the formula to use for the following scenario?

If title contains "trainee" or "assistant" or "contractor" then remove entire row

Thanks in advance for your help

[KilianL · Accepted solution]

2) FORMULA n.2: if company is "ABC" then create email address firstname.lastname@abc.co.uk

I guess you need a generic solution for this for any company name?

Use a formula tool to create the email like this: