shell - Remove alphanum,num,email and other special char from the 6th field of a file -


my city field ie 6th field has got addr,door #, email addr , special char in it,which getting job harder.i wanted replace numbers, email id,special char , other address city field of file blank space. want valid city names in there. tried awk awk -f'|' '$6 ~ /^[ ]*[0-9]{5}[ ]*$/', not getting me want. can me in advising soln or tell me i'm going wrong.i'm great have participation here.sorry making page convoluted

my data like:

name,age,loc,num,st,city,postal,sal,year,status1,status2,status3,s4 

garry",30",us",7373",ny",newyork",7900",100",2010",0",0",0",0 raj",40",in",1291",in",newdelhi",8790",100",2012",1",1",1",1 kris",24",us",6328",nj",9012 cain street",8739",200",2012",0",1",1",1 romy",57",it",5623",oh",1900 obama st #4",3434",200",2013",1",1",1",1 tim",70",us",4004",ca",#205",9898",900",2017",1",1",1",1 steve",40",us",5656",wa",steveran@gmail.com",9123",289",2012",0",0",0",0 donald",34",us",3902",ca",donal@gmail.com",1290",300",2010",0",0",0",0 jaby",23",us",7800",wa",100-120",2900",100",2014",1",1",1",1 koay",25",us",8900",ca",apt. p120",1000",100",2011",1",0",1",1 james",30",us",3499",in",b290",8900",200",2019",0",1",",1 jake",29",us",5609",ma",3091",4901",200",2019",1",1",1",0 jon",40",us",3490",ih",2901 jakestall st 198",6790",100",0",0",",0",0 wayne",34",us",2679",wa",washington",349",9",9",9",9",9",9

output has be: name,age,loc,num,st,city,postal,sal,year,status1,status2,status3,st4

garry",30",us",7373",ny",newyork",7900",100",2010",0",0",0",0 raj",40",in",1291",in",newdelhi",8790",100",2012",1",1",1",1 kris",24",us",6328",nj",",8739",200",2012",0",1",1",1 romy",57",it",5623",oh",",3434",200",2013",1",1",1",1 tim",70",us",4004",ca",",9898",900",2017",1",1",1",1 steve",40",us",5656",wa",",9123",289",2012",0",0",0",0 donald",34",us",3902",ca",",1290",300",2010",0",0",0",0 jaby",23",us",7800",wa",",2900",100",2014",1",1",1",1 koay",25",us",8900",ca",",1000",100",2011",1",0",1",1 james",30",us",3499",in",",8900",200",2019",0",1",",1 jake",29",us",5609",ma",",4901",200",2019",1",1",1",0 jon",40",us",3490",ih",",6790",100",0",0",",0",0 wayne",34",us",2679",wa",washington",349",9",9",9",9",9",9

awk solution:

$ awk 'begin{fs=ofs=","} {$6=substr($6,1,length($6)-1);if ($6~/[^[:alpha:][:blank:]]/) $6=""}1' input.txt

breakdown:

begin{fs=ofs=","}                         # input , output field separator "," { $6 = substr($6,1,length($6)-1);         # rid of trailing " in column 6   if ($6  ~ /[^[:alpha:][:blank:]]/)      # if col 6 contains char that's                                            #   not alphabetic or space      $6=""                                # empty col 6 }1                                        # print every line

-

Comments

Post a Comment

Popular posts from this blog

c# - Binding a comma separated list to a List<int> in asp.net web api -

the default binder in web api expecst http://url.com/webapi/report/?pageids=3243&pageids=2365 to bind public ihttpactionresult report(list<int> pageids){ // exciting webapi code} i wish bind http://url.com/webapi/report/?pageids=3243,2365 as running out of space in url get . i have created class public class commaseparatedmodelbinder : system.web.http.modelbinding.imodelbinder { public bool bindmodel(httpactioncontext actioncontext, modelbindingcontext bindingcontext) { //binding in here } } and registered in webapiconfig.cs var provider = new simplemodelbinderprovider( typeof(list<int>), new commaseparatedmodelbinder()); config.services.insert(typeof(modelbinderprovider), 0, provider); i have altered method signature use model binder so public ihttpactionresult report( [modelbinder] list<int> pageids){ // exciting webapi code} however break point in binder not being
Read more

Delphi 7 and decode UTF-8 base64 -

in delphi 7, have widestring encoded base64(that received web service widestring result) : pd94bwwgdmvyc2lvbj0ims4wij8+dqo8c3ryaw5nptiq2lpyqjwvc3ryaw5npg== when decoded it, result not utf-8: <?xml version="1.0"?> <string>طھط³طھ</string> but when decoded base64decode.org, result true : <?xml version="1.0"?> <string>تست</string> i have use encddecd unit decodestring function. the problem have using decodestring . function, in delphi 7, treats decoded binary data being ansi encoded. , problem text utf-8 encoded. to continue encddecd unit have couple of options. can switch decodestream . instance, code produce utf-8 encoded text file data: {$apptype console} uses classes, encddecd; const data = 'pd94bwwgdmvyc2lvbj0ims4wij8+dqo8c3ryaw5nptiq2lpyqjwvc3ryaw5npg=='; var input: tstringstream; output: tfilestream; begin input := tstringstream.create(data); try output := tfilestream.
Read more

html - Is there any way to exclude a single element from the style? (Bootstrap) -

so, have img logo, overlaid on div styled background-image: url("...") , , both elements inside 2 div classes .to-color , .to-overlay respectively, black transparent overlay. is there way exclude logo style given these 2 classes? here's jsfiddle example: link html , css example: - html - <div class="to-color"> <div class="to-overlay"> <div class="respo"> <div class="row"> <div class="col-xs-4 col-xs-offset-4 text-center"> <img src="http://ansonalex.com/wp-content/uploads/2011/06/google-logo-768x260.png" alt="..." class="img-responsive"> </div> </div> </div> </div> </div> - css - .to-color { background-color: #000; } .to-overlay { opacity : 0.5; } .respo { background-image: url("https://source.unsplash.com/category/objects/1600x900"); background-position: center center;
Read more