Sponsored Content
Full Discussion: UNIX awk help
Top Forums UNIX for Dummies Questions & Answers UNIX awk help Post 302137955 by Ygor on Thursday 27th of September 2007 11:13:14 PM
Old 09-28-2007
Try...
Code:
awk -F, '{for(i=1;i<NF;i++) printf $i (i>13&&i%3==2?";":",");print $NF}' file1

Tested...
MEPMD01,19970819,Sensus,SDGE,SDGE,,200705221435,1888961,OK,E,KWH,1,00000015,48;200705210715,R 00 40,2.0000;200705210730,R 00 40,1.0000;200705210745,R 00 40,2.0000;200705210800,R 00 40,1.0000;200705210815,R 00 40,2.0000;200705210830,R 00 40,2.0000;200705210845,R 00 40,1.0000;200705210900,R 00 40,2.0000;200705210915,R 00 40,2.0000;200705210930,R 00 40,1.0000;200705210945,R 00 40,2.0000;200705211000,R 00 40,1.0000;200705211015,R 00 40,2.0000;200705211030,R 00 40,2.0000;200705211045,R 00 40,1.0000;200705211100,R 00 40,2.0000;200705211115,R 00 40,2.0000;200705211130,R 00 40,1.0000;200705211145,R 00 40,2.0000;200705211200,R 00 40,1.0000;200705211215,R 00 40,2.0000;200705211230,R 00 40,2.0000;200705211245,R 00 40,1.0000;200705211300,R 00 40,2.0000;200705211315,R 00 40,2.0000;200705211330,R 00 40,1.0000;200705211345,R 00 40,2.0000;200705211400,R 00 40,1.0000;200705211415,R 00 40,1.0000;200705211430,R 00 40,2.0000;200705211445,R 00 40,1.0000;200705211500,R 00 40,1.0000;200705211515,R 00 40,1.0000;200705211530,R 00 40,1.0000;200705211545,R 00 40,1.0000;200705211600,R 00 40,1.0000;200705211615,R 00 40,1.0000;200705211630,R 00 40,1.0000;200705211645,R 00 40,1.0000;200705211700,R 00 40,1.0000;200705211715,R 00 40,1.0000;200705211730,R 00 40,1.0000;200705211745,R 00 40,1.0000;200705211800,R 00 40,1.0000;200705211815,R 00 40,1.0000;200705211830,R 00 40,1.0000;200705211845,R 00 40,1.0000;200705211900,R 00 40,1.0000
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Unix To Awk

How do I alias the FILE name into awk? gawk -f awk_script FILE or FILE | gawk awk_script for FILE in `find ./* -prune -type f -newer ./TIMEFILE` do # Need to have the actual FILE name ran thru an awk script done (1 Reply)
Discussion started by: goodmis
1 Replies

2. Shell Programming and Scripting

unix awk scripting

Hi can anyone pls help me out in knowing how a array of elements which are fetched from database is passed to the awk program. Something like this #!/bin/sh AMT=`sqlplus -s usrname/pswd <<EOD set pagesize 0 feedback off verify off heading off echo on select amount from... (11 Replies)
Discussion started by: shaik
11 Replies

3. UNIX for Dummies Questions & Answers

Clock in Unix using awk

Hey everyone! Can someone help me, i need to make a program using awk, that displays the current time (hh/mm/ss), i would really apreciate it! Thanks! Alex. (4 Replies)
Discussion started by: alex_omul
4 Replies

4. Shell Programming and Scripting

need help with UNIX and awk

Hi, I am working on a script where i am fetching a word from a parameter file and using it as output file name . here is the part of parameter file contents : it basically contains SQL statements. Select 'SSFNRTP' as TABLE_NAME,UCSTDT,CVOFIDKEY from (Select 'cofvof_interface' as... (2 Replies)
Discussion started by: manmeet
2 Replies

5. UNIX for Dummies Questions & Answers

AWK Help (New to UNIX)

Write a script to calculate the average score and assign a letter grade for each student, also compute the average score for every test (the source data is in the file “grades”). Output all students' name, scores, and grades in descending order of the average score. Note: please save the output to... (17 Replies)
Discussion started by: dsptl
17 Replies

6. Shell Programming and Scripting

Help in unix in awk

Hi, I have a file as given below $cat int_check 239|adf123@yahoo.com|999e 23e|get@rediff.com|987 233|get@rediff.com|987 I am running the command as given to find whether field 1 and 3 have proper integer values or not. awk -F'|' 'int($1)!=$1 || int($3)!=$3' int_check... (7 Replies)
Discussion started by: ashwin3086
7 Replies

7. UNIX for Advanced & Expert Users

awk sub command in Unix

Hi, I am new to unix shell script and I have some trouble on the awk sub I would like to pick the Date "July 10 2012" into $corr_date by using sub() function, but it is not successful. The inputted text file: pic.*.txt July 10 2012 20:30:50 , 1234567.jpg July 10 2012 20:30:52 , 5648978.jpg... (1 Reply)
Discussion started by: meroko
1 Replies

8. AIX

awk UNIX

friends because I get this error when calling awk awk: 0602-546 Can not find or open file estdistica.awk. (10 Replies)
Discussion started by: tricampeon81
10 Replies

9. UNIX for Dummies Questions & Answers

UNIX inquiry for 'awk'

Hello Everyone, May I ask for your help regarding one of the UNIX command “awk”. So I executed a script and the output looks like this (see below): output.txt CONTRACTNAME ... (3 Replies)
Discussion started by: steven_huskie
3 Replies

10. How to Post in the The UNIX and Linux Forums

Help me in awk or sed in UNIX

I have a fixed length file that looks like a@ a00 a00000 a00 a000000 a00 a0000 a0000 a00000000 a01 a@ a1 a2 a11 a22 a12 a13 a44 a45 a54 a65 a76 a77 a@ a1 a3 a6 a7 a9 a8 a2 a7 a8 a8 a9 a0 b@ b00 b00000 b00... (1 Reply)
Discussion started by: RJG
1 Replies
mlib_VideoColorYUV444int_to_ARGBint(3MLIB)		    mediaLib Library Functions			mlib_VideoColorYUV444int_to_ARGBint(3MLIB)

NAME
mlib_VideoColorYUV444int_to_ARGBint - color convert YUV interleaved to ARGB interleaved SYNOPSIS
cc [ flag... ] file... -lmlib [ library... ] #include <mlib.h> void mlib_VideoColorYUV444int_to_ARGBint(mlib_u32 *ARGB, const mlib_u8 *YUV, const mlib_u8 *A_array, mlib_u8 A_const, mlib_s32 w, mlib_s32 h, mlib_s32 dlb, mlib_s32 slb, mlib_s32 alb); DESCRIPTION
The YUV pixel stream is converted into an ARGB pixel stream. All pixel components are 8-bit unsigned integers. All buffers have dimensions w and h. The alpha values for this function work in the following fashion: o If A_array pointer is not NULL, the values are taken from there. It has to have the same dimensions as the Y buffer. o If A_array pointer is NULL, the alpha values for every pixel are set to A_const. The following equation is used: |R| |1.1644 0.0000 1.5966| [|Y| | 16.0000|] |G| = |1.1644 -0.3920 -0.8132| * [|U| - |128.0000|] |B| |1.1644 2.0184 0.0000| [|V| |128.0000|] PARAMETERS
The function takes the following arguments: ARGB Pointer to output buffer. YUV Pointer to Y input buffer. A_array Array of alpha values. A_const Constant alpha value. w Image width in pixels. h Image height in lines. dlb Linebytes for output buffer. slb Linebytes for input buffer. alb Linebytes for alpha buffer. RETURN VALUES
None. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Interface Stability |Committed | +-----------------------------+-----------------------------+ |MT-Level |MT-Safe | +-----------------------------+-----------------------------+ SEE ALSO
mlib_VideoColorYUV420seq_to_ARGBint(3MLIB), mlib_VideoColorYUV411seq_to_ARGBint(3MLIB), mlib_VideoColorYUV422seq_to_ARGBint(3MLIB), mlib_VideoColorYUV444seq_to_ARGBint(3MLIB), mlib_VideoColorYUV420seq_to_ABGRint(3MLIB), mlib_VideoColorYUV411seq_to_ABGRint(3MLIB), mlib_VideoColorYUV422seq_to_ABGRint(3MLIB), mlib_VideoColorYUV444seq_to_ABGRint(3MLIB), mlib_VideoColorYUYV422int_to_ARGBint(3MLIB), mlib_VideoColorYUYV422int_to_ABGRint(3MLIB), mlib_VideoColorYUV444int_to_ABGRint(3MLIB), mlib_VideoColorUYVY422int_to_ARGBint(3MLIB), mlib_VideoColorUYVY422int_to_ABGRint(3MLIB), mlib_VideoColorUYV444int_to_ARGBint(3MLIB), mlib_VideoColorUYV444int_to_ABGRint(3MLIB), attributes(5) SunOS 5.11 2 Mar 2007 mlib_VideoColorYUV444int_to_ARGBint(3MLIB)
All times are GMT -4. The time now is 04:20 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy