find: [ \t]{2, }
replace: , Capture everything with two or more spaces. Replace with comma
find: (\w+), (\w+), (.*)
replace: \2 \1 \(\3\)Capture every word that is separated by commas and any character except after the comma and the newline. change the order of the words (1 and 2) and then add parentheses to the last characters (3 corresponding to the affiliation)
find: ^\s*(\d{4} .+?\.mp3)\s*
replace: \1\nCapture all the words that we want in the first line. Replace for a line break for each
find: ^\s*(\d{4})\s(.+?)(\.mp3)
replace: \2_\1\3 Choose the four digit number for each line. Move to the position that we want, before .mp3
find: (\w)\w+?,(\w+),[\d\.]+,(\d+) #replace: \1_\2,\3Capture the first letter of the genus name, then the species name and the numerical value. Replace all the words of the genus word except for the first letter, and delete the numeric values with points.
find: (\w)\w+?,(\w{4})\w+?,[\d\.]+,(\d+)
replace: \1_\2,\3find: ^(\w{3})\w*,(\w{3})\w*,([\d\.]+),(\d+)$
replace: \1\2, \4, \3Capture the first four letters of the species name
find: NA
replace: 0
find: [^\w\s/0-9\t\n]
replace:(just replace) First, select de word NA and replace for 0. Then, select characters other than: letters, digits 0 to 9 and / (to avoid replacing these symbols in the date column) and just replace.