bash - add new line after number of commas -



bash - add new line after number of commas -

i have long line:

kvm1.example.corp,18:18:48,x86_64,16,11,11,0,0,0,0,0,11,0,4.6,99056376,4980736,4980736,5450000000,1,s-75-vm,460000000.,0.385304090422,262144,0,0,3,743,0,2,v-30-vm,450000000.,0.376927914543,1048576,1,0,6,7676,4765,3,r-80-vm,430000000.,0.360175562786,131072,0,0,0,208,0,5,i-2-81-vm,10000000.,0.00837617587873,1048576,1,0,0,0,0,6,r-83-vm,430000000.,0.360175562786,131072,0,0,0,156,0,7,i-3-82-vm,710000000.,0.59470848739,524288,0,0,0,0,0,8,r-85-vm,410000000.,0.343423211028,131072,0,0,0,208,0,11,i-3-84-vm,710000000.,0.59470848739,524288,0,0,0,0,0,12,i-2-79-vm,690000000.,0.577956135633,524288,0,0,2,0,0,13,r-87-vm,420000000.,0.351799386907,131072,0,0,0,156,0,14,i-3-88-vm,730000000.,0.611460839147,524288,0,0,2,0,0

i'm trying output

1,s-75-vm,460000000.,0.385304090422,262144,0,0,3,743,0, 2,v-30-vm,450000000.,0.376927914543,1048576,1,0,6,7676,4765, 3,r-80-vm,430000000.,0.360175562786,131072,0,0,0,208,0, 5,i-2-81-vm,10000000.,0.00837617587873,1048576,1,0,0,0,0, 6,r-83-vm,430000000.,0.360175562786,131072,0,0,0,156,0, 7,i-3-82-vm,710000000.,0.59470848739,524288,0,0,0,0,0, 8,r-85-vm,410000000.,0.343423211028,131072,0,0,0,208,0, 11,i-3-84-vm,710000000.,0.59470848739,524288,0,0,0,0,0, 12,i-2-79-vm,690000000.,0.577956135633,524288,0,0,2,0,0, 13,r-87-vm,420000000.,0.351799386907,131072,0,0,0,156,0, 14,i-3-88-vm,730000000.,0.611460839147,524288,0,0,2,0,0

i'm not sure strategy should take add together new line after 9th comma after removing header?

simpler sed:

$ sed -r 's/([^,]+,){18}//;s/(([^,]+,){10})/\1\n/g' file 1,s-75-vm,460000000.,0.385304090422,262144,0,0,3,743,0, 2,v-30-vm,450000000.,0.376927914543,1048576,1,0,6,7676,4765, 3,r-80-vm,430000000.,0.360175562786,131072,0,0,0,208,0, 5,i-2-81-vm,10000000.,0.00837617587873,1048576,1,0,0,0,0, 6,r-83-vm,430000000.,0.360175562786,131072,0,0,0,156,0, 7,i-3-82-vm,710000000.,0.59470848739,524288,0,0,0,0,0, 8,r-85-vm,410000000.,0.343423211028,131072,0,0,0,208,0, 11,i-3-84-vm,710000000.,0.59470848739,524288,0,0,0,0,0, 12,i-2-79-vm,690000000.,0.577956135633,524288,0,0,2,0,0, 13,r-87-vm,420000000.,0.351799386907,131072,0,0,0,156,0, 14,i-3-88-vm,730000000.,0.611460839147,524288,0,0,2,0,0

bash scripting sed awk

Comments

Post a Comment

Popular posts from this blog

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer -

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer - when trying request rest service @ time of response getting exception.. feb 21, 2013 2:34:49 pm com.sun.jersey.spi.container.containerresponse mapmappablecontainerexception severe: exception contained within mappablecontainerexception not mapped response, re-throwing http container java.lang.noclassdeffounderror: not initialize class net.sf.cglib.proxy.enhancer @ org.hibernate.proxy.pojo.cglib.cgliblazyinitializer.getproxyfactory(cgliblazyinitializer.java:117) @ org.hibernate.proxy.pojo.cglib.cglibproxyfactory.postinstantiate(cglibproxyfactory.java:43) @ org.hibernate.tuple.entity.pojoentitytuplizer.buildproxyfactory(pojoentitytuplizer.java:162) @ org.hibernate.tuple.entity.abstractentitytuplizer.<init>(abstractentitytuplizer.java:135) @ org.hibernate.tuple.entity.pojoentitytuplizer.<init>(pojoentitytuplizer.java:55) @ org.hibernate.tuple.e...
Read more

Accessing MATLAB's unicode strings from C -

Accessing MATLAB's unicode strings from C - how can access underlying unicode info of matlab strings through matlab engine or mex c interfaces? here's example. let's set unicode characters in utf-8 encoded file test.txt, read as fid=fopen('test.txt','r','l','utf-8'); s=fscanf(fid, '%s') in matlab. now if first feature('defaultcharacterset', 'utf-8') , c engevalstring(ep, "s") , output text file utf-8. proves matlab stores unicode internally. if mxarraytostring(enggetvariable(ep, "s")) , unicode2native(s, 'latin-1') give me in matlab: non-latin-1 characters replaced character code 26. need getting access underlying unicode info c string in unicode format (utf-8, utf-16, etc.), , preserving non-latin-1 characters. is possible? my platform os x, matlab r2012b. addendum: documentation explicitly states "[mxarraytostring()] supports multibyte encoded characters...
Read more

javascript - mongodb won't find my schema method in nested container -

javascript - mongodb won't find my schema method in nested container - i trying access method of schema stored within mixed container. here situation : have cases model can many different things, have schema each of these things stored in "casecontent" mixed property. var caseschema = mongoose.schema({ casecontent : {}, object : {type:string, default : "null"}, collision : {type : boolean, default : false} }); the casecontent property filled model of 1 of schemas, 1 exemple : var treeschema = new mongoose.schema({ applecount : {type : number, default : 3} }); treeschema.methods.dostuff = function (data) { console.log('hey, listen'); homecoming true; }; then, want utilize method of schema original container : caseschema.methods.dostuff = function (data) { if (this.casecontent.dostuff !== undefined) { this.casecontent.dostuff(); console.log('it worked'); } else { ...
Read more