Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

3
  • 1
    (1) Please post sample data (as text) in your question. (2) If your input file is CSV, show it as such. (3) If you want CSV output, say so (in the question, in an English sentence) and show it as such. (4) Specify (in an English sentence) how you want the first row (i.e., the headers) handled. Commented Dec 25, 2019 at 4:24
  • Thank you for your feedback. (1) I already have linked the entire text file above , (2) I've mentioned CSV in many places, the file extension is CSV, the question tag is CSV, CSV is in the title. (3) I suppose I could explicitly say csv output, but the parsiminous interpretation is that since I didn't ask for change in file, there's no reason to think that's what I wanted (4) in the original post, I mentioned "a third third, new column with a new arbitrary heading". I'm not perfect, and there's room for improvement with anyone, but I felt it was generally clear is at stands. Commented Dec 25, 2019 at 5:51
  • @steeldriver @ G-Man Says 'Reinstate Monica' I have converted the images to text now - please kindly reverse the downvote. Commented Dec 25, 2019 at 6:28