Archive: Google Script for spreadsheet to delete

Budget 40$ per month
Posted: 5 years ago
Closed
Description
Hi There!

I would like a background google script to always be running so that anything pasted into Row 5 of a google sheets document will automatically be parsed such that all that remains is the "last name, initial".

For example:

Mouse, Minnie
Female/42y, 07-Sep-1976 DOB
123456789 PHN/MRN
CONFIDENTIAL

Would become :

Mouse, M

Sample Spreadsheet here - https://docs.google.com/spreadsheets/d/11erZ686LSIG_RvYYdtcTgMwXLs6j0FF0IYg7J99BwXs/edit#gid=0
Working conditions:
1-5 days
1-10 Hours/wk
Rate: max $40
Skills:
google spreadsheet
Category