How can i extract date information with right trim

[kenan_turker]

Dear Community 

I am looking for a  solution to extract just date information from below values. 

KW1_MDA_AllAvailable_10-01-2022_14-18-11

KW13_MDA_AllAvailable_04-04-2022_08-06-48

KW25_MDA_AllAvailable_27-06-2022_08-10-43

The formula will need to produce below outputs 

10-01-2022

04-04-2022

27-06-2022

Anyone who can help ? 

[BS_THE_ANALYST · Accepted solution]

@kenan_turker two methods here:
One uses RegEx:

One uses the Text to Columns:
1) Use delimiter as _

2) Select columns you want:

[ShankerV]

Hi @kenan_turker 

One way of doing this.