title: Powershell script to replace only the tab characters in substrings enclosed in double quotes
body: <p>I'm working with a tab separated values (tsv) text file. I'm importing it into Excel but for some reason it is also treating tab chars in strings (denoted with double quotes) as delimiters. </p>
  
  <p>A line in the file looks like this:</p>
  
  <pre><code>Name  Quote  Random text
  Harry  "I like putting    tabs in sentences"  "Here is another tab   "
  </code></pre>
  
  <p>I'm trying to write a powershell script to read the whole text file, find only tab chars enclosed in quotes and replace them with a space character. I know this will be possible but the issue is I'm not an expert in Powershell or regex :D</p>
  
  <p>Any ideas?</p>