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
 Long names not imported correctly?

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
reepingk Posted - 03/05/2018 : 7:11:41 PM
I'm trying to import some data from some files and the line that contains the column labels is surrounded by quotes. It looks something like this.

" Frequency Power Time"

(Yes, the line starts with a space after the quote)

But origin likes to consider that whole quoted thing as one long name, so the first column gets labeled " Frequency Power Time" while the rest don't have labels.

What can I do about this?

I'm in origin 2017 on windows 10.
7   L A T E S T    R E P L I E S    (Newest First)
reepingk Posted - 03/07/2018 : 5:27:43 PM
quote:
Originally posted by cpyang

You need to know about Origin Text escape commands,

https://www.originlab.com/doc/Origin-Help/Escape-Sequences#Available_text_formatting_commands


So for example, to set units to milliohms, then

wks.col1.unit$="m\g(W)";


CP





Thank you. I'm brand new to origin (coming from Igor, trying to learn both as to appease my coworkers), so this sort of stuff is all new to me!
cpyang Posted - 03/07/2018 : 4:32:25 PM
You need to know about Origin Text escape commands,

https://www.originlab.com/doc/Origin-Help/Escape-Sequences#Available_text_formatting_commands


So for example, to set units to milliohms, then

wks.col1.unit$="m\g(W)";


CP

reepingk Posted - 03/07/2018 : 3:29:57 PM
quote:
Originally posted by reepingk

quote:
Originally posted by JacquelineHe

Hi,

I want to make sure you want to import your files by GUI (dialog), but not Origin C code, right?

Maybe because there is a space after the first quote, so when you import, Origin do not detect the Long Name as you hope.

If you want to import mutiple files, and there are three columns in all files (Column A, B & C). The columns' Long Name are the same Frequency Power & Time

I suggest you can enter the following script to Scripts: Script after Each File Imported edit box in the impASC dialog. Then it will rename the Long Name for the columns automatically after import.


wks.col1.lname$=Frequency; // rename the Long name for the first column in active sheet
wks.col2.lname$=Power;
wks.col3.lname$=Time;


Also, you can save this import setting to a dialog theme.Then you can reuse it without enter the script again.
About dialog theme, plesae refer to this help page:
https://www.originlab.com/doc/Origin-Help/Dialog-Theme

Thanks
Jacqueline
OriginLab



Yes, I was using the GUI to import the files. And your solution is absolutely perfect, thanks so much!



One last question. How would I use the above code to put a greek letter in for units? I've figured out that "wks.col1.unit$=" will change the units column, but I can't seem to make it work with "ohms". I can change the column to the ohm symbol manually by selecting a capitol "W" and clicking the "change to greek" button, but if I then copy the ohm symbol, I just get the "W", so I can't make it work in the code.
reepingk Posted - 03/07/2018 : 12:34:12 PM
quote:
Originally posted by JacquelineHe

Hi,

I want to make sure you want to import your files by GUI (dialog), but not Origin C code, right?

Maybe because there is a space after the first quote, so when you import, Origin do not detect the Long Name as you hope.

If you want to import mutiple files, and there are three columns in all files (Column A, B & C). The columns' Long Name are the same Frequency Power & Time

I suggest you can enter the following script to Scripts: Script after Each File Imported edit box in the impASC dialog. Then it will rename the Long Name for the columns automatically after import.


wks.col1.lname$=Frequency; // rename the Long name for the first column in active sheet
wks.col2.lname$=Power;
wks.col3.lname$=Time;


Also, you can save this import setting to a dialog theme.Then you can reuse it without enter the script again.
About dialog theme, plesae refer to this help page:
https://www.originlab.com/doc/Origin-Help/Dialog-Theme

Thanks
Jacqueline
OriginLab



Yes, I was using the GUI to import the files. And your solution is absolutely perfect, thanks so much!
JacquelineHe Posted - 03/07/2018 : 04:03:48 AM
Hi,

I want to make sure you want to import your files by GUI (dialog), but not Origin C code, right?

Maybe because there is a space after the first quote, so when you import, Origin do not detect the Long Name as you hope.

If you want to import mutiple files, and there are three columns in all files (Column A, B & C). The columns' Long Name are the same Frequency Power & Time

I suggest you can enter the following script to Scripts: Script after Each File Imported edit box in the impASC dialog. Then it will rename the Long Name for the columns automatically after import.


wks.col1.lname$=Frequency; // rename the Long name for the first column in active sheet
wks.col2.lname$=Power;
wks.col3.lname$=Time;


Also, you can save this import setting to a dialog theme.Then you can reuse it without enter the script again.
About dialog theme, plesae refer to this help page:
https://www.originlab.com/doc/Origin-Help/Dialog-Theme

Thanks
Jacqueline
OriginLab
reepingk Posted - 03/06/2018 : 11:10:10 AM
quote:
Originally posted by JacquelineHe

Hi,

Do you use the Import ASCII tool to import your files?

And you hope to set the Frequency, Power, Time for three column Long Name, right?

When you import files, do you check "Show Options Dialog" to open the import dialog? You can set the "Space" as "Delimiter" in the dialog.

If this is not you wanted, could you please show more detail about your question?


Thanks
Jacqueline
OriginLab



Jacqueline! Thank you, however it doesn't... quite work. I didn't try to change the delimiter because it's on the "data" page, and since the data was getting separated into columns just fine, I didn't see a reason to change the delimiter.

I've been using the the import wizard because the import Ascii doesn't quite work right (these files have massive headers, ~70 lines long, so the auto import ascii doesn't... quite get it right.)

Anyway, remember how I mentioned that the line starts with a space after the quote? Yeah that's messing it up. While the columns DO have long names now, they're all shifted over by one (so column A doesn't have a long name, column B is "Frequency", C is "Power". (And since I don't have a column D, the "Time" name gets erased? (I'm assuming)

I have no issue fixing this in Origin C if that's the easy way around it. Honestly, I would be happy just assigning names to these columns manually (well... automatically so that I don't have to do it for EVERY improt but with manual names) (they're never going to change, and the filter is going to be specific to this type of file only.)


EDIT: I can get it to work if I skip the first X characters per line... but that's non ideal because then it screws up all the comment/user parameters/etc lines. I need to be able to skip the first X characters for JUST the long names.
JacquelineHe Posted - 03/06/2018 : 02:34:52 AM
Hi,

Do you use the Import ASCII tool to import your files?

And you hope to set the Frequency, Power, Time for three column Long Name, right?

When you import files, do you check "Show Options Dialog" to open the import dialog? You can set the "Space" as "Delimiter" in the dialog.

If this is not you wanted, could you please show more detail about your question?


Thanks
Jacqueline
OriginLab

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