Best way to clean this set of data column

[zenSMP]

hi all,

what is the best way to clean this set of data?

Input is the actual data while output is the outcome i need.

[DataNath]

Is there any logic here? From a quick glance it doesn't look like there's any consistency or indication as to what should be removed and when/when it should be left untouched.

[zenSMP]

i think the requirement is that is there is anything that looks like date, we will remove the number and -

Example 1:

TDE Lap Tip Toe 2014-04-16-09-54-10	TDE Lap Tip Toe
XLE  2014-04-24-11-41-12	XLE

And the next requirment is if cell starts with T##( ## being number) extract the first T## and everything else is removed.

Example 2:

T01	T01
T01-T02-220119	T01
T26 Redo  2020-05-19-10-31-29	T26
T57  2020-09-18-10-52-09	T57

[DataNath]

@zenSMP how come this entry remains untouched? Or was that an error in the example provided?

[DataNath · Accepted solution]

@zenSMP jumping off my laptop for now but this gets you to pretty much what you're after, unless there are weird exceptions which require extra logic:

[zenSMP]

arh, sorry thats an error on my end. you are right that should be

Popman-Estate-220119

Popman-Estate-