7245_en-US

liliconcom

Data Manipulate<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

Hi, I'm quite new in JMP. below is my raw data, they are squeeze in the same cell, each row is one lot information

any solotion to split and organize in nice order as below ? many thanks

Raw Data before:

re-organized raw data that I intend to get :

Re: Data Manipulate

thanks . but I'm not good at JSL, takes some time to digest

Re: Data Manipulate

With such data, I think I would give the text file a grep-treatment before importing to JMP.

However try the script below. It should produce a new table with the data organized in different columns. It is assumed that there are no missing data, i.e. always the same number of entries in the same order.

dt = Current Data Table();

col = Column( dt, "Raw Data" );

//Make list of names and data

L = Words( col[1], "();" );

//Define positions of data in L

m_data = (1 :: N Items( L ) / 2) * 2;

// Make list of column names

names = L[m_data-1];

n = N Items( names );

For( i = 1, i <= n, i++, names[i] = Trim( names[i] ) );

//Build matrix of all data

m = [];

For Each Row(

  L = Words( col[], "();" );

  L_data = L[m_data];

  For( i = 1, i <= n, i++,

  L_data[i] = Num( L_data[i] )

  );

  m ||= Matrix( L_data );

);

//Make new table

As Table( Transpose( m ), <<column names( names ) )<<set name("Organized Data");