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
 import txt from different folder in one columne

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
Sigake Posted - 06/04/2009 : 07:05:02 AM
Origin 8 and Service Release 1

Hello everybody

I hope my English is not too bad and you understand my problem and have a solution.

I have different folder
c/a/
c/b
c/c
c/d

for example. In every folder is a txt file called Spannung.txt

I want all txt-files in one columne among each other.

I searched but I could not found a topic, which helped me.
Have anybody an idea for my problem ? Thanks for help!
4   L A T E S T    R E P L I E S    (Newest First)
Sigake Posted - 06/08/2009 : 02:21:30 AM
Hello Greg,

1000 thanks for your help. I it so easy :o)



greg Posted - 06/05/2009 : 12:38:18 PM
Then the answer is:

Right-click in the upper-left corner of an empty worksheet
Choose ASCII Options..
Change 'Import Mode' to 'Start New Rows'
Click Update

Now in Windows Explorer, browse to the top-level folder with all your subfolders.

Press F3 or Ctrl+E or click Search button
Enter 'Spannung.txt' as the file to search for
(I think default is to search subfolders, but click Advanced and make sure 'Search Subfolders' is checked.)
Click 'Search Now'
Select all the found files (Ctrl+A is the shortcut)
Drag the files onto the Origin worksheet

Viola!

(Tip 'o the hat to user eparent..)
Sigake Posted - 06/05/2009 : 03:48:25 AM
Hello greg,

thanks for your answer. The problem is, I have more than 80 folder in which is the file "Spannung.txt". I canīt open all the folders manually and add the files.
greg Posted - 06/04/2009 : 5:56:17 PM
Is this what you have in mind?

Select File : Import : Multiple ASCII
Browse to each folder and Add the file you want
Check the 'Show Options Dialog'
Click OK
Choose 'Start New Rows' for 'Import Mode'
Click OK

The script equivalent is:
string fname; // Declare a string for our file list
fname$="D:\tmp\a\Spannung.txt
D:\tmp\b\Spannung.txt
D:\tmp\c\Spannung.txt"; // Fill the list
impasc options.impmode:=2; // Import all files by new rows

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