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 for Programming
 LabTalk Forum
 Import CSV

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
sarastokes Posted - 11/12/2015 : 12:44:44 AM
Origin Ver. and Service Release (Select Help-->About Origin): b9.2.272
Operating System: Windows 10

I am trying to import CSV files into separate columns with the file name in the comments section. When I import many files, I get two filenames in each comments section, the name of the file imported in the previous column and the name of the file imported into the current column. How can I avoid this?

These are the options I've selected in the import dialog:
1st File Import Mode - Start New Columns
Multi-File (except 1st) Import Mode - Start New Columns
I checked "Append File name to Column Comment", unchecked "Include File Path when Appending File name" and am using a partial import.
3   L A T E S T    R E P L I E S    (Newest First)
sarastokes Posted - 11/15/2015 : 02:52:16 AM
In case anyone else has this problem, here's a solution around the bug:

Under Import Options --> Scripts, I updated the Script after each file imported to:

NC=wks.ncols;
col($(NC))[C]$="";

This clears the comment appended to the next column before another CSV file is imported.
sarastokes Posted - 11/15/2015 : 02:35:42 AM
I downloaded Origin 2016 but I'm still having the same problem
Liamn Posted - 11/12/2015 : 8:33:38 PM
Hi,

This is a bug in Origin 2015, and it has been fixed in Origin 2016.
Please try it out:
http://www.originlab.com/myorigin2016download

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