Hi everyone, this is my first post in this community. I recently changed job and will do lots of prober bench test and data analysis. Used JMP a little bit, but nothing advanced at all.
Right now, my test always generate a big CSV file and the measurement data are buried together with uninterested info (such as test set up, conditions, etc.), I would like to get some help to pull the useful info out using JMP script and from here, start my advanced script learning.
I explain my task in the attached screenshot. The top right is a single I-V sweep data point example (to measure R) to give you an idea of what my gigantic CVS looks like (it contains hundreds of such structures). "Multi-row uninterested info" represents those useless rows that I don't want to import. Besides copy and paste the I/V/R data portion, I also like to extract the wafer lot id, wafer id, reticle (or say stepper field) index, and subsite number out of some strings. The top right box shows my desired JMP output.
As optional read, there are some trivia in the bottom two boxes. Bottom left is my general comments on the data structure, and bottom right explains the meanings of the strings where I need to extract certain info out.
Hope the screenshot provides you enough info for my question. I used to do such work using Excel VBA Macro: scan search signature strings, then selectively importing certain character/string/row near that location, and then continue search till the end of the raw data file. I wonder JMP script would do the same?
