I need to extract the contents of 4 books online into a 4 different Msaccess or Excell or Text files.
Each of the books are similar and we will explain one here first and if you can do it, then we will give you the names of the other 3 books.
the first one is at :
[url removed, login to view];action=pagebypage&page=1
then next page is at :
[url removed, login to view];action=pagebypage&page=2
and it goes on all the way till page :
[url removed, login to view];action=pagebypage&page=1477
Each page shows something like this :
1E siqgur pRswid ]
Ik Oankaar Sat(i)gur Prasaadh||
The Lord is One and He can be attained through the grace of the true Guru.
I need a msaccess file or excel table that takes the text above and puts into 4 columns. You can take the Line number above to show you where the new lines begin.
That is all.
It is easy. please let us know if you can do this.