title: Specifying a text qualifier and delimiter in Linux
body: <p><strong>how to specify text qualifier with awk or another linux program?</strong></p>
  
  <p>my data looks like this:</p>
  
  <p><img src="https://i.stack.imgur.com/YqTd1.png" alt="enter image description here"></p>
  
  <p>It's actually tab delimitted, but some fields have a tab inside of them. the fields are qualified by double quotes.</p>
  
  <p>how do i specify that the fields are not just delimitted by tabs but also the fields are separated by quotes?</p>
  
  <p>here's my script so far:</p>
  
  <pre><code> awk '{OF=OFS="\t"}{print $1,$7,$8,$10,$11,$21}' cyme.txt | grep -i pilates
  </code></pre>
  
  <p>also, for practical purposes, i'm including a perfect text copy of a data sample:</p>
  
  <pre><code>"723721093013"  "AFL"   "1" ""  "15"    "ALT ROCK...."  "Hai!........................"  "Creatures, The.............."  2   "N" 4   7.48    2004.02.17  0.0000  .  .    .  .    2
  "723721093112"  "AFL"   "1" ""  "5" "ELECTRONIC.."  "Crash And Burn.............."  "Foxx, John/Gordon, Louis...."  1   "W" 4   11.98   2004.02.17  0.0000  .  .    .  .    73
  "819162013137"  "AHY"   "1" ""  "101"   "PUNK........"  "Truth, Love and Liberty....."  "FM359......................."  2   "H" 1   4.48    2014.01.14  0.0000  .  .    .  .    39
  "879198005148"  "AHY"   "1" ""  "14"    "PUNK........"  "Re-Volts S/T................"  "Re-Volts, The..............."  1   "J" 4   5.48    2007.12.11  0.0000  .  .    .  .    10
  "879198004288"  "AHY"   "1" ""  "24"    "PUNK........"  "Read Between The Lines......"  "Smalltown..................."  1   "N" 4   7.48    2009.12.01  0.0000  .  .    .  .    17
  </code></pre>
  
  <p>Please let me know if anything needs clarification. 
  <strong>how to specify text qualifier with awk or another linux program?</strong></p>
  
  <p>I'm realizing that surprisingly awk might not be the right tool for this job, and if that is indeed the case, I'm happy to learn about other commands to should be used to process a text file with field qualifiers.</p>