how to extract word from row <p>I have a 46 MB csv file containing data. Essentially, I would like select only those rows that have particular word like "PRODUCT". There are 600 000 rows for this data. I have used <code>grep()</code> to search for the string matching. Following are few lines of my data.</p> <pre><code>head(test) Item.Description UQC Year 1 PHARMACEUTICALS PRODUCTS.(MEDICINE) DOLEYKA SYRUP 100 ML NOS 2015 2 Multani mati hesh100gm x 160 (AyurvedicProducts) PAC 2015 3 Amla /Shikakai/ Aritha powder 100gm x 160 (Ayurvedic Products) PAC 2015 4 Godrej h.dye blk 40ml x 36 (Ayurvedic Products) PAC 2015 5 DR. COOLERS HERBAL LOZENGES.(2) DR. COOLERS HERBAL LOZENGES (MINT FLAVOUR) PAC 2015 6 Eno lemon/ regular 100gm x 48 (AyurvedicProducts) PAC 2015 Identifier RITC.Code 30049099 30049011 30049011 30049011 30049011 30049011 </code></pre> <p>I have used <code>test[grep("PRODUCT", rownames(test)), ]</code>. It gives me an error.</p>