Sponsored Content
Top Forums Shell Programming and Scripting Help with ... Formating the file using awk Post 303018108 by manas_ranjan on Tuesday 29th of May 2018 09:02:01 AM
Old 05-29-2018
it's not working after adding \n after printf

Code:
awk -F"[ :\t]+" 'NF {A[$1,$6]++}END{for(i in A){count=A[i]; split(i, w, ",") ; for (j in w) printf("positiondetails,position=%s,client=%s count=%d", w[j], count}}' OFS=, SUBSEP=, file4

PS I missed client in my previous statement. sorry again!!

So in-order to print like this

Code:
positiondetails,position=position3,client=client5<space> count=2

below awk is not enough
Code:
awk -F"[ :\t]+" 'NF {A[$1,$6]++}END{for(i in A){count=A[i]; split(i, w, ",") ; for (j in w) printf("positiondetails,position=%s,client=%s count=%d\n", w[j], count}}' OFS=, SUBSEP=, file4 
 -->>>it's complaining ran out for this client=%s count=%d

if I make change
Code:
awk -F"[ :\t]+" 'NF {A[$1,$6]++}END{for(i in A){count=A[i]; split(i, w, ",") ; for (j in w) printf("positiondetails,position=%s count=%d", w[j], count}}' OFS=, SUBSEP=, file4

then output is like this

Code:
positiondetails,position=position3,client=client5<space> count=2 
positiondetails,position=client5<space> count=2

while I wanted to print

Code:
positiondetails,position=position3,client=client5<space> count=2

Any direction?
 

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
DIO_SEEK(3)								 1							       DIO_SEEK(3)

dio_seek - Seeks to pos on fd from whence

SYNOPSIS
int dio_seek (resource $fd, int $pos, [int $whence = SEEK_SET]) DESCRIPTION
The function dio_seek(3) is used to change the file position of the given file descriptor. PARAMETERS
o $fd - The file descriptor returned by dio_open(3). o $pos - The new position. o $whence - Specifies how the position $pos should be interpreted: o SEEK_SET (default) - specifies that $pos is specified from the beginning of the file. o SEEK_CUR - Specifies that $pos is a count of characters from the current file position. This count may be positive or nega- tive. o SEEK_END - Specifies that $pos is a count of characters from the end of the file. A negative count specifies a position within the current extent of the file; a positive count specifies a position past the current end. If you set the position past the current end, and actually write data, you will extend the file with zeros up to that position. RETURN VALUES
EXAMPLES
Example #1 Positioning in a file <?php $fd = dio_open('/dev/ttyS0', O_RDWR); dio_seek($fd, 10, SEEK_SET); // position is now at 10 characters from the start of the file dio_seek($fd, -2, SEEK_CUR); // position is now at 8 characters from the start of the file dio_seek($fd, -5, SEEK_END); // position is now at 5 characters from the end of the file dio_seek($fd, 10, SEEK_END); // position is now at 10 characters past the end of the file. // The 10 characters between the end of the file and the current // position are filled with zeros. dio_close($fd); ?> PHP Documentation Group DIO_SEEK(3)
All times are GMT -4. The time now is 01:46 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy