Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Extracting values after the maximum value in a txt file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Extracting values after the maximum value in a txt file
# 1  
Old 10-23-2018
Extracting values after the maximum value in a txt file
Hello,
I'm new to scripting and I need to write a bash script. Here is example of file on which I'm working:

Code:
      0.3092381      0.3262799      0.3425480      0.3578379      0.3719490
      0.3846908      0.3958855      0.4053738      0.4130160      0.4186991
      0.4223357      0.4238688      0.4232734      0.4205554      0.4157534
      0.4089370      0.4002056      0.3896858      0.3775293      0.3639085

I try to extract maximum value of this txt file. The maximum value is "0.4238688" here.
Then i just want to get values after this maximum value and add zeros for empty spaces. Like this;

Code:
     0.4238688      0.4232734      0.4205554      0.4157534      0.4089370
     0.4002056      0.3896858      0.3775293      0.3639085      0.0000000
     0.0000000      0.0000000      0.0000000      0.0000000      0.0000000
     0.0000000      0.0000000      0.0000000      0.0000000      0.0000000

Any suggestions?
Thank you




Moderator's Comments:
Mod Comment Please use CODE tags (for data as well) as required by forum rules!
Last edited by RudiC; 10-23-2018 at 05:09 PM.. Reason: Added CODE tags.
# 2  
Old 10-23-2018
I don't quite follow what 'add zeros for empty spaces' means, but you can start with below:
Code:
tr ' ' '\n' < myFile |sort -nr| paste -d' ' - - - - -

# 3  
Old 10-23-2018
Thank you for your help.

After i get the values following the maximum value, some values are missing and i want to replace this empty spaces with "0.0000000" to keep the number of total value in the txt file.
# 4  
Old 10-23-2018
Quote:
Originally Posted by jeo_fb
Thank you for your help.

After i get the values following the maximum value, some values are missing and i want to replace this empty spaces with "0.0000000" to keep the number of total value in the txt file.
Sorry, I still don't understand the meaning of some values are missing and i want to replace this empty spaces with "0.0000000"
# 5  
Old 10-23-2018
Sorry for the misunderstanding.

I have a txt file 5x5 like this;

Code:
           0.3092381      0.3262799      0.3425480      0.3578379      0.3719490
           0.3846908      0.3958855      0.4053738      0.4130160      0.4186991
           0.4223357      0.4238688      0.4232734      0.4205554      0.4157534
           0.4089370      0.4002056      0.3896858      0.3775293      0.3639085

I try to extract maximum value of this txt file. The maximum value is "0.4238688" here.
Then i just want to get values after this maximum value. Like this;

Code:
           0.4238688      0.4232734      0.4205554      0.4157534      0.4089370
           0.4002056      0.3896858      0.3775293      0.3639085

I have 9 string now. In the beginning i had 25 string because my matrix was 5x5.
Now i try to make this txt file until being 25 string and add some zeros like that;

Code:
           0.4238688      0.4232734      0.4205554      0.4157534      0.4089370
           0.4002056      0.3896858      0.3775293      0.3639085      0.0000000
           0.0000000      0.0000000      0.0000000      0.0000000      0.0000000
           0.0000000      0.0000000      0.0000000      0.0000000      0.0000000


Thank you




Moderator's Comments:
Mod Comment Please use CODE tags as required by forum rules!
Last edited by RudiC; 10-23-2018 at 05:11 PM.. Reason: Added CODE tags.
# 6  
Old 10-23-2018
I guess I don't understand how you get from the original:
Code:
0.3092381 0.3262799 0.3425480 0.3578379 0.3719490
0.3846908 0.3958855 0.4053738 0.4130160 0.4186991
0.4223357 0.4238688 0.4232734 0.4205554 0.4157534
0.4089370 0.4002056 0.3896858 0.3775293 0.3639085

matrix to this chopped-off version:
Code:
0.4238688      0.4232734      0.4205554      0.4157534      0.4089370
           0.4002056      0.3896858      0.3775293      0.3639085


What determines the chopping-off point?
Why not the entire sorted version of the original 5x5 matrix?
# 7  
Old 10-23-2018
So - "after this maximum" means "by position, by increasing column and then increasing row"?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

To extract values after the maximum value in a txt file

Hello, I'm new to scripting and I need to write a bash script. Here is example of file on which I'm working: 0.3092381 0.3262799 0.3425480 0.3578379 0.3719490 0.3846908 0.3958855 0.4053738 0.4130160 0.4186991 0.4223357 ... (1 Reply)
Discussion started by: jeo_fb
1 Replies

2. Shell Programming and Scripting

Taking key values from one file and extracting values from another file

Hi, I have two files with values in both. File1: cat 2 3 dog 4 5 elephant 6 7 camel 2 3 File2: ----+--gkf;ajf= ---+---- +----- cat -------=----+ 3 | 4 ----- dog ------++-- 5 | 9 ----++-- elephant | 5 | 7 ---++ camel ------ ++++_---- || 8 | 9 I want the final file as: cat 4... (1 Reply)
Discussion started by: npatwardhan
1 Replies

3. Shell Programming and Scripting

Extracting files having maximum timestamp

Hi , I'm using Ksh 88 I've the following files in a directory with YearMonthDate (Ex:20130601) YDT:FILE1:20130601 YDT:FILE1:20130615 YDT:FILE2:20130601 YDT:FILE2:20130615 YDT:FILE3:20130601 YDT:FILE3:20130615 And i need the files having maximum timestamp , Means i need to display ... (8 Replies)
Discussion started by: smile689
8 Replies

4. Shell Programming and Scripting

AWK, Perl or Shell? Unique strings and their maximum values from 3 column data file

I have a file containing data like so: 2012-01-02 GREEN 4 2012-01-02 GREEN 6 2012-01-02 GREEN 7 2012-01-02 BLUE 4 2012-01-02 BLUE 3 2012-01-02 GREEN 4 2012-01-02 RED 4 2012-01-02 RED 8 2012-01-02 GREEN 4 2012-01-02 YELLOW 5 2012-01-02 YELLOW 2 I can't always predict what the... (4 Replies)
Discussion started by: rich@ardz
4 Replies

5. UNIX for Dummies Questions & Answers

extracting values from file using perl

I would like to read value after $ symbol from a file. For eg a file will be having the following lines. 5,$0,-32768p,32767p,$400014f8,1,, 5,$0,0,0,$400008ce,1,, 5,$0,0,0,$400008d0,1,, i would like to read 400014f8 then 400014f8 and similar all the value after $ symbol.Can any one help... (1 Reply)
Discussion started by: jagadeeshrr
1 Replies

6. Shell Programming and Scripting

extracting values from configuration file

Dear All, i am new to shell scripting, I am working on embedded system based on linux.I am supposed to the read the configuration file and edit another file. presently I would like to read from the configuration file.It would be having values file one below. There is chance of entering... (6 Replies)
Discussion started by: Ratheendran
6 Replies

7. UNIX for Dummies Questions & Answers

Extracting values from an XML file

Hello People, I have an xml file from which I need to extract the values of the parameters using UNIX shell commands. Ex : Input is like : <Name>Roger</Name> or <Address>MI</Address> I need the output as just : Roger or MI with the tags removed. Please help. (1 Reply)
Discussion started by: sushant172
1 Replies

8. Shell Programming and Scripting

PERL:How to convert numeric values txt file to PACKED DECIMAL File?

Is there any way to convert numeric values txt file to PACKED DECIMAL File using PERL. Regards, Alok (1 Reply)
Discussion started by: aloktiwary
1 Replies

9. Shell Programming and Scripting

Help needed in extracting text present between two headers in .txt file

Hi All, Please help me out in fllowing problem. I have text file which contains the data in following format. Contents of file.txt are setregid02 Test that setregid() fails and sets the proper errno values when a non-root user attemps to change the real or effective... (2 Replies)
Discussion started by: varshit
2 Replies

10. Shell Programming and Scripting

Extracting records with unique fields from a fixed width txt file

Greetings, I would like to extract records from a fixed width text file that have unique field elements. Data is structured like this: John A Smith NY Mary C Jones WA Adam J Clark PA Mary Jones WA Fieldname / start-end position Firstname 1-10... (8 Replies)
Discussion started by: sitney
8 Replies
Login or Register to Ask a Question