Sponsored Content
Top Forums Shell Programming and Scripting Help need to subtract the data from 2 columns Post 302716937 by in2nix4life on Wednesday 17th of October 2012 10:27:04 AM
Old 10-17-2012
Code:
paste space_used.lst Actual_used.lst | awk '{print $3-$7"GB"" "$6}'

1GB /dborafiles/nethealth21/PV/oradata01
0GB /dborafiles/nethealth21/PV/oradata02
0GB /dborafiles/nethealth21/PV/oradata03
0GB /dborafiles/nethealth21/PV/oradata04
0GB /dborafiles/nethealth21/PV/oradata05
0GB /dborafiles/nethealth21/PV/oradata06
1GB /dborafiles/nethealth21/PV/oradata07
1GB /dborafiles/nethealth21/PV/oradata08
0GB /dborafiles/nethealth21/PV/oradata09
1GB /dborafiles/nethealth21/PV/oradata10

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to subtract data of two different file

I want to access of two different file. cat in_file | awk -F: '{ in_total += $1 * 86400 + $2 * 3600 + $3 * 60 + $4 } END {printf "%d\n",in_total} ' cat out_file | awk -F: '{ out_total += $1 * 86400 + $2 * 3600 + $3 * 60 + $4 } END {printf "%d\n",out_total} ' I want to sub... (2 Replies)
Discussion started by: krishna_sicsr
2 Replies

2. Shell Programming and Scripting

AWK solution to subtract multiple columns of numbers

Hope somebody is happy. NR==1 { num_columns=split( $0, menuend ); next; } { split( $0, substrend ); for ( i=1; i<=NF; i++ ) { minuend -= substrend; } } END { print "Result:"; for ( i=1; i<=num_columns; i++ ) { printf(... (3 Replies)
Discussion started by: awkward
3 Replies

3. Shell Programming and Scripting

Need help to subtract columns from 2 files and output to new file

Hi, I need some help figuring this out, I think it can be done using awk but I don't know how. So, I want to take two input files, subtract some columns with each other and then output to a new results file. InFile1.txt AAA 100 200 BBB CCC 300 400 DDD InFile2.txt AAA 50 60 BBB CCC 70... (7 Replies)
Discussion started by: MrTrigger
7 Replies

4. Shell Programming and Scripting

How to subtract a number from all columns?

Hi, I want to subtract a number from all columns except the first column. I have a number of files each having different columns around 60/70. How to do that in awk or any other command? Thanks Input Col 1 Col 2 Col3 - - - - Col55 1 .0123 .098 - - - 0.6728 2 - -... (3 Replies)
Discussion started by: Surabhi_so_mh
3 Replies

5. Shell Programming and Scripting

Subtract 2 date columns in .csv file and get output as number of days

Hi, I have one .csv file. I have 2 date columns present in file, column 2 and column 3. I need to calculate how many days exist between 2 dates. I am trying to subtract date column 2 from date column 3. Eg: my file look likes s.no, Start_date,End_Date 1, 7/29/2012,10/27/2012 2,... (9 Replies)
Discussion started by: Dimple
9 Replies

6. Shell Programming and Scripting

Add values in 2 columns and subtract from third

Hi All, I have a file with thousands of lines in the following format, where Field1=First 8 characters Field2-9-16 characters Field3=17-26 characters I need to add Field 1 and Field2 and subtract the result from Field 3. Field3=Field3 - (Field1 + Field2) 0012.00 0010.00 0001576.53... (4 Replies)
Discussion started by: nua7
4 Replies

7. Shell Programming and Scripting

Subtract 1 from all columns except columns 1 and 2

I have a file which has all integer numbers like this. This file is sort of very large, and I am only showing the first few contents. This representation can be regarded as a matrix of integer numbers. 14998 16 0 11680 3165 15343 8553 9925 3875 820 6430 14226 13261 11355 15428 9140 16184 7934... (1 Reply)
Discussion started by: shoaibjameel123
1 Replies

8. UNIX for Dummies Questions & Answers

awk to add/subtract an integer to/from each entry in columns?

---------- Post updated at 01:58 PM ---------- Previous update was at 01:48 PM ---------- For some reason my question is not getting printed. Here are the details: Greetings. I would like to add/subtact an integer to/from two columns of integers. I feel like this should be easy using awk... (3 Replies)
Discussion started by: Twinklefingers
3 Replies

9. Shell Programming and Scripting

Add new column which is subtract of 2 columns.

Hi below is a file Date Category Time Attempts Success 2/17/2014 PayFlow ATB 0.999988 4039104 4039057 2/18/2014 PayFlow ATB 0.999912 4620964 4620558 2/19/2014 PayFlow ATB 0.999991 4380836 4380796 2/20/2014 PayFlow ATB 0.999988 5031047 5030985 2/21/2014 ... (5 Replies)
Discussion started by: villain41
5 Replies

10. Shell Programming and Scripting

Help to subtract columns from 2 files and output to new file

Hi, I have 2 files in below formats File1_Stored.txt ABC:100, 83 ABC:84, 53 ABC:14, 1222And File2_Stored.txt ABC:100 , 83 ABC:84 , 1553 ABC:524 , 2626I am trying to get the 3rd file in below format. So, whenever difference is 0 it shouldn't appear but if the difference is not 0 then... (2 Replies)
Discussion started by: Abhayman
2 Replies
pcata(7D)							      Devices								 pcata(7D)

NAME
pcata - PCMCIA ATA card device driver SYNOPSIS
pcata@socket#:a -u pcata@socket#:a -u,raw DESCRIPTION
The PCMCIA ATA card device driver supports PCMCIA ATA disk and flash cards that follow the following standards: o PC card 2.01 compliance (MBR+fdisk table required for all platforms). o PC card ATA 2.01 compliance. o PC card services 2.1 compliance. The driver supports standard PCMCIA ATA cards that contain a Card Information Structure (CIS). For PCMCIA, nodes are created in /devices that include the socket number as one component of the device name referred to by the node. However, the names in /dev, /dev/dsk, and /dev/rdsk follow the current conventions for ATA devices, which do not encode the socket number in any part of the name. For example, you may have the following: +----------------+-----------------------------------+---------------------+ |Platform | /devices name | /dev/dsk name | +----------------+-----------------------------------+---------------------+ |x86 | /devices/isa/pcic@1,3e0 /disk@0:a | /dev/dsk/c1d0s0 | +----------------+-----------------------------------+---------------------+ |SPARC | /devices/iommu@f,e0000000 | /dev/dsk/c1d0s0 | | | /sbus@f,e0001000 /SUNW, pcm- | | | | cia@3,0 /disk@0:a | | +----------------+-----------------------------------+---------------------+ PRECONFIGURATION
If a PC Card ATA device is recognized, the pcata driver is automatically loaded, IRQs allocated, devices nodes created, and special files created (if they do not already exist). Known Problems and Limitations o You need to umount the file system before removing the disk. o The ufs file systems on removable media (PC Card ATA) should have one of the onerror={panic, lock, umount} mount options set. CONFIGURATION
Configuration topics include initial installation and configuration, identifying an unrecognized device, special files and hot-plugging. Initial Installation and Configuration 1. Install the Solaris software. 2. Boot the system. 3. Insert the PC card ATA device. Identifying an Unrecognized Device If you insert a PC card ATA device and it is not recognized (no special files created), use the prtconf command to identify the problem. 1. Run the prtconf -D command to see if your pcata card is recognized. (A recognized device will appear at the end of the prtconf output. For example: # prtconf -D . . . pcic, instance #0 (driver name: pcic) . . . disk, instance #0 2. If pcata does not appear in the prtconf output, there is a problem with the PC card adapter configuration or with the hardware. Check to see whether the problem is with the card or the adapter by trying to use the card on another machine and by seeing if it works on the same machine using DOS. Special Files For PC card devices, nodes are created in /devices that include the socket number as one component of a device name that the node refers to. However, the /prtc/dev names and the names in /dev/dsk and /dev/rdsk do follow the current convention for ATA devices, which do not encode the socket number in any part of the name. Hot-Plugging o If you want to remove the disk, you must unmount the file system. o Use the mkfs_pcfs(1M) command to create a pcfs file system: # mkfs -F pcfs /dev/rdsk/c#d#p0:d o To mount a pcfs file system, type: # mount -F pcfs /dev/dsk/c#d#p0:c /mnt o If you want to create a ufs file system, use the newfs command and type: # newfs /dev/rdsk/c#d#s# o To mount a ufs file system, type: # mount -F ufs /dev/dsk/c#d#s# /mnt o To create a Solaris partition, run the format command and go to the Partition menu. For more information, see the format(1M) man page. FILES
/kernel/drv/pcata pcata driver ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWpsdpr | +-----------------------------+-----------------------------+ SEE ALSO
format(1M), mount(1M), newfs(1M), pcmcia(7D), attributes(5), pcfs(7FS) SunOS 5.11 2 Mar 2007 pcata(7D)
All times are GMT -4. The time now is 09:32 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy