Extract Date from a Filename

[KamenRider]

Hi 

Can I ask for your assistance in extracting the date and then convert it to format mm-dd-yyyy.

KB_XXXBULK_AGENCY_C_20240920_S1_Input
PB_XXXBULK_AGENCY_C_20240920_S1_Input_compress
LB_XXXBULK_MUMBO_20240920_S1_Input
BC_SIDELINE_MUMBO_20240927_S1_Input
XB_SIDELINENEW_MUMBO_20240927_V1_Input

MO_TUNDED_MUMBO_20240927_S1_Input_Talidation_compress.best.in

Thanks,

Kamen

[SPetrie · Accepted solution]

assuming no other 8 character long number sequences and always an 8 character date, this formula should do it

DateTimeParse(REGEX_Replace([Field1],".*(\d{8}).*","$1"),"%Y%m%d")

[KamenRider]

Thank you so much.