AWK replacing tabs in last column with conditions -


i'm trying work dataset contains tabs delimiters, last column has custom field users able enter custom text, including tabs. i'm trying delete tabs using

awk "/\t/{c++;if(c==7){sub(\"\t\",\"\");c=0}}1" users10000.csv >users10000awk.csv

but seems there no delimiter between 6th , 7th column 7th empty.

what i'm trying replace tabs found after 7th if last field not empty through

awk /\t/{c++;if((c==7) && ($12!=\"\")){sub(\"\t\",\"\");c=0;}}1 usersorig.csv >usersorigawk.csv

but results in error

){sub(\"\t\" unexpected @ time.

i'm new awk , hoping work, formatting pain used to. chance help?

sample input:

100008949   esttrellitta    264 44  6853    0   28 dec 2009 18:01:42 gmt    el paso,tx. 100009841   chelseabex  152 50  394 0   28 dec 2009 18:05:43 gmt     100012792   erinpattisonn   984 666 5003    0   28 dec 2009 18:19:39 gmt    under bed. 100013967   tubeautifulrosa 323 251 1269    0   28 dec 2009 18:24:51 gmt    on  twitter ....... ahaahaa ! 100014135   geenajohnson    144 130 9789    0   28 dec 2009 18:25:37 gmt    arkansas 100015928   goosau  93  286 8075    0   28 dec 2009 18:33:59 gmt     10001882    rjwilson    1   340 6358    0   6 nov 2007 15:54:47 gmt iphone: 39.053871, 95.674576 100019750   hovminajjackson 135 136 6022    0   28 dec 2009 18:51:29 gmt    neverland 100020433   mattiebx    131 97  2610    0   28 dec 2009 18:54:40 gmt    zundert 100024321   katiestepek 64  93  503 0   28 dec 2009 19:13:08 gmt    hamilton 137179909   lalovesu    431 499 19568   0   26 apr 2010 01:45:05 gmt    oakland,\   ca

the last line 1 of culprits want edit.

perhaps want?

$ seq 10 | paste -sd'\t'  1       2       3       4       5       6       7       8       9       10  $ seq 10 | paste -sd'\t' | sed 's/\t/ /7g'  1       2       3       4       5       6       7 8 9 10

i think gnu-sed supports though. note, d'\t' default emphasize we're using tabs

update

to make work on tab delimited file row row

$ sed 's/\t/ /7g' input.file > output.file

Comments

Post a Comment

Popular posts from this blog

php - How to add and update images or image url in Volusion using Volusion API -

actually have store importing products store product data insert , update image or image url not insert , update. this xml code name datapro.txt. <products_joined> <productcode>3710_012t</productcode> <vendor_partno>eah5450silent/di/1gd3(lp)</vendor_partno> <productname>test product ta</productname> <hideproduct>n</hideproduct> <stockstatus>20</stockstatus> <lastmodified>1/5/2016 10:25:00 am</lastmodified> <lastmodby>2</lastmodby> <productweight>0.9</productweight> <productprice>100</productprice> <productmanufacturer>asus tek</productmanufacturer> <vendor_price>32.69</vendor_price> <numproductssharingstock>0</numproductssharingstock> <categoryids>107</categoryids> <producturl>http://tebkq.mvlce.servertrust.com/productdetails.asp?productcode=3710_012t</producturl>
Read more

javascript - jQuery UI Splitter/Resizable for unlimited amount of columns -

using jqueryui splitter or resizable functions want create layout allows unlimited amount of columns added , columns need resizable. so fiddle: https://jsfiddle.net/f3glh3mw/ but in fiddle html contains out of nested sets instead of inline. limits possibilities above fiddle can have equal widths 2,4,8,16,32 etc columns. in between shows crooked can see in fiddle. when researching came on question: jquery ui , splitter if @ top answer shows structure like: <div class="wrap"> <div class="resizable resizable1"></div> <div class="resizable resizable2"></div> </div> full fiddle: http://jsfiddle.net/8qztj/86/ which structure want javascript hardcoded 2 resizable items. so here question: how modify last fiddle works amount of .resizable divs. or know of plugin can this. thanks helping! so far found plugin: http://www.bacubacu.com/colresizable/ which says , close functionality want. in
Read more

javascript - IE9 error '$'is not defined -

Image
<!--[if lte ie 9]><html class="lte9"><![endif]--><!--[if gt ie 9]><html><![endif]--> <!--[if !ie]><!--> <html> <!--<![endif]--> blah blah <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.1/jquery.min.js"></script> <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script> <script src="{{ asset('js/mypage.js') }}" type="text/javascript"></script> </body> </html> when load page, ie9 brings error '$' not defined . how can solve error? +++ mypage.js $(function(){ //when load page, //ie9 tag not moving. $(window).load(function() { $('div.mask').hide(); }); // when click , willshow show. //for not ie 9 if (!$('html').hasclass('lte9')) { var = $('ul.about > li > span.activebtn');
Read more