Remove cell in a CSV file if a certain value is there <p>I have two types of CSV files, and I want to merge them together. To do that, I want to locate certain values in each row and remove them if they are there.</p> <p>I tried using <strong>list.Index</strong> or <strong>list.Remove</strong> functions but I get an error when the values are not in the specific file.</p> <p>For example, the two rows are (I cut the rest of the rows for better display):</p> <pre><code>CSV 1950 1300 1180 48 48 400 2 PASS 0 51:31.5 CSV 3270 2500 1950 1300 1180 48 </code></pre> <p>I want to locate the cells with the values "<em>3270</em>" and "<em>2500</em>" so the two files will align... After that I want to remove the <em>empty cells</em> so again - they will align...</p> <p>Can you please help me understand the way to do this?</p> <p>thanks, Nimrod.</p>