Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Help with ... Formating the file using awk
Top Forums Shell Programming and Scripting Help with ... Formating the file using awk Post 303018065 by manas_ranjan on Monday 28th of May 2018 10:55:07 AM
Old 05-28-2018
Help with ... Formating the file using awk
I have a file like below
Code:
position1                   0          7802            7802            0          client1                                                 -                              -

position1                   8          8032            8032            0          client1                                                 -                              -

position1                   4          7761            7761            0          client1                                                                                            -                              -

position1                   9          7766            7766            0          client2                                                 -                              -

position2                   1          7796            7796            0          client3                                                 -                              -

position2                   3          8032            8032            0          client4                                                 -                              -

position2                   2          8123            8123            0          client4                                                 -                              -

position3                   6          7804            7804            0          client5                                                 -                              -

position3                   7          7890            7890            0          client5                                                 -                              -

position3                   5          7801            7801            0          -                                                       -                              -

how could i format this file like below
Code:
unique(column1), count(column2) -->  position1, 4

                                                                     position2, 3

                                                                     position3, 3



Code:
unique(column1), count(column6) -->  position1, 4

                                                                     position2, 3

                                                                     position3, 2



Code:
unique(column1), unique(column6)), count(unique(column6))) -->         position1,client1, 3

                                                                                                                                position1,client1, 1

                                                                                                                                position2,client3, 1

                                                                                                                                position2,client3, 2

                                                                                                                                position3,client5, 2

                                                                                                                                position3,-, 1

Last edited by manas_ranjan; 05-29-2018 at 05:04 AM..
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Help required on file formating

I have two files file1 and file2 as shown below: file1: name nameabc bcd nameabcdefg file2: age age1111 age2345 age6743 I have pasted one file on the other with the delimiter "|" and the resulttant file is: name|age nameabc|age1111 bcd|age2345 nameabcdefg|age6743 (1 Reply)
Discussion started by: udiptya
1 Replies

2. Shell Programming and Scripting

AWK: formating number without printf

Hello, I wrote a script that does lot of things, and I would like to change the format of a number but without printing it now (so I don't want to use printf as it will print the value immediately). Schematically here is what I have: awk 'BEGIN{number=0.01234567} $1==$2{$3=number}... (5 Replies)
Discussion started by: jolecanard
5 Replies

3. Shell Programming and Scripting

file formating in Perl

Hi, I am new to unix , I have a requirement for formating the input file and generate the output file as per the downstream requirement .. My application receiving a text input file having 4 field and my application need to check each field and if some value of a field is blank ..then it need... (1 Reply)
Discussion started by: julirani
1 Replies

4. UNIX for Dummies Questions & Answers

File formating help needed.

I have a file called vm.cfg . content of file. acpi = 1 apic = 1 builder = 'hvm' How would i write a script which will add boot = 'd' at 3rd line. For example. after running the script the file should be like below. acpi = 1 apic = 1 boot = 'd' builder = 'hvm' I dont want to... (3 Replies)
Discussion started by: pinga123
3 Replies

5. Shell Programming and Scripting

Help in formating a txt file

Pls help in formatting a txt file using shell scripting Input file format: Name priya 2010-09-21 10:43:49 TEXT ID 1 hi TEXT ID 2 how TEXT ID 3 r TEXT ID 4 u Output required: name priya hi how r u (4 Replies)
Discussion started by: bha148
4 Replies

6. Shell Programming and Scripting

formating sql file using awk or sed

Hi, I have a file where I would like to add a prompt type object_name statement before every create commnad create or replace force view test_view_01 ( col1 col2 col3 ) as (select a,b,c from sometable ); create or replace view test_view_02 ( col4 col5 col6 ) as (5 Replies)
Discussion started by: jville
5 Replies

7. UNIX for Beginners Questions & Answers

File formating with lines

Hi All, Need to modify a file basically join the extra line to one I am having a file like below And would like to make it as below . (4 Replies)
Discussion started by: arunkumar_mca
4 Replies

8. UNIX for Beginners Questions & Answers

File formating help

Hi all, I am having the file below I need that as below Thanks, Arun (12 Replies)
Discussion started by: arunkumar_mca
12 Replies

9. Shell Programming and Scripting

File formating

I need to create a fixed width file based on the column lengths. lets assume I have six(this may be dynamic) fields each are of different length column1=6 #size of the column column2=3 column3=2 column4=3 column5=4 column6=5 I tried below code snippet but it is not working echo... (4 Replies)
Discussion started by: gvkumar25
4 Replies

10. UNIX for Beginners Questions & Answers

awk HTML Conditional Formating

I am receiving the below output in text format. The output is converted to HTML table using the code mentioned below output in text LogDate DayOfWeek/Hours _0_ _1_ _2_ _3_ _4_ _5_ _6_ _7_ _8_ _9_ _10_ _11_ _12_ _13_ _14_ _15_ _16_ ... (3 Replies)
Discussion started by: Dumpi16
3 Replies
All times are GMT -4. The time now is 02:51 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy