Make new rows with input from field in other row

[Vmgh]

Hi all, 

ID	Date	ID2
CPM_422.pptx	2019-09-09 10:35	CPM_422
CPM_185_410_433_one-pager.pptx	2019-01-14 14:40	CPM_185
CPM_323 one-pager.pptx	2018-11-23 11:15	CPM_323

In my column "ID2" i have the desired format that i can use to join two data sets with. Found by RegEx. my problem is that  some of my original "ID" cells contains merged names so to say "CPM_185_410_433_one-pager.pptx". I would like to create new columns so that each ID got it's own column with the same date as for the merged one (see below). is that possible? 

CPM_185       2019-01-14 14:40

CPM_410       2019-01-14 14:40 

CPM_433       2019-01-14 14:40

/Vmgh

[Martyn · Accepted solution]

@Vmgh 

Try using a RegEx tool with the following settings

[hlmess · Accepted solution]

You can try a modified Regex Expression to tokenize your ID to recognize multiple IDs.

Resulting in:

From there, you can Append the CPM to all of your Parsed IDs. Note that this will only work if the IDs are the only sets of digits following an underscore in the file name. 

[Vmgh]

Thank you very much for the answer! 

[Vmgh]

Thank you very much for the answer!