extract two dates in one cell and populate into other columns

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

Book1.xlsx

Parse

Date Time

Accepted answers

Emil_Kos

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])

Date2.yxmd

All comments

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

Date.yxmd

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

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])

Date2.yxmd

zcy9079

thanks very much for your help. It worked!!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703