[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