C LAB‎ > ‎Beyond‎ > ‎

Marksheet Transfer.

posted Jan 21, 2011, 11:39 PM by Neil Mathew   [ updated Jan 22, 2011, 12:09 AM ]
The PDF which contains everyone's semester marks are pretty difficult to use. It would be easier if I could see it on a excel sheet instead. So I tell myself, why not copy it into excel. I do just that to find all those columns and rows stuffed into a single cell of my excel sheet. 

Apparently, when I copy the whole table into a notepad, all the column divisions turn into spaces. Therefore, I needed to replace them into TABs which can be recognized as column divisions in excel. However, using the Find & Replace option in notepad isn't enough since the column containing Name of Student and Father's name have individual parts of their names separated into different columns and misaligning the whole table. Hence, I made a software which can tell apart a name from the numbers and replace the proper spaces with TABs. 

The exe file should be placed in a folder with a notepad file already created under the name Raw.txt which contains the directly copied table without the headers ( AND the first character should be a newline and should have ] at the end, acting as the EOF character ). On processing that, it will create a notepad file called Done.txt which will contain what I can copy into an excel sheet without difficulty (fully aligned). 

I've attached the program source code and an example of the Raw File.

Console OUTPUT:

 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15
         All Rows Modified.

[ Used Devcpp  ]

Neil Mathew,
Jan 22, 2011, 12:09 AM
Neil Mathew,
Jan 22, 2011, 12:09 AM