Given:
First String Second 1.22 3.4
Second More Text 1.555555 2.2220
Third x 3 124
Goal: Set data up for a .csv format
Search:\s{2,}
replace: .
Result:
First String,Second,1.22,3.4
Second,More Text,1.555555,2.2220
Third,x,3,124
Given:
Ballif, Bryan, University of Vermont
Ellison, Aaron, Harvard Forest
Record, Sydne, Bryn Mawr
Goal: Remove commas and add parenthesis around the university names.
Search: (\w*), (\w*),(\s.*)
Each parenthesis is Replace:
\2 \1 (\3)
Given:
0001 Georgia Horseshoe.mp3 0002 Billy In The Lowground.mp3 0003 Winder Slide.mp3 0004 Walking Cane.mp3
Goal: Create a row for each .mp3 file
Search: .mp3\s
Replace: .mp3\n
Result:
0001 Georgia Horseshoe.mp3
0002 Billy In The Lowground.mp3
0003 Winder Slide.mp3
0004 Walking Cane.mp3
Given: List created from exercise 3
Goal: Change to format Song title_number.mp3
Search: (\d*) (.*).mp3)
Replace
\2_\1.mp3
Result:
Georgia Horseshoe_0001.mp3
Billy In The Lowground_0002.mp3
Winder Slide_0003.mp3
Walking Cane_0004.mp3
Given:
Camponotus,pennsylvanicus,10.2,44
Camponotus,herculeanus,10.5,3
Myrmica,punctiventris,12.2,4
Lasius,neoniger,3.3,55
Goal: Keep the first letter of the first word and the last number in the series.
Search:(\w)\w+,(\w*),(\d*\.\d),(\d*)
Replace
\1_\2,\4
Results
C_pennsylvanicus,44
C_herculeanus,3
M_punctiventris,4
L_neoniger,55
Given:
Data set from exercise 5
Goal: Place data into this form C_penn,44
Search: (\w)\w+,(\w{4})\w+,(\d*\.\d),(\d*)
Replace
\1_\2,\4
Given:
Data set from exercise 5
Goal: Place data into a fuse between the first three letters of each
word and a flip of the numbers. eample:Campen, 44, 10.2
Search: (\w{3})\w+,(\w{3})\w+,(\d*\.\d),(\d*)
Replace
\1\2, \4, \3