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
 All Forums
 Origin Forum
 Origin Forum
 Column Naming Rules - Relax Them, Please!

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
a_user Posted - 08/19/1998 : 4:05:00 PM
This is an enhancement request.

I have just started using Origin 5.0.
I am using it to analyze, chiefly to do graphs,
on already existing data sets.

The data in these existing data sets already has names for things
such as columns. Unfortunately, these names do not meet Origin's
naming conventions.

The names are things like "ctr16.sim_num_insn/ctr16.br_mispred".
(Note the double quotes. More on that below.)
Let's list the Origin column name rules these break:
a) names are more than 11 characters
b) names contain special characters such as _, ., /
etc.

Going in and fixing these names is really, really, annoying.
It makes the data extremely hard to read.

You might ask 'where in the world did such funky names come from?'
You might be saying 'This guy must be computer illiterate. No programming
language allows names like that.'

Well, SQL, the database query language, does. SQL allows ANY string
of characters at all to be used as a name, so long as it is placed within
double quotes - a so-called delimited identifier.

And guess what: my data comes from an SQL database.

I can't tell you how LIBERATING it is to be able to use completely arbitrary
names. For example, you can simply generate names on the fly. No need
to create funky acronyms. It allows you to mix names from any language
- English, Japanese, COBOL (paragraph-name), C (procedure_Name),
LISP (defun-name).

Arbitrary names are a huge increase in user convenience. I suggest that
you consider implementing the delimited identifier in your symbol table
package.
It's really easy - I added it to my data manipulation tools as soon as I
learned
of it - and it helps.

And, lest I have not said so yet: it is really, REALLY, annoying to have to go
back to typing 11 character alphanumeric names with no punctuation.
Imagine, if you will, the pain of having to go back to MS DOS's 8.3 character
filenames, once you have used UNIX or Windows 95 or Windows NT long file names.
Now make it even worse...

3   L A T E S T    R E P L I E S    (Newest First)
a_user Posted - 08/19/1998 : 5:04:00 PM
You can import and display Labels for columns

If your ASCII files have multi-line headers that share the same delimiter as your data, then that information can be imported into column labels. By default, the column labels only display the first line, but you can expand that by setting the Column Heading Height to a larger number (about 11 + 11 * NumberOfLines on my system) in the Worksheet Display Control dialog accessed through Format:Worksheet in Origin's main menu.
For example, given a tab delimited ASCII file such as:

Time since onset Probe Pt+Au 90/10 #A-30i Response (combined Channel A + Channel B /2)
seconds mV uV
1 13 24
2 17 18
3 19 15
4 15 19
5 12 21
6 16 16

imported into a standard Origin worksheet (no special ASCII Options set), your labels will appear on your worksheet as:

Time since onset Probe Pt+Au 90/10 #A-30i Response (combined Channel A + Channel B /2)
seconds mV uV

and in your Plot Legends as:

Probe Pt+Au 90/10 #A-30i (mV)
Response (combined Channel A + Channel B /2) (uV)

a_user Posted - 08/19/1998 : 5:02:00 PM
Column Names in Origin

I fully agree with Mr. Glew.
The column name restrictions are the major problem I have with Origin.
All my names are longer than 11 characters and therefore they are not
imported.
So how can I choose the right columns for plotting? I don't know what data is
stored in column UU(Y). I have to open an editor, look at the names and fix
them simultaneous in Origin. This takes a lot of time and is really annoying.
I hope the next service pack will include an improvement. Maybe it could be
possible to use the column labels for choosing the columns? Or is there a
workaround with Origin Professional?

a_user Posted - 08/19/1998 : 4:47:00 PM

Column Names in Origin





I will add a suggestion to 'relax' column naming rules to our development database. Since lots of code development has gone into our LabTalk1 scripting language which has special syntax requirements for entities like windows, column names and datasets, I doubt that there could be any huge changes made in column naming conventions, but this will get the programmers to look at the issue.
1 LabTalk is powerful enough to be used for many of Origin's menu options. Look at the 200,000+ bytes of LabTalk code in our OGS files for examples.
We already recognize that users may have special needs for text associated with a column and provide the Column Label2 for just this purpose.

Origin can use this text automatically in Plot Legends. Suppose you had:



A(X)
B(Y)
C(Y)
Time
sec.
SubProbe Pt+Au
MicroVolts
R@08:27:13,S_26.9A
MilliVolts

When you plot this data (as a scatter plot, for example), your Legend will include both lines of your Column Labels:

SubProbe Pt+Au (MicroVolts)
R@08:27:13,S_26.9A (MilliVolts)

If your data includes two lines of header information (appropriately delimited), then the ASCII import routine will try to name the columns with the first line and put the second into Column Labels. If the naming isn't completely successful, then the first line is also sent to Column Labels. In either case, the full text will appear in your Plot Legends.
2Access the Column Label by any of these methods:

  • Double-Click on a Column Name
  • Highlight a column and select Format:Column from the main menu
  • Right-Click on a Column Name and select Properties from the context menu

Enter your text in the Column Label box at the bottom of the Worksheet Column Format dialog.

Expand the space for labels in Format:Worksheet:Column Heading Height.

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000