Hi Guys, I am new in ADF and would like to extract a date time string in my filename to use as a date hierarchy in my sink to ADLS gen2. for example I have a filename as "A_ODP_20200914_094647_00.CSV" and I want the 20200914 which I will partition as Year=2020 folder, Month=09 and Day=14 dynamically as the files come in. Can anyone assist with how I can go about it. Thank you
