script to sort a string of numerical data in set fields Post: 302397366

Sponsored Content

Top Forums Shell Programming and Scripting script to sort a string of numerical data in set fields Post 302397366 by clx on Monday 22nd of February 2010 01:46:16 AM

02-22-2010

Registered User

Code:

/home/forum->cat f
1938388287220111092928282181818
5678388287220111092928282181818
1938388287220111092928282181818
1938388286660111666609082181818
1938388287220111092928282145678
1938388287545676788968999181818
1938388287220111092928282181818
1938388287220111092928282181818
/home/forum->awk '{A=substr($0,1,5);B=substr($0,6,8);C=substr($0,14,3);print A,B,C}' f
19383 88287220 111
56783 88287220 111
19383 88287220 111
19383 88286660 111
19383 88287220 111
19383 88287545 676
19383 88287220 111
19383 88287220 111
/home/forum->

you can put more than one files after the command. or even wild card.

Last edited by clx; 02-22-2010 at 03:19 AM.. Reason: typo

clx

View Public Profile for clx

Find all posts by clx

9 More Discussions You Might Find Interesting

1. Programming

Adding files of numerical data

Hi I was hoping that maybe someone could help me with a small piece of C code. I have a number of files, which are all of similar layout ie. three lines of text and 5-6 columns of numerical data. I need to add each of the elements of the second column in one file to their counterparts in the second...

2. Shell Programming and Scripting

How to strip non numerical data out of file?

Hi, How can I remove all non numerical data from line, so I don't want to delete the line but to have only the numbers. e.g.: ######### 123 aaa124 125bbb 126 127 ######### So I want all the leading and trailing non numerical stuff(letters/white space/tabs anything else except...

3. Shell Programming and Scripting

Script to sort data

Hi All, I have a .csv file with 3 columns called nLats, nLongs, and fRes. in following format : "nLats","nLongs","fRes" 0,0,-1 0,1,-1 0,2,-1 0,3,-1 0,4,-1 ......... ......... 0,143,-1 nLats increments at nLongs=143 1,0, -1 1,1, -1 .......... .......... 1,143,-1...

4. Shell Programming and Scripting

Reading Numerical Binary Data using KSH

Hi, I've searched and couldn't find anyone else with this problem. Is there anyway (preferably using ksh - but other script languages would do) that I can read in binary float data into a text file. The data (arrays from various stages of radar processing) comes in various formats, but mainly...

5. Shell Programming and Scripting

Sort numerically a non numerical

Hello, I have this sample data: 01 * * * * 01 * * * * 01 * * * * 01 * * * * 01 0 * * * 01 0 * * * 01 0 * * * 01 0 * * * 02 * * * 0 02 * * * 0 02 * * * 6 02 * * * 6 02 0 * * 1 02 0 * * 1 02 0 * * 2 02 0 * * 2 02 0 * * 3

6. UNIX for Dummies Questions & Answers

How to sort a column based on numerical ascending order if it includes e-10?

I have a column of numbers in the following format: 1.722e-05 2.018e-05 2.548e-05 2.747e-05 7.897e-05 4.016e-05 4.613e-05 4.613e-05 5.151e-05 5.151e-05 5.151e-05 6.1e-05 6.254e-05 7.04e-05 7.12e-05 7.12e-05

7. Shell Programming and Scripting

awk sort based on difference of fields and print all fields

Hi I have a file as below <field1> <field2> <field3> ... <field_num1> <field_num2> Trying to sort based on difference of <field_num1> and <field_num2> in desceding order and print all fields. I tried this and it doesn't sort on the difference field .. Appreciate your help. cat...

8. Shell Programming and Scripting

Use sort to sort numerical column

How to sort the following output based on lowest to highest BE? The following sort does not work. $ sort -t. -k1,1n -k2,2n bfd.txt BE31.116 0s 0s DOWN DAMP BE31.116 0s 0s DOWN DAMP BE31.117 0s 0s ...

9. Shell Programming and Scripting

Sort file data according to a custom list of string

I have a string of pre defined ip address list which will always remain constant their order will never change like in below sample: iplist=8.8.5.19,9.7.5.14,12.9.9.23,8.8.8.14,144.1.113 In the above example i m considering only 5 ips but there could be many more. Now i have a file which...

9 More Discussions You Might Find Interesting

1. Programming

Adding files of numerical data

Discussion started by: Boucho

2. Shell Programming and Scripting

How to strip non numerical data out of file?

Discussion started by: Juha

3. Shell Programming and Scripting

Script to sort data

Discussion started by: wizardy_maximus

4. Shell Programming and Scripting

Reading Numerical Binary Data using KSH

Discussion started by: Jonny2Vests

5. Shell Programming and Scripting

Sort numerically a non numerical

Discussion started by: gio001

6. UNIX for Dummies Questions & Answers

How to sort a column based on numerical ascending order if it includes e-10?

Discussion started by: evelibertine

7. Shell Programming and Scripting

awk sort based on difference of fields and print all fields

Discussion started by: newstart

8. Shell Programming and Scripting

Use sort to sort numerical column

Discussion started by: sand1234

9. Shell Programming and Scripting

Sort file data according to a custom list of string

Discussion started by: mohtashims