The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum for Programming
 LabTalk Forum
 Assign Text to Dataset?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

jsw

USA
5 Posts

Posted - 10/14/2002 :  11:26:27 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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

Mike Buess

USA
3037 Posts

Posted - 10/14/2002 :  1:00:05 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000