Hi, I have a phone number column where it is mixed with phone numbers and dates. Is there a way that i could identify which are dates and which are not and separate them or to totally remove the dates.
Thanks.
Solved! Go to Solution.
A formula tool using REGEX_Replace sounds like what you need. For example REGEX_Replace([field_name],"\d\d\d\d\d\d", "") would remove any six consecutive digits.
Depends on the format of the data and the format of the telephone numbers and if there are any other split characters or items in the string. Can you provide an example?
Regex is not an easy tool to get to grips with, but worth the effort to learn and will be able to solve for your case : https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-RegEx/ta-p/37689
Thanks @rhtkiong but I can't access the excel file. It has to be packaged. You could either send me the file or just copy paste few cells here so I can see the format.
Thanks @rhtkiong
Please check the below. I included "_" and "/" to take into account the different dates format. You can then add a filter tool to get rid of dates. Please let me know if this works. Cheers!