| T O P I C R E V I E W |
| oszkoa |
Posted - 12/10/2004 : 3:12:06 PM
Hi,
I got a file with a weird structure to try to plot it with Origin. Here is an excerpt, sorry for the size:
ASCII MID CYCLES : 1208a.mdc
DATE : 2004.12.08 TIME : 11:47:42 du.
CONVERTED CYCLES : 2999
Number of stored cycles 2999
Printed start cycle 1
Printed end cycle 2999
Number of stored datablocks 1
Datablock 0 Ion Current [A]
'0/0' 2.00 min: -1.09359E-010 max: -7.3751E-011
'0/1' 4.00 min: -6.46137E-010 max: 2.00606E-009
'0/2' 15.00 min: -9.41714E-012 max: 2.22951E-009
'0/3' 16.00 min: -1.03604E-012 max: 2.74402E-009
'0/4' 17.00 min: 2.24452E-011 max: 7.9272E-011
'0/5' 18.00 min: 6.77474E-011 max: 9.74748E-011
'0/6' 28.00 min: -2.28228E-011 max: 3.65324E-010
'0/7' 32.00 min: -2.1565E-012 max: 4.23087E-011
'0/8' 40.00 min: -4.27063E-012 max: -7.80781E-013
'0/9' 44.00 min: -6.09574E-012 max: 4.27224E-009
Cycle Date Time RelTime[s] '0/0' '0/1' '0/2' '0/3' '0/4' '0/5' '0/6' '0/7' '0/8' '0/9'
1 2004.12.08 11:47:42 du.:33 0.33 -1.0864E-010 1.83957E-009 -9.36118E-012 -1.03604E-012 2.26545E-011 7.09027E-011 -2.18218E-011 3.458E-013 -4.11229E-012 -5.992E-012
2 2004.12.08 11:47:43 du.:15 15.jan -1.04059E-010 2.00606E-009 -9.21967E-012 -2.20221E-013 2.58122E-011 7.96387E-011 -8.32196E-012 2.80098E-012 -3.84839E-012 -5.72492E-012
Unfortunately long lines seem to be wrapped here. These kinds of files are created by a mass spectrometer software. The first 22 lines are headers. I intend to import the 22nd line as labels (the line beginning with Cycle Date and endingwith '0/9'). '0/0' ...'0/9' mean different atomic masses as listed in the Datablock section of the header. This means 14 columns, but when I try to import the file with the wizard it adds an extra 15th empty column and I can't get rid of it. I also experimented with the traditional Import: ASCII options dialog box and it imported 14 columns. The other oddity is the time format, e.g. 11:47:42 du.:33. We do not know what du.:33 refers to and how can it be omitted. I would prefer the wizard because of the Save filter option.
I would appreciate if anybody could help me.
Thanks: oszkoa |
| 3 L A T E S T R E P L I E S (Newest First) |
| oszkoa |
Posted - 12/15/2004 : 05:25:43 AM
Hi all,
I could nearly cope with the problem caused by the unusual time format. Unfortunately another problem emerged I could not solve yet. Given 4 columns selected in a worksheet how can I tell Origin (in LabTalk) that I want to use a Vert2Panel template with 3 curves in the lower panel and one in the upper one? I experimented with run.section command but I was not able to tell Origin which plot is intended in the two layers.
Many thanks,
Oszkoa |
| oszkoa |
Posted - 12/13/2004 : 06:11:47 AM
Dear rlewis,
Thank you for your suggestion. Unfortunately the lack of space in RelTime[s] is a fault of the mass spectrometer software. It is automatically generated and we can't help it. The original file format is *.mdc (binary) which can be saved into *.asc which seems to inherit this mistake. It is a shame that I did not realize that the delimiter is space and not tab. In the meantime I made use of the additional column to store the ratio of columns '0/3' and '0/9'. I also included in the filter some modifications in the worksheet and plotting the data after import. This was only partly successful because after changing the labels from '0/i' to the real atomic masses (2, 4, ...44) with the wks.coln.label$ command the axis titles were lost.
Does anybody have an idea why?
Thanks
oszkoa |
| rlewis |
Posted - 12/12/2004 : 1:27:05 PM
The problem is that the line beginning "Cycle Date Time ...." contains 14 space delimited tokens whereas the following lines contain 15 space delimited tokens. Since the data encoded in "du.:33 ..." is expendedable, the simplest fix to your problem is to edit the line beginning "Cycle Date Time ..." and alter "RelTime[s]" to "RelTime [s]". The addition of this extra space will create a line with 15 space delimited tokens and the import wizzard will then be able to line-up columns and labels correctly. You can then delete the columns labeled "RelTime" and "s" after import. |
