Search Results

Output will look like this:


10122017 11122017 2122017 13122017 14122017
joe sub1 94.19 94.07 26.24 72.36 51
joe sub2 70.99 51.02 30.95 60.92 ...

It does not work when the week is changed to dates, like below:

cand date sub1 sub2 sub3 sub4
joe 10122017 94.19 70.99 43.93 60.14
joe 11122017 94.07 51.02 41.07...

Can anyone suggest GNU Awk 4.2.0 implementation?

Edited, my error

I am trying to format the table below to the output
input:
cand week sub1 sub2 sub3 sub4
joe 1 94.19 70.99 43.93 60.14
joe 2 94.07 51.02 41.07 38.92
joe 3 26.24 ...

Thank you for the solution, problem solved.

I have similar issue, see:
https://www.unix.com/shell-programming-and-scripting/269290-sendmail-ignoring-line-endings.html

Mails from Sendmail are ignoring line endings, when I try to send email with attachment. I have tried to specify the font in the html but line endings are still ignored. I also tried unix2dos, still...

How can I sort this, first by 2nd field then by 1st field.

tried sort -b -k 2,2

Input:
AS11 AB1
BD34 AB10
AF12 AC2
A345 AB10
R134 AB2
456 AC10
TTT2 BD12
desired output:
AS11 AB1
R134...

If I Have input with different column width (determined by Row with FTR), how can I achieve the output?
Input:
COL1 COL2 CL3 FTR
AA8 S2 CAT2 ...

I want to specify field width based on the row with FTR.
I can acheive this if column width is constant with:
awk 'BEGIN { FIELDWIDTHS = "20 7 14 30" }{print $1,$4}' file
file:COL1 ...

Thank You. I just a found a way out, by piping to awk
sort -b -k 2.9,2.10 -k 2.1,2.2 -k 2.4,2.5 -k 3,3 file | awk '$2~/NIL/{A[NR]=$0;next}{print}END{for (i in A){print A[i]}}

I do sort on the date and Time chronologically, how can I make the NIL to be below in the output

Input file:

KT NIL NIL
ZK 02/09/2016 18:11
CD NIL NIL
AS 02/09/2016 18:22
AB 02/08/2016...

I have a script that require input from terminal at some point (either a,b or c)
How can I cron the script and automatically assume c as the input.

How can I have all my output to a terminal pager by default.
I want all output to pause once screen is full.

Piping to more does not work if the app/script is interactive

Thank you, It works!

No way to tell unless the FIELDWIDTHS of the Header

Thank you for your effort, data is missing for a field if nothing is below it. e.g. data is missing for Cla as seen below:

Bet Cla Blaa Dat
A 6 T

Only Tables have 2+ spaces and always 2 lines (Header and data below)

table are usually delimited by 2 or more spaces.

I need to sort out table in a file to a format below:


Input:

this is a test
example
Cat Bee Dat
1 2 3
more Example
date
data
Bet Cla Blaa Dat
A 6 ...

Thanks, it works!

Not working, this is the output:
L2 KT2 26
H5 LAF2 28
G456 KT1 34
F3 LAF2 36
K234 KT10 45

@Scrutinizer, seem not to be working, This is the output I got:
G456 KT1 34
K234 KT10 45
L2 KT2 26
F3 LAF2 36
H5 LAF2 28

---------- Post updated at 10:25 ---------- Previous update was at...

OS = Solaris 10
Shell = ksh