I have string inputs like below select query

/partition_date=20240101/part-0001.parquet
/partition_id=20240301/file.name.parquet
/year=2023/month=1/file2.name.parquest
/year=2024/month=2/part-0001.parquet

Need to parse the string to give output only partition information.

expected output

partition_date=20240101
partition_id=20240301
year=2023/month=1
year=2024/month=2

Can someone share the inputs how to achieve it using split, split_part, regexp_substr. Query should work for any of the above formats.

Thanks in advance