I would like to know code that will delete multiple text from a comma delimited file. For example, how would the comma delimited file below delete the word 'PEST' in Perl language (previously an excel file that was converted to a csv and the last column was PEST):


1, 2,43,34, bosx,PEST
1, 2,53,24, boax,PEST
1, 2,63,14, bovx,PEST
1, 2,73,44, boxb,PEST
1, 2,93,54, boxb,PEST

Please help me the best way you can, I greatly appreciate it