Dennis,
Thanks for the suggestion. Once I get the spread sheet data into a table
accessible
by Rbase , there are several ways to manipulate. Your idea being a very good
one!
However, I must ask what is :
While (0) = (0) then
I try to learn something new every day and this will probably be one for today!
I am not familiar with this syntax. What is the WHILE statement
interpreting here?
Thanks,
-Bob
----- Original Message -----
From: "Dennis McGrath " < dmcgrath @ qmiusa .com>
To: "RBASE-L Mailing List" < rbase -l@ rbase .com>
Sent: Tuesday, January 12, 2010 12:53:25 PM GMT -06:00 US/Canada Central
Subject: [RBASE-L] - Re: Large Spread sheet matrix data
With the item numbers in the first row, things get really EASY!
Something like this should be all you need, unless you need to get fancy.
Set var vCol # int = 2
Set var vColName TEXT
Set var vItemText TEXT
While (0) = (0) then
Set var vColName = ('#' + CTXT (. vCol ))
Select & vColName into vItemText From SourceTable Where Count = 1
If SQLCODE <> 0 then -- no more columns
Break
Endif
Set var vItemNum = & vItemText
Insert into TargetTable ( StoreNum , ItemNum ) SELECT #1, & vColName +
FROM SourceTable WHERE & vColName = 'Y' AND Count > 1
Set var vCol # = (. vCol # + 1)
endw
Dennis McGrath
________________________________________
From: rbase -l@ rbase .com [ mailto : rbase -l@ rbase .com] On Behalf Of
Lawrence Lustig
Sent: Tuesday, January 12, 2010 12:40 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Large Spread sheet matrix data
<<
I will look into Karen's suggestion about cursoring the system table. That
should
work well. As long as I Detach the table each time, the column structure
should
update on the next SAttach .
>>
You can import an XLS of unknown number of columns using
GATEWAY XLS FileName . XLS CREATE TableName
This doesn't require SATTACH and SDETACH (which, for some reason, always make
me nervous).
With this technique, the items numbers are in the first row of data. The
column names are predictable ( CELL_A , CELL_B , and so on), so you can "walk"
the columns yourself (or continue to use the SYS_COLUMNS and SYS_TABLES
approach).
--
Larry
