View Single Post
  #1   Report Post  
Susan
 
Posts: n/a
Default Display the complete URL instead of a link

Output from one of my software is in excel format. The results are
something like

Name Title ID source score
ABC rock-n-roll 123 link 92
ABC2 rock-n-roll2 124 link 65
ABC3 rock-n-roll3 125 link 45

The "link" in the source column has the actual URL to that album or
file. For further processing I need to import this file as a csv and I
need the actual URL displayed in the source instead of the "link" word.

For example the URL is www.somewebsite.com/documentID=AA1234

some basically I want something like

ABC,rock-n-roll,123,www.somewebsite.com/documentID=AA1234,92
ABC2,rock-n-roll2,124,www.somewebsite.com/documentID=AA1222,65
ABC3,rock-n-roll3,125,www.somewebsite.com/documentID=AA1256,45

Is there a way I can do this?

Thanks a lot.