specific importing problem, rows to columns

Share icon

Hi everyone

I got stuck with importing data output as attached to this post. I would like to import data from the following blocks:

Parameter Statistics
Peak 1 Voigt Area
Parm Value Std Error t-value 95% Confidence Limits
Area 1 2 3 4 5
Ctr 6 7 8 9 10
Wid 11 12 13 14 15
Shpe 16 17 18 19 20

Peak 2 Voigt Area
Parm Value Std Error t-value 95% Confidence Limits
Area 21 22 23 24 25
Ctr 26 27 28 29 30
Wid 31 32 33 34 35
Shpe 36 37 38 39 40

etc. ...

into the following 3 waves:

filename_Peak filename_ctr file_name_Std_err
1 6 7
2 26 27
...

the complication is that the number of peaks varies

Sorry for posting such a general problem, I am igor beginner

Thanks!

Edit: please take the above example as a generic one, the attached file contains realistic numbers.
 30.txt (21.44 KB)
I don't see where the values 0.24200661 and 0.19874393 come from. They don't appear in 30.txt as far as I can tell.

October 5, 2016 at 10:37 am - Permalink

I have written a procedure to load this data and will attach it. For details, read the comments.

I'd like to know what software generates this file format for future reference.
Load Remo Data.ipf (6.46 KB)

October 6, 2016 at 10:53 am - Permalink

Fantastic, thank you very much! I didn't know about layers for waves but it works very well with this data.

Now I don't know if this is asked for too much since you already helped a lot but would it be possible to add a 4th and a 5th column containing the values of the "Amplitude" and "FWHM" columns of the block "Measured Values" (second block of the file). They don't come with statistical information though.

Concerning naming of the output wave at the end, I changed

Wave remoOutputData = CreateOutputDataWave("outputData", remoRawData)

to

Wave remoOutputData = CreateOutputDataWave(S_fileName, remoRawData)

..which would give me "30.txt" as a result. Is there a way to have the .txt extension removed?


These data files come from the program PeakFIT, commonly used in analysis of Raman spectra.

October 7, 2016 at 02:08 am - Permalink