Forum Discussion

YAP hwee yatt's avatar
YAP hwee yatt
Copper Contributor
Jul 08, 2018

Excel files modification help

Hi Girls and Boys,

 

Will be greatly appreciate if someone could give me some insight on whether this is something can be done.

 

I got a lot of excel/txt file that need to add one line of coluum on top. Here is what I really meant:

 

From:

 

"Loading,1.024,0.3725408,0.01414836,0, , ,0.3725408,0.05317445,0, , , , , , , , ,0.003700595,0, , , , ,0,0, , , , , "
"Loading,2.304,1.039208,0.04485469,0, , ,1.039208,0.08378078,0, , , , , , , , ,0.02530482,0, , , , ,0,0, , , , , "
"Loading,3.584,2.147026,0.08137956,0, , ,2.147026,0.1201395,0, , , , , , , , ,0.08322852,0, , , , ,0,0, , , , , "

 

Into 

"TD;50mN_v3.000;0;0.03908197;0;0.2103292;0.0575648;0:0:0;21/05/18:11:31:02;True;0.00015;; ;2;0;0;82.53362;Poly2/80%;1;,t (sec),P (raw),ht (raw),S,Lateral Force (mN),Lateral Distance (um),P (mN),ht (um),ADC 1/0,hc,a,dP/dh,E*(GPa),H (GPa),Position(um),Friction,E (GPa),Up (nJ),Ue (nJ),E1,E2,n1,n2,AE/C,AE/S,h corr,HV,HM,-,-"
"IC,0,0.1503822,-6.101884E-05,0, , ,0.1503822,0.03902095,0, , , , , , ,, ,0,0, , , , ,0,0, , , , , "
"Loading,1.024,0.3725408,0.01414836,0, , ,0.3725408,0.05317445,0, , , , , , , , ,0.003700595,0, , , , ,0,0, , , , , "
"Loading,2.304,1.039208,0.04485469,0, , ,1.039208,0.08378078,0, , , , , , , , ,0.02530482,0, , , , ,0,0, , , , , "
"Loading,3.584,2.147026,0.08137956,0, , ,2.147026,0.1201395,0, , , , , , , , ,0.08322852,0, , , , ,0,0, , , , , "

No RepliesBe the first to reply