| T O P I C R E V I E W |
| jsw |
Posted - 10/14/2002 : 11:26:27 AM
I want to assign some text to elements of a dataset.
I have a worksheet called test1
The first column is called data1
The column type of data1 has been set to text
I try the following:
test1_data1[1]="aaa"
type $(test1_data1[1])
the type command returns "1"
The element in the worksheet changes to "-" from whatever it was.
I can manually enter text in worksheet positions. The type command always shows "1" however.
If I use numerical values then everything works.
My goal here is that I am using a script to extract data from a collection of worksheets and then at one line to my test1 worksheet for each of the processed worksheets. I want to label each row of the worksheet with the name of the worksheet that the data came from. I am able to get the numerical data into this worksheet, but not the text labels.
Thanks,
Joe |
| 1 L A T E S T R E P L I E S (Newest First) |
| Mike Buess |
Posted - 10/14/2002 : 1:00:05 PM
Hi Joe,
You need to use the $ symbol when assigning a string to a wks cell...
test1_data1[1]$="aaa";
%A=test1_data1[1]$;
%A=;
aaa
Mike Buess
Origin WebRing Member |
|
|
