extract two dates in one cell and populate into other columns

[zcy9079]

Hi,

i am new to Alteryx. Would be much appreciated if you could help me with this!!

I have a table with list of user names and their start and end date. The lastest correct date on the spreadsheet I received is always included in the Name column. I would like a workflow to be able to extract this date and populate into the columns "Start date" and "end date" on the right and other lines remain the same. Then the date in the Name Column is also removed. Examples attached. thanks for the help!

Before
Name	Start date	end date
Emily	04/01/2021	16/12/2021
Jason (09/06/2021 - 20/06/2021)	01/01/2021	31/12/2021
Mike	03/01/2021	22/02/2021
After
Name	Start date	end date
Emily	04/01/2021	16/12/2021
Jason	09/06/2021	20/06/2021
Mike	03/01/2021	22/02/2021

[Emil_Kos]

Hi @zcy9079,

I have prepared a workflow for you:

If the date format will be always in this format it will work like a dream

[zcy9079]

Hi Emil_Kos,

Thanks so much. This is amazing! Just one more query, would it be possible in the final data. to remove this bit (09/06/2021 - 20/06/2021) in the original cell?

Jason (09/06/2021 - 20/06/2021)	01/01/2021	31/12/2021
Jason	09/06/2021	20/06/2021

thanks

Claire 

[Emil_Kos · Accepted solution]

Hi @zcy9079,

The workflow will search for first ( sign and if he will find it he will only show the data till the first (. If it will not find any it will just show the name.

IIF(FindString([Name], ' (')!=-1, Left([Name], FindString([Name], ' (')), [Name])

[zcy9079]

thanks very much for your help. It worked!!