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 😉
Solved! Go to 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
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
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
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: