Sponsored Content
Full Discussion: variable fixed-width fields
Top Forums Shell Programming and Scripting variable fixed-width fields Post 302575421 by gray380 on Monday 21st of November 2011 03:33:41 PM
Old 11-21-2011
variable fixed-width fields

Hi there,

Code:
CTL  Port        IO Rate(IOPS)      Read Rate(IOPS)     Write Rate(IOPS) Read Hit(%) Write Hit(%)    Trans. Rate(MB/S) Read Trans. Rate(MB/S) Write Trans. Rate(MB/S)   09:36:48
  0     A                  136                    0                  135          97          100                    7                      0                       7   09:36:48
  0     B                    3                    0                    2         100          100                    0                      0                       0   09:36:48
  0     C                   88                   84                    3          35          100                    9                      9                       0   09:36:48
  0     D                  391                  240                  151          44          100                   11                      6                       4   09:36:48
  0     E                    0                    0                    0           0            0                    0                      0                       0   09:36:48

Quote:
awk '{print NF}' inputfile
shows the following result:
21
11
11
...

but I need to correlate header fields with rest of table and substitute fixed-width field separator with something else, for instance "\t".

Please advise.

The second task is to merge some columns into the one:
0 A to 0A
0 B to 0B
and so on.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Fixed Width file using AWK

I am using the following command at the Unix prompt to make my 'infile' into a fixed width file of 100 characters. awk '{printf "%-100s\n",$0}' infile > outfile However, there are some records with a special character "©" These records are using 3 characters in place of one and my record... (2 Replies)
Discussion started by: alok.benjwal
2 Replies

2. Shell Programming and Scripting

Extracting records with unique fields from a fixed width txt file

Greetings, I would like to extract records from a fixed width text file that have unique field elements. Data is structured like this: John A Smith NY Mary C Jones WA Adam J Clark PA Mary Jones WA Fieldname / start-end position Firstname 1-10... (8 Replies)
Discussion started by: sitney
8 Replies

3. UNIX Desktop Questions & Answers

Help with Fixed width File Parsing

I am trying to parse a Fixed width file with data as below. I am trying to assign column values from each record to variables. When I parse the data, the spaces in all coumns are dropped. I would like to retain the spaces as part of the dat stored in the variables. Any help is appreciated. I... (4 Replies)
Discussion started by: sate911
4 Replies

4. Shell Programming and Scripting

Combining Two fixed width columns to a variable length file

Hi, I have two files. File1: File1 contains two fixed width columns ID of 15 characters length and Name is of 100 characters length. ID Name 1-43<<11 spaces>>Swapna<<94 spaces>> 1-234<<10 spaces>>Mani<<96 spaces>> 1-3456<<9 spaces>>Kapil<<95 spaces>> File2: ... (4 Replies)
Discussion started by: manneni prakash
4 Replies

5. Shell Programming and Scripting

Comparing column of variable length anf fixed width file

Hi, I have two input files. File1: ID Name Place 1-234~name1~Newyork 1-34~name2~Boston 1-2345~name3~Hungary File1 is a variable length file where each column is seperated by delimitter "~". File2: ID Country 1-34<<11 SPACES>>USA<<7 spaces>> 1-234<<10 SPACES>>UK<<8... (5 Replies)
Discussion started by: manneni prakash
5 Replies

6. Shell Programming and Scripting

summing up the fields in fixed width file

Hi, I have a fixed width file with some records as given below: " 1000Nalsdjflj243324jljlj" "-0300Njfowjljl309933fsf" " 0010Njsfsjklj342344fsl" I want to sum-up first field values(i.e from 2nd character to 6th character)of each record. so for the above file i want to add (1000 - 300+... (2 Replies)
Discussion started by: srilaxmi
2 Replies

7. Shell Programming and Scripting

Printing Fixed Width Columns

Hi everyone, I have been working on a pretty laborious shellscript (with bash) the last couple weeks that parses my firewall policies (from a Juniper) for me and creates a nifty little columned output. It does so using awk on a line by line basis to pull out the appropriate pieces of each... (4 Replies)
Discussion started by: cixelsyd
4 Replies

8. Shell Programming and Scripting

How to parse fixed-width columns which may include empty fields?

I am trying to selectively display several columns from a db2 query, which gives me a fixed-width output (partial output listed here): --------- -------------------------- ------------ ------ 000 0000000000198012 702 29 000 0000000000198013 ... (9 Replies)
Discussion started by: ahsh79
9 Replies

9. Shell Programming and Scripting

Using printf (or other?) to create variable fixed width text

I would like to use printf (or something else?) to create a line of text that has varying column widths. This will be used to create a fixed width file (with varying column widths). For example, consider variables $1 $2 $3 are equal to a, b, c respectively and they should be printed in column... (10 Replies)
Discussion started by: farrenthorpe
10 Replies

10. Shell Programming and Scripting

Alter Fixed Width File

Thank u so much .Its working fine as expected. ---------- Post updated at 03:41 PM ---------- Previous update was at 01:46 PM ---------- I need one more help. I have another file(fixed length) that will get negative value (ex:-00000000003000) in postion (98 - 112) then i have to... (6 Replies)
Discussion started by: vinus
6 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 08:53 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy