title: Make links to hyperlinks in csv file through Python
body: <p>How can I make all links in the CSV file to hyperlinks? - Just add an HTML tag to all fields with links</p>
  
  <p>I think it's possible through Python</p>
  
  <p>CSV string looks like </p>
  
  <pre><code>"Name","CompanyName","Value1","Value2","Value3","Value4","Value5","Value6","Value7","Url","Value8 ""Value8.1"""
  "Name","Company1","SomeValue1","SomeValue2","SomeValue3","SomeValue4","SomeValue5","SomeValue6","SomeValue7","https://company1.com","Some"Value8 ""Value8.1"""
  "Name","Company2","SomeValue1","SomeValue2","SomeValue3","SomeValue4","SomeValue5","SomeValue6","SomeValue7","https://company2.com","Some"Value8 ""Value8.1"""
  </code></pre>
  
  <p>Should look like:</p>
  
  <pre><code>"Name","CompanyName","Value1","Value2","Value3","Value4","Value5","Value6", "Value7","Url","Value8"
  "Name","Company1","SomeValue1","SomeValue2","SomeValue3","SomeValue4","SomeValue5","SomeValue6","SomeValue7","&lt;a href="https://company1.com"&gt;https://company1.com&lt;/a&gt;","Some"Value8 ""Value8.1"""
  "Name","Company2","SomeValue1","SomeValue2","SomeValue3","SomeValue4","SomeValue5","SomeValue6","SomeValue7","&lt;a href="https://company2.com"&gt;https://company2.com&lt;/a&gt;","Some"Value8 ""Value8.1"""
  "Name","Company3","SomeValue1","SomeValue2","SomeValue3","SomeValue4","SomeValue5","SomeValue6","SomeValue7","&lt;a href="https://company3.com"&gt;https://company3.com&lt;/a&gt;","Some"Value8 ""Value8.1"""
  </code></pre>
  
  <p>I tried awk and sed, but it makes a lot of mistakes when I specify a column in the file. I feel script just should find all links ant insert it to HTML tags. But I did not understand yet how  it works</p>
  
  <p>Thanks in advance</p>