Not sure how to describe it but how to format this list so that it print the 1st field once only
Hi,
Not sure how to describe the problem. But basically, I have this file listing here
Doing sort and uniq on it gives:
I usually import this in MS-Excel and then clear up the first field so that the first field is printed once only in the group of rows/records. This is a manual process, I think I could write a macro to do it but can't work out how.
To avoid having to do this, after sort | uniq, I want the file to be as below:
For clarity, this is what it is supposed to look like. The leading spaces from the list below before the | is just an illustration to show what the preferred output is.
At the moment, I can only think of reading each line and then comparing current and previous lines and then print the required detail accordingly. The file could be huge though so pretty sure it will take a long time having to do it this way.
Not sure how else to do it. Currently doing so manually doing the import in MS-Excel
Advice and tips much appreciated. Thanks.
I want to sort alphabetically on the first field and sort in descending numerical order on the 2nd field. With a normal "sort -r -n" it does this:
abc ||| 5e-05 ||| bla
abc ||| 3 ||| ble
def ||| 1 ||| abc
def ||| 0.2 ||| def
As you can see it ignores the fact that 5e-05 is actually 0.00005... (1 Reply)
Hi,
I'm trying to print every line from first field to the fourth from a file containing more.
$ cat input
a b c d e f g
a b c d e f gI'm trying
awk '{for (i=1; i <= NF-3; i++) print $i}' awkTest.datbut it printsa
b
c
d
a
b
c
dSo, I easily guess I'm wrong. :)
Of course, I want:a b... (5 Replies)
Hi,
I need help changing a field from MM/DD/YY to DD/MM/YY format. Suppose a file a.csv. The record is
"11/16/09","ABC"," 1","EU","520892414","1","600","31351000","1234567","ANR BANK CO. LTD"
"11/16/09","PQR"," 2","EU","520892427","1","600","31351000","5467897","ANR BANK CO.... (4 Replies)
Hi experts,
I need to print the first field first then last two fields should come next and then i need to print rest of the fields.
Input :
a1,abc,jsd,fhf,fkk,b1,b2
a2,acb,dfg,ghj,b3,c4
a3,djf,wdjg,fkg,dff,ggk,d4,d5
Expected output:
a1,b1,b2,abc,jsd,fhf,fkk... (6 Replies)
I have a .CSV file (file.csv) whose data are all enclosed in double quotes. Sample format of the file is as below:
column1,column2,column3,column4,column5,column6, column7, Column8, Column9, Column10
"12","B000QRIGJ4","4432","string with quotes, and with a comma, and colon: in... (3 Replies)
Hi! How we are?
I have an A4 PDF in my server, and i must send it to phisically printer.
I use the comand:
lpr -P printername -o media=A4 archive.pdf
And the printer prints it in letter format, i don't know why.
¿Have ideas or solution?
Thanks, my best regards. (6 Replies)
Hi,
For example:
I have:
HostA,XYZ
HostB,XYZ
HostC,ABC
I would like the output to be:
HostA,HostB: XYZ
HostC:ABC
How can I achieve this?
So far what I though of is: (1 Reply)