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
 Importing ASCII into Specific Columns of Template		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

farp1980

USA
3 Posts
Posted - 06/09/2024 :  10:33:00 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. and Service Release (Select Help-->About Origin): 2024b
Operating System: Windows 10 x64

I would like to automate the task of importing a 4 column ascii file into non-adjacent columns of an analysis template. Example:

Column 1 of ascii file -> import into Column A of template
Column 2 of ascii file -> import into Column C of template
Column 3 of ascii file -> import into column E of template
Column 4 of ascii fille -> import into column H of template

I have played around with filters and scripts with no luck.

Is it possible to automate this task in any way?

Thank you!

YimingChen

1594 Posts
Posted - 06/10/2024 :  10:53:07 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
You don't have to import the data file directly into this sheet. Instead, you can insert a worksheet in front of this sheet, then import the file into the inserted worksheet. For each column, right-click on it and select Copy Columns to..., then copy it to the appropriate column in the second sheet. Thanks.

James
Go to Top of Page

NicholasSupport

USA
38 Posts
Posted - 06/10/2024 :  11:08:06 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hello,

Here is an example of what James has mentioned:
https://my.originlab.com/ftp/forum_and_kbase/Images/Reusable%20Import%20to%20Analysis%20Template.opju

Open the attached project file and navigate to the "Import Template" sheet of Book1. Click the Data Connector icon then "Data Source..." to select your ASCII data with four columns. Then view the Analysis Template. These green lock icons can be clicked then "Change Parameters..." to change where the columns are imported.

Let us know if you have any further questions.

Relevant Documentation:
Copy Columns To https://www.originlab.com/doc/Origin-Help/copy-columns
Using a project file as an Import template: https://www.originlab.com/doc/en/Tutorials/Import-Multi-Clone

Best,

Nicholas G.
nicholas@originlab.com
OriginLab Technical Support Team
Go to Top of Page

farp1980

USA
3 Posts
Posted - 06/15/2024 :  09:48:36 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thanks James and Nick!
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