The code shown below saves the data shown below into a .mdf file, however, I cant figure out how to keep JMP from writing the quotation marks shown at the beginning of the saved data. How do I get rid of these quotation marks?
DataCV=open("C:\Desktop\JMP\sample_data.csv");
Summarize( DataCV, processArray = By( :process ) );
For( m = 1,
m <= Length( processArray ),
m++, // Generates and saves all Cdg splines
Eval(
Substitute(
Expr(
biv = Bivariate(
Y( :c_mm_deembed_pf ),
X( :v_dut_volt ),
Where( :c_type == "Cdg" & :process == __process__ ),
Fit Spline( 0.1, standardized, {save predicteds} )
)
),
Expr( __process__ ), processArray[m]
)
)
);
(Data Table( DataCV ) << Tabulate( // Create new table
Add Table(
Column Table( Analysis Columns( :Spline Predictor for c_mm_deembed_pf Where ) ),
Row Table( Grouping Columns(:serial_num, :process, :c_type, :v_dut_volt ) )
)
)) << Make Into Data Table;
currentDataTable()<<AddRows(1); // Add an empty last row so while loop knows when its at the end
q = 0;
proc = "new";
i = 1;
while(q == 0, // Delete redundant splines (:process x :c_type combinations)
if (proc != :process[i],
proc = :process[i]; sn = :serial_num[i]; i+=1
);
if (proc == :process[i] & sn == :serial_num[i],
i+=1
);
if (proc == :process[i] & sn != :serial_num[i],
CurrentDataTable()<<DeleteRows(i)
);
if (:process[i] == "",
q = 1;
);
);
currentDataTable() << Delete Rows(i); // Delete empty last row
currentDataTable() << new column("Index", character);
cap = "new";
for (k = 1, k<=NRows(currentDataTable()), k++, // Add VARs for ADS indexing
if (cap != :c_type[k],
currentDataTable() << Add Rows(1, k-1); j=1; cap = :c_type[k+1]; proc = :process[k+1]
);
if (j==1,
For Each Row(:Index = if(:c_type=="", // This is where the quotation marks originate from
"\!NVAR CURVE(1) = " || char(cap) || "\!NVAR TECH(1) = " || char(proc) || "\!NBEGIN\!N% ind(1) dep(1)",
:Index));
For Each Row(:c_type = if(:c_type=="",
char(cap),
:c_type)); j=0
);
);
currentDataTable() << delete columns("c_type", "serial_num", "process"); // Delete all rows except for ind(1) and dep(1)
xptPref = Get Preferences( Export Settings ); // .MDF format
Preferences(
ExportSettings(
End Of Line( CRLF ),
End Of Field( Tab ),
Export Table Headers( 0 )
)
);
currentDataTable () << Save As( "C:\Desktop\JMP\GeneratedFiles\RoughDraft2Output.mdf", "text" ); // Save as .MDF, however, i dont want any quotes
"
VAR CURVE(1) = Cdg
VAR TECH(1) = G50V3-3
BEGIN
% ind(1) dep(1)"
0.1392 3.1931865994
1.139 2.7623010959
2.1344 2.3391306476
3.1346 1.9319516519
4.0714 1.5817641476
5.0892 1.2466683948
6.0128 0.9880976277
6.971 0.7661291093
7.8366 0.6040645312
8.7254 0.4720246289
9.5982 0.3719428625
10.379 0.303489106
11.2286 0.2476917169
12.0762 0.2076956614
12.8542 0.1818554683
13.715 0.1626401602
14.5604 0.1510540199
15.486 0.1444224576
16.365 0.1422448881
17.274 0.1427599758
18.1818 0.1449372904
19.0986 0.1479270102