HW for 10/3 (Xiangyang Liu)

[XiangyangLiu66]

@coraallencoleman @cecileane

Exercise for 10/3

Below is the one liner using sed to remove commas and quotes within the 'minimum' column(bash3 on a Mac):

sed -e 's/\(".*\),\(.*"\)/\1\2/g' tableofSNPs.csv | sed 's/"//g' > newtable.csv 

• The one liner utilizes sed to remove comma(s) between the first and second quotes from file tableofSNPs.csv
• Then it passes through a pipe and uses sed to remove quotes
• It is very important to note that the order of removing commas and quotes can not be reversed in this type of code
• The output is recorded into a new file(optional)
• I think that there might be a better way to do it as piping may not be the most efficient way to complete the task (run time~0.024s)

Below is the one liner to check the result:

sed 's/[^,]//g' newtable.csv | head -1

• The one liner utilizes sed to remove all characters except comma.
• Then it passes down via pipe to display the first line using head function
• The result should be 3 commas in a line