Sponsored Content
Full Discussion: Processing with awk
Top Forums Shell Programming and Scripting Processing with awk Post 302290772 by zainravi on Tuesday 24th of February 2009 04:43:22 AM
Old 02-24-2009
Processing with awk

I currently have a file whose contents are:

Code:
RangingDates    		1       20090224        20090225        17      0       Export Complete 2009-02-23 19:58:00
FutureModuleList        1       20090225        20090226        6       0       Export Complete 2009-02-24 06:00:00
StoreDescription        1       20090225        20090226        5       0       Export Complete 2009-02-24 05:02:00
StoreToDisplay  		1       20090225        20090226        5       0       Export Complete 2009-02-24 05:19:00
FutureStoreToDisplay   	1       20090225        20090226        6       0       Export Complete 2009-02-24 06:05:00
FutureStoreDescription    	1       20090225        20090226        6       0       Export Complete 2009-02-24 06:06:00
Module  	1       20090224        20090225        15      0       Export Complete 2009-02-23 15:00:00
ModuleDispOpt   1       20090224        20090225        15      0       Export Complete 2009-02-23 15:01:00
DispOptProduct  		1       20090224        20090225        14      0       Export Complete 2009-02-23 15:11:00
StoreDispOpt    		1       20090224        20090225        15      0       Export Complete 2009-02-23 15:13:00
StoreItem       		1       20090224        20090225        13      0       Export Complete 2009-02-23 14:08:00


Could you please suggest appropriate awk commands for this manipulation so that the output appears as:

Code:
RangingDates    		1       20090224        20090225        17      0       Export Complete 2009-02-23 19:58:00
FutureModuleList                1       20090225        20090226        6       0       Export Complete 2009-02-24 06:00:00
StoreDescription                1       20090225        20090226        5       0       Export Complete 2009-02-24 05:02:00
StoreToDisplay  		1       20090225        20090226        5       0       Export Complete 2009-02-24 05:19:00
FutureStoreToDisplay   	1       20090225        20090226        6       0       Export Complete 2009-02-24 06:05:00
FutureStoreDescription    	1       20090225        20090226        6       0       Export Complete 2009-02-24 06:06:00
Module  			 1       20090224        20090225        15      0       Export Complete 2009-02-23 15:00:00
ModuleDispOpt   		1       20090224        20090225        15      0       Export Complete 2009-02-23 15:01:00
DispOptProduct  		1       20090224        20090225        14      0       Export Complete 2009-02-23 15:11:00
StoreDispOpt    		1       20090224        20090225        15      0       Export Complete 2009-02-23 15:13:00
StoreItem       		1       20090224        20090225        13      0       Export Complete 2009-02-23 14:08:00

The above display may not appear correctly. But the intent should be understood please.

Last edited by zainravi; 02-24-2009 at 05:57 AM.. Reason: code not displaying properly
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Processing with AWK and Arrays

Done, thanks for the help - worked. (1 Reply)
Discussion started by: fusionX
1 Replies

2. Shell Programming and Scripting

awk processing

Hi all Is there a way in awk to know that you are processing your final line of input if you do no know how many lines were in the input to begin with? Thanks (7 Replies)
Discussion started by: pxy2d1
7 Replies

3. Shell Programming and Scripting

awk help in processing file.

I am trying to process file which has following data #23456789012345 ACNASPSA13N0N0 ACNAPCPA05N0N0 ACNAFATS11N0N0 I want to take out each line from the file and what to put in the file by name which if part of the line starting from offset 10 to 15. It means I want to create three file... (3 Replies)
Discussion started by: ekb
3 Replies

4. Shell Programming and Scripting

Help with data processing, maybe awk

I have a file, first 5 columns are very normal, like "1107",106027,71400,"Y","BIOLOGY",, however, the 6th columns, the user can put comments, anything, just any characters, like new line, double quote, single quote, whatever from the keyboard, like"Please load my previous SOM597G course content in... (3 Replies)
Discussion started by: freelong
3 Replies

5. Shell Programming and Scripting

Help with File Processing (AWK)

Input File: 1234, 2345,abc 1,24141,gw 222,rff,sds 2232145,sdsd,121 Output file to be generated: 000001234,2345,abc 000000001,24141,gw 000000222,rff,sds 002232145,sdsd,121 i.e; the first column is padded to get 9 digits. I tried with following: (1 Reply)
Discussion started by: karumudi7
1 Replies

6. Shell Programming and Scripting

processing with awk

I have many lines like the following in a file(there are also other kinds of lines) Host: 72.52.104.74 (tserv1.fmt2.he.net) Ports: 22/open/tcp//tcpwrapped///, 53/open/tcp//domain//PowerDNS 3.3/, 179/open/tcp//tcpwrapped/// Ignored State: closed (997) Seq Index: 207 IP ID Seq: All... (9 Replies)
Discussion started by: esolvepolito
9 Replies

7. Programming

awk processing / Shell Script Processing to remove columns text file

Hello, I extracted a list of files in a directory with the command ls . However this is not my computer, so the ls functionality has been revamped so that it gives the filesizes in front like this : This is the output of ls command : I stored the output in a file filelist 1.1M... (5 Replies)
Discussion started by: ajayram
5 Replies

8. Shell Programming and Scripting

Text processing using awk

I dispose of two tab-delimited files (the first column is the primary key): File 1 (there are multiple rows sharing the same key, I cannot merge them) A 28,29,30,31 A 17,18,19 B 11,13,14,15 B 8,9File 2 (there is one only row beginning with a given key) A 2,8,18,30,31 B ... (3 Replies)
Discussion started by: dovah
3 Replies

9. Shell Programming and Scripting

Help with file processing using awk

hello All, I'm new to AWK programming and learned myself few things to process a file and deal with duplicate lines, but I got into a scenario which makes me clueless to handle. Here is the scenario.. Input file: user role ----- ---- AAA add AAA delete BBB delete CCC delete DDD ... (10 Replies)
Discussion started by: julearn
10 Replies

10. Shell Programming and Scripting

awk for text processing

Hi,my file is in this format ", \"symbol\": \"Rbm38\" } ]" I want to convert it to a more user readable format _id pubmed text symbol 67196 18667844 Overexpression of UBE2T in NIH3T3 cells significantly promoted colony formation in mouse cell cultures Ube2t 56190 21764855 ... (3 Replies)
Discussion started by: biofreek
3 Replies
AUINFO(1)						      General Commands Manual							 AUINFO(1)

NAME
auinfo - show information about a Network Audio System server SYNOPSIS
auinfo [-audio servername] DESCRIPTION
The auinfo program provides information describing a Network Audio System server. It lists the capabilities of the server, the devices that are attached to it, the data formats that are accepted, and any predefined sounds that have been stored in the server. EXAMPLE
The following example shows the output produced by auinfo when connected to an NCD MCX(tm) display station: Audio Server: tcp/lemkemcx:8000 Version Number: 2.0 Vendor: Network Computing Devices Inc. Vendor Release: 3000 Min Sample Rate: 1000 Max Sample Rate: 52000 Max Tracks: 32 Number of Formats: 7 Formats: ULAW8 LinearUnsigned8 LinearSigned8 LinearSigned16MSB LinearUnsigned16MSB LinearSigned16LSB LinearUnsigned16LSB Number of Elem Types: 11 Element Types: ImportClient ImportDevice ImportBucket Bundle MultiplyConstant AddConstant Sum ExportClient ExportDevice ExportBucket ExportMonitor Number of Wave Forms: 0 Number of Actions: 2 Actions: ChangeState SendNotify Number of Devices: 5 Device 0: Changable: Gain LineMode ID: 0x34 Kind: PhysicalInput Use: Import Format: LinearSigned16MSB Num Tracks: 1 Access: Import List Description: "Mono Channel Input" Min Rate: 1000 Max Rate: 52000 Location: Left Right External Gain Percent: 15 Line Mode: High Device 1: Changable: Gain ID: 0x32 Kind: PhysicalOutput Use: Export Format: LinearSigned16MSB Num Tracks: 2 Access: Export List Description: "Stereo Channel Output" Min Rate: 1000 Max Rate: 52000 Location: Left Right External Gain Percent: 24 Num Children: 2 Children: 0x30 0x31 Device 2: Changable: Gain ID: 0x33 Kind: PhysicalOutput Use: Export Format: LinearSigned16MSB Num Tracks: 1 Access: Export List Description: "Mono Channel Output" Min Rate: 1000 Max Rate: 52000 Location: Left Right External Gain Percent: 24 Num Children: 2 Children: 0x30 0x31 Device 3: Changable: Gain ID: 0x31 Kind: PhysicalOutput Use: Export Format: LinearSigned16MSB Num Tracks: 1 Access: Export List Description: "Right Channel Output" Min Rate: 1000 Max Rate: 52000 Location: Right External Gain Percent: 24 Num Children: 0 Device 4: Changable: Gain ID: 0x30 Kind: PhysicalOutput Use: Export Format: LinearSigned16MSB Num Tracks: 1 Access: Export List Description: "Left Channel Output" Min Rate: 1000 Max Rate: 52000 Location: Left External Gain Percent: 24 Num Children: 0 Number of Buckets: 0 Bucket 0: ID: 0x1400008 Kind: Bucket Use: Import Export Format: ULAW8 Num Tracks: 1 Access: Import Export Destroy List Description: "Monty Python - Australian Table Wines" Sample Rate: 8000 Num Samples: 697944 Bucket 1: ID: 0x1400007 Kind: Bucket Use: Import Export Format: LinearUnsigned8 Num Tracks: 1 Access: Import Export Destroy List Description: ""I'm sorry Dave, I can't do that" - HAL from 2001" Sample Rate: 22255 Num Samples: 85504 Bucket 2: ID: 0x1400006 Kind: Bucket Use: Import Export Format: LinearUnsigned8 Num Tracks: 1 Access: Import Export Destroy List Description: ""He's dead, Jim" - Dr. McCoy" Sample Rate: 11128 Num Samples: 31602 ENVIRONMENT
AUDIOSERVER This variable specifies the default audio server to contact if -audio is not specified on the command line. DISPLAY If AUDIOSERVER is not set, this variable is examined to find the name of the corresponding X Window System display. SEE ALSO
nas(1) COPYRIGHT
Copyright 1993, 1994 Network Computing Devices, Inc. See nas(1) for a full statement of rights and permissions. AUTHOR
Jim Fulton, Network Computing Devices, Inc. 1.9.3 AUINFO(1)
All times are GMT -4. The time now is 12:43 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy