#!/bin/bash

# THIS MEANS THE WHOLE FILE IS PASSED WITH EXTENSION INTACT (i.e. 'asset_file.csv', not 'asset_file')
filename=$(basename "$1")
ext="${filename##*.}"
filename="${filename%.*}"

# Confirm file extension
if [ $ext != "csv" ]
then
	echo "Only CSV files may be used."
	exit 1
fi

echo "Processing $1."

echo "Removing newlines in quoted strings to new file..."
gawk -v RS='"' 'NR % 2 == 0 { gsub(/\n/, " ") } { printf("%s%s", $0, RT) }' "$filename".csv > "$filename"_new.csv

echo "Removing all rows without 'Sound Recording'..."
sed -i.bak -e '2,${/Sound Recording/!d;}' "$filename"_new.csv

echo "Done."
mv "$filename".csv "$filename".csv.bak && mv "$filename"_new.csv "$filename".csv && rm "$filename"_new.csv.bak