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
 Missing CSV data?

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
AMHumphries Posted - 09/20/2006 : 09:12:13 AM
Origin Version (Select Help-->About Origin): Pro 7.5 SR4
Operating System: Windows XP

I am opening a .csv file in Origin that consists of 10 columns of data, the first 9 are numeric and the 10th is an alphanumeric string in the format "11239834234_06_JUL_2006_10_20_39". When I open the .csv file in Microsoft Excel, the string is present. However, when I open the .csv file in Origin the 10th column is empty.

Has anyone encountered this problem before? And if so can it be fixed?

6   L A T E S T    R E P L I E S    (Newest First)
AMHumphries Posted - 09/21/2006 : 08:58:44 AM
Thanks for all your help Mike, a colleague provided me with a template that works so it's sorted now.

Mike Buess Posted - 09/21/2006 : 08:25:46 AM
I can't reproduce that with 4-column csv files. Please post the first 5 or 6 lines of your 10-column file including header, if any.

Mike Buess
Origin WebRing Member
AMHumphries Posted - 09/21/2006 : 05:26:42 AM
Yes, the ASCII options on the template are set to import 10 columns. I can't understand for the life of me why it is importing 9 columns of data, and then not including the 10th column (even though it is only one cell of data).

Mike Buess Posted - 09/20/2006 : 5:46:06 PM
Apparently you are importing to a custom template called MULTI. Are it's ASCII options set to import 10 columns?

Mike Buess
Origin WebRing Member
AMHumphries Posted - 09/20/2006 : 10:03:37 AM
A script using the following code:


// Open files and place them in new, seperate worksheets
fdlog.path$ = "C:\MATLAB71\PIMS\"; // set fdlog's default path
fdlog.ShowComment = 0;
fdlog.UseGroup(Ascii);
if (fdlog.MultiOpen() != 0/0);
{
loop (ii, 1, fdlog.MultiOpen.Count)
{
window -t data MULTI;
fdlog.Get(A, ii);
open -w %A;
%B = %H;
window -r %B Sheet$(ii);
}
}

// Merge all worksheets into one dataset
fileCount = fdlog.MultiOpen.Count;
if (fileCount == 0)
{
type -b "Error: No files have been selected for loading.";
return; // exit the script
}
else if (fileCount > 10)
{
type -b "Error: Too many files selected. Maximum number is 10.";
return; // exit the script
}
else
{
// copy col D from sheet represented by count to the column
// represented by count in multiWks
window -t data MULTI;
%B = %H;
window -r %B multiWks;
loop (jj, 1, fileCount)
{
%(multiWks,jj) = Sheet$(jj)_D;
%J = Sheet$(jj)_J;
%K = "\L($(jj)) %J";
}
}


Mike Buess Posted - 09/20/2006 : 09:28:22 AM
How are you importing? (Wizard, Import ASCII or script)

Mike Buess
Origin WebRing Member

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