[R] Importing big plain files from ERP-System/Data Mining with R
r-help.20.stefan817@spamgourmet.com
r-help.20.stefan817 at spamgourmet.com
Tue Oct 26 08:51:29 CEST 2004
Hi,
how can I import really big plain text data files (several GB) from an
ERP-System (SAP-Tables) to R?
The Header of these files are always similar, for example:
Tabelle: T009
Angezeigte Felder: 7 von 7 Feststehende Führungsspalten: 2 Listbreite
0250
----------------------------------------------------------------------
|X|MANDT|PERIV|XKALE|XJABH|ANZBP|ANZSP|LTEXT |
----------------------------------------------------------------------
|X|001 |01 |X | |012 |02 |ABC |
|X|001 |V9 | | |012 |04 |Okt. - Sep., 4 Sonderperioden |
|X|001 |WK | |X |053 |00 |Kalenderwochen |
----------------------------------------------------------------------
(including the first 5 rows in each downloaded table, row # 4 =field names,
length of 1 row > 1023 bytes, count of fields > 256, size = several GB,
count records = several million)
What is an appropriate way to read such tables in?
Greetings
Stefan
P.S. I am a beginner with R. Until now I have used ACL (http://www.acl.com)
for data mining purposes and I'm doing now my first try with R.
Yes, I have
[X] Read R Data Import/Export
[X] Read Using R for Data Analysis
[X] Read Simple R
[X] Read Manuals
[X] Read read.table() and scan() command
More information about the R-help
mailing list