Post #2445 by rayvt on the Mechanical Investing board

Investment Strategies / Mechanical Investing ❤

Unthreaded | Threaded | Whole Thread (45)

Post New | Post Reply | Report Post | Recommend It!

No. of Recommendations: 4

Even washing it through Notepad leaves the data in a single column. However, says this non-programmer, it would seem easy enough for someone facile with Excel macros or another "language" to write a short script to reformat the data for a spreadsheet.

Easily fixed. The lines end with Windows CR\LF. For some reason that's the problem.
I pasted it into notepad2 and did File/Line Endings/Unix(LF).
That gets rid of the CR. Cut & paste into Excel or Libreoffice-calc or google docs and it is just fine, one line per row, columns as expected.

I can't try original notepad since I've replaced it with notepad2.

Post New | Post Reply | Report Post | Recommend It!

Print the post

Unthreaded | Threaded | Whole Thread (45)

Prev | Next

Announcements

Mechanical Investing FAQ

Contact Shrewd'm
Contact the developer of these message boards.

A community forum supporting civilized, and highly helpful, self-educating investors that come together for Shrewdness and merry spirits. These message boards closely follow the look and feel of the old message boards at boards.fool.com prior to the boards redirected to discussion.fool.com. Shrewd'm is not affiliated with the comprehensive and excellent investment website, The Motley Fool (TMF), in any way. The Shrewd commmunity here has owed, and continues to owe, gratitude to The Motley Fool for nurturing a culture of jovial irreverence towards Wall St, and that tradition will continue here.