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
 Origin Forum
 txt file
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

aagar001

USA
Posts

Posted - 06/09/2007 :  2:01:14 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Hey there every1, i am Using Windows Xp and i have a problem. I have a text file that is formatted in single coulmns and i need to be able to graph it. I know origin can take that single column data and put it into two columns so you then can use excel or matlab and graph it. Any ideas of how this can be done.

Mike Buess

USA
3037 Posts

Posted - 06/09/2007 :  4:04:45 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Depends on how the column is arranged but these solutions cover the only possibilities I know about.

1> Use this script to copy the 2nd half of the column to the column 2...

if( wks.ncols==1 ) wks.AddCol(); // add column if necessary
get col(1) -e npt; // number of rows
nn=npt/2;
copy -b (nn+1) col(1) col(2) -b 1 -e nn; // copy 2nd half to col2
set %H -er nn; // reduce number of rows by half


2> Use this to copy even rows to column 2 and keep the odd rows in column 1...

if( wks.ncols==1 ) wks.AddCol();
get col(1) -e npt;
temp = col(1);
copy -u temp col(1) col(2);
set %H -er npt/2;
del temp;

Mike Buess
Origin WebRing Member
Go to Top of Page

aagar001

USA
Posts

Posted - 06/10/2007 :  5:50:17 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
okay i am not sure if that was the answer i was looking for. So let me explain this, in class we used the Agilent 4155C Semiconductor Parameter Analyzer and when we used it, we obtained some graphs but when we tried saving the graphs the only thing it saved was a text file that contains the data for the graph. With this data how do i go about graphing it so i can see the graph that i saw on the Agilent 4155c
Go to Top of Page

Mike Buess

USA
3037 Posts

Posted - 06/10/2007 :  7:58:23 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
I know nothing about the Agilent 4155c but first you asked how to put one column into two in order to graph the data. Perhaps the data are correct as they are, i.e., all in one column. First select the column, then Column> Set As Y and then pick a style on the Plot> menu.

Mike Buess
Origin WebRing Member
Go to Top of Page

aagar001

USA
Posts

Posted - 06/13/2007 :  03:19:12 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
thanks for all the help. I actually figured out the problem. The data that i had had data for 6 different graphs so i had to split it all apart into separate columns and once i did that it was easy to obtain my plots.
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