bash - Renumbering of a column and replace of lines in the file -


i have file following. 1abc lines, want replace 1.line 3.line, 2.line 1.line, 3.line 4.line , 4.line 2.line. want same thing 2abc lines (in real file have 1abc,2abc,3abc...1000abc lines). after replacing lines, should renumber 3.column. how can (i have preserve spacing between columns in output file)?

input file:

1abc     c1    1   0.349   1abc     h2    2   0.123    1abc     o1    3   0.217   1abc     h4    4   0.180   2abc     c1    5   2.015  2abc     h2    6   0.573      2abc     o1    7   1.929     2abc     h4    8   1.867

requested output:

1abc     h2    1   0.123    1abc     h4    2   0.180  1abc     c1    3   0.349    1abc     o1    4   0.217 2abc     h2    5   0.573     2abc     h4    6   1.867   2abc     c1    7   2.015   2abc     o1    8   1.929

following script change third column of input file number require , output should sorted third field.

  1. script : torun.sh

filename="input.txt"

cat input.txt | while read line key=`echo $line | awk '{print $3}'` res=`echo $key % 4 | bc` newvalue=$key if [ $res -eq "0" ]         newvalue=`expr $key - 2` fi if [ $res -eq "1" ]         newvalue=`expr $key + 2` fi if [ $res -eq "2" ]         newvalue=`expr $key - 1` fi if [ $res -eq "3" ]         newvalue=`expr $key + 1` fi echo $line | awk -v v1="$newvalue" '{$3=v1; print}'

done

  1. how run : ./tunrun.sh | sort -k 3

  2. please note awk changes delimiter of column single space. not sure whether multiple space or tab delimiter. can fix script display line correct delimiter once confirm.


Comments

Post a Comment

Popular posts from this blog

java - Spring Data JPA: Why findOne(id) executing delete query internally? -

i have 1 application using @manytomany annotation link 2 different entities 1 parent entity. not sure if have implemented properly. when execute .findone() on parent entity's repository find it, @ first fetch data along executing delete queries internally delete record mapping table (a table jpa creates after adding @manytomany annotation.). following generated sql queries , code snippet: java class @entity @table(name = "inventory") public class inventory { @id long id; // many other properties @manytomany(fetch=fetchtype.lazy) private list<stream> streams; @manytomany(fetch=fetchtype.lazy) private list<subject> subjects; } there no other annotation i've put in stream , subject entity class link inventory class. when run app, create following tables: inventory stream subject inventory_stream inventory_subject (inventory_stream , inventory_subject, 2 tables created automatically, don't k...
Read more

python - Mongodb How to add addtional information when aggregating? -

i beginner , wrote line pipeline works, wanna add other information output, screen name , or number of tweets.i tried add under $group gave me syntax error everytime here pipeline: def make_pipeline(): # complete aggregation pipeline pipeline = [ { '$match': { "user.statuses_count": {"$gt":99 }, "user.time_zone": "brasilia" } }, { "$group": { "_id": "$user.id", "followers": { "$max": "$user.followers_count" } } }, { "$sort": { "followers": -1 } }, { "$limit" : 1 } ]; i using on example : { "_id" : objectid("5304e2e3cc9e684aa98bef97"), "text" : "first week of school on :p", "in_reply_to_status_id" : null, "retweet_count" : null, ...
Read more

java - Incorrect order of records in M-M relationship in hibernate -

Image
i have 4 records in bridge table in mysql database. using @manytomany in hibernate, accurate order of employees incorrect incorrect of projects. following required material figure out doing mistake. this source. @entity @table(name="project") public class projectbean { @id @generatedvalue @column(name="project_id") private int projectid; @column(name="title") private string projecttitle; @manytomany(mappedby="projects") private collection<employeebean> employees; public projectbean() { employees = new arraylist<employeebean>(); } //getters & setters } @entity @table(name="employee") public class employeebean { @id @generatedvalue @column(name="employee_id") private int employee_id; @column(name="first_name") private string ...
Read more