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
 Import and transpose many ASCII files at onces		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

Tk1544

1 Posts
Posted - 01/11/2019 :  05:22:58 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Hey,
I am using Origin 8.5.1 and have a problem with importing my ASCII files to Origin.
I have around 150 ASCII data files. In each file the data is seperated by spaces (with 9 of header lines on top).
If I just import one ASCII file (Import Assistant)it works out fine. BUT each "number" is in one column. I just want them in one column under each other. So I found the function Worksheet > "Transpose" where I can fix that - so all "numbers" are then under each other in one column.

I attached a picture to better illustrate my problem. Or see here: https://ibb.co/JsWnhRD

The problem is that I have 150 ASCII files and I don't want to do that manually. Is there a solution to fix the import and transpose in one - so that I receive 150 columns in the end with all my data in one project? [I tried the import "many ASCII files" function but its only replacing each ASCII file and doesn't import all]

It would be really nice if you could help me out with this problem (I guess I have to write a program - but I never programmed in my life, so it might be a problem for me)
Thanks
Tk1544

**In addition: I thought about open all 150 ASCII files with the "import assistant" so I ll receive 150 "Books". So I ll need a short command on Labtalk to take always the first line of one book, copy it to an empty book and transpone it to a column.
The problem is that I never programmed and so I don't know how to write a file like that**
Edited by - Tk1544 on 01/11/2019 07:23:41 AM

YimingChen

1607 Posts
Posted - 01/11/2019 :  11:50:11 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,

Here's one thought, in Import Multiple ASCII setting dialog, under Import Options node, set Multi-File Import Mode to Start New Rows. This way, once all your files are imported, they are stacking row-wise. Then do a transpose on the worksheet to get want you expect. See if it works. Thank you.

James
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