[R] Importing data from a text file with no separator

Duncan Murdoch murdoch.duncan at gmail.com
Thu Jun 9 15:10:24 CEST 2016


On 09/06/2016 8:56 AM, Federman, Douglas wrote:
> ?read.fwf
>
> There is a data import/export document on cran.r-project.org

And included with R distributions.  It's one of the manuals, and will be 
accessible via the help menu in front ends that have one.

Duncan Murdoch

>
>
>
> -----Original Message-----
> From: R-help [mailto:r-help-bounces at r-project.org] On Behalf Of Paolo Letizia
> Sent: Wednesday, June 08, 2016 8:40 PM
> To: r-help at r-project.org
> Subject: [R] Importing data from a text file with no separator
>
> I have row data in a text file, where each row consists of 22 numerical characters. Each row consists of three different column but there is no separator. Specifically, the first two characters of the raw represent  the first column of data, the subsequent 8 characters represent the second column of data and the last 12 characters represent the third column of data. An example follows:
>
> row data:
> 1003061490000000011608
>
> The first two characters, "10", is the column "Regime"; the subsequent 8 characters, "03061490", is the column "Industry", and the last 12 characters, "000000011608", is the column dollar value. How do I import the column data into R without having any separator in the text file?
> Thanks for your help, Paolo.
>
> 	[[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see 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.
>
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> 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.
>



More information about the R-help mailing list