Operation request: Unique/Sort lines based on part of it

[w4po]

Summary

• Ability to sort input lines based on regex, or even better if we can sort the whole input lines based on Subsection
• Ability to get unique lines based on part of a line.

I want to get the most recent backup file of each database:

Example Input

ABC_backup_2024_04_19_030015_4199663.bak
ABC_backup_2024_04_26_031328_7771579.bak
ABC_backup_2024_05_10_030015_4434976.bak
ABC_backup_2024_05_03_030022_5120774.bak
KQMO_backup_2024_04_19_030014_8992595.bak
KQMO_backup_2024_04_26_031328_2733774.bak
KQMO_backup_2024_05_03_030021_8090927.bak
KQMO_backup_2024_05_10_030014_9279748.bak
QWERTY_backup_2024_04_19_030015_5155445.bak
QWERTY_backup_2024_04_26_031328_8747284.bak
QWERTY_backup_2024_05_10_030015_5372286.bak
QWERTY_backup_2024_05_03_030022_6214310.bak

Example Output

ABC_backup_2024_05_10_030015_4434976.bak
KQMO_backup_2024_05_10_030014_9279748.bak
QWERTY_backup_2024_05_10_030015_5372286.bak

For me to do that in the current version of CyberChef, I had to do the following steps:

1. swap the DB name with the date
2. convert date to timestamp
3. sort numeric
4. convert back timestamp to date
5. swap back date with the name
6. using regex Extract unique lines (last occur of each name [the lines are sorted based on date already])

Here is my attempt: Recipe