[R] How to import HTML and SQL files

Arup arup.pramanik27 at gmail.com
Thu Feb 5 07:34:43 CET 2009


Thanks a lot..I am trying to pick up R on my own.I will be asking you
questions if I am having any problem at any point of time.Thank you.

Arup

Dieter Menne wrote:
> 
> Arup <arup.pramanik27 <at> gmail.com> writes:
> 
>> I can't import any HTML or SQL files into R..:confused: 
> 
> Also confused. HTML and SQL are like apples and bugs.
> 
> For HTML (assume you want to extract stock quotes from a site)
> 
> -- If you have strict XHTML, using package XML might be
>    the best choice, but I doubt you get these nowadays.
> -- Otherwise, read in the file and use regular expressions (grep, 
>    gsub) to parse.
> 
> For SQL: SELECT * from mybase
> 
> -- "Importing" that string does not help very much, this is 
>    a program telling you what to do when you know your database.
> -- You might have a look at package RODBC or RSQLite; details depend on 
>    the database you are going to use.
> 
> Dieter
> 
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
> 
> 

-- 
View this message in context: http://www.nabble.com/How-to-import-HTML-and-SQL-files-tp21830945p21846010.html
Sent from the R help mailing list archive at Nabble.com.




More information about the R-help mailing list