Regex does my head in, I’m looking for an expression to take a list of songs and re-format them. I’ve discovered \t to find the tabs, but unable to make any progress on the rest.
From: (with tabs in the middle of number and after artist)
- Garth Brooks Friends In Low Places
- Backstreet Boys Everybody (Backstreet’s Back)
- Spice Girls Wannabe
To:
Garth Brooks – Friends In Low Places
Backstreet Boys – Everybody (Backstreet’s Back)
Spice Girls – Wannabe
Thanks in advance!
>Solution :
You may try the following find and replace in regex mode:
Find: ^\d+\t(.*?)\t(.*)$
Replace: $1 - $2