03-25-2010
Extracting 3rd column using awk from file with spaces.
BAQ001 /dev/rdsk/c2t0d7 1C13 (M) RW 69053
The line above is from a text file. I want to use awk to extract the value in the third column 1C13.
I just can't seem to get the syntax right or something. Any help would be appreciated.
Thanks,
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I've a text file like
ABC,,100
A,100,200
In the above example, I have 3 columns. I want to extract the second column.
I'm expecting a value like
100
i.e first record will not have any value but still it has to give me null value. second record should give 100.
Can anybody... (2 Replies)
Discussion started by: ronald_brayan
2 Replies
2. UNIX for Dummies Questions & Answers
Hey Everybody,
I am having much trouble figuring this out, as I am not really a programmer..:mad:
Datafile.txt
Column0 Column1 Column2
ABC DEF xxxGHI
I am running using WGET on a cronjob to grab a datafile, but I need to cut the first three characters from... (6 Replies)
Discussion started by: rickdini
6 Replies
3. Shell Programming and Scripting
I have a H U G E file with over 1million entries in it.
Looks something like this:
USER0001|DEVICE001|VAR1
USER0001|DEVICE001|VAR2
USER0001|DEVICE001|VAR3
USER0001|DEVICE001|VAR4
USER0001|DEVICE001|VAR5
USER0001|DEVICE001|VAR6
USER0001|DEVICE002|VAR1
USER0001|DEVICE002|VAR2... (4 Replies)
Discussion started by: SoMoney
4 Replies
4. Shell Programming and Scripting
Hi Gurus,
We have a ftpserver from which we do a dir command and output it to a local file.
The content of the ftpfile is:
07-15-09 06:06AM 5466 ABC_123_ER19057320090714082723.ZIP
07-15-09 06:07AM 3801 ABC_123_ER19155920090714082842.ZIP
07-15-09 06:07AM ... (14 Replies)
Discussion started by: donisback
14 Replies
5. Shell Programming and Scripting
Hi All:
I have following files:
File 1:
<header>
text...
text ..
text ..
text ..
<\header>
x
y
z
...
File 2:
<header>
text...
text ..
text .. (4 Replies)
Discussion started by: mrn006
4 Replies
6. Shell Programming and Scripting
Hello,
BC106081_abc_128240811_128241377 7.96301
BC106081_abc_128240811_128241377 39.322
BC106081_cde_128240811_128241377 1.98628
BC106081_def_128240811_128241377 -2.44492
BC106081_abc_128240811_128241377 69.5504
FLJ00075_xyz_14406_16765 -0.173417
... (3 Replies)
Discussion started by: Diya123
3 Replies
7. Shell Programming and Scripting
Hi,
I need an awk script (or whatever shell-construct) that would take data like below and get the max value of 3 column, when grouping by the 1st column.
clientname,day-of-month,max-users
-----------------------------------
client1,20120610,5
client2,20120610,2
client3,20120610,7... (3 Replies)
Discussion started by: ckmehta
3 Replies
8. Shell Programming and Scripting
Hi,
I need to compare 2 text files with around 60000 rows and 1 column. I need to compare these and write the mismatch data to 3rd file.
File1 - file2 = file3
wc -l file1.txt
58112
wc -l file2.txt
55260
head -5 file1.txt
101214200123
101214700300
101250030067
101214100500... (10 Replies)
Discussion started by: Divya Nochiyil
10 Replies
9. Shell Programming and Scripting
Hi have a large spreadsheet which has 4 columns
APM00111803814 server_2 96085 Corp IT Desktop and Apps
APM00111803814 server_2 96085 Corp IT Desktop and Apps
APM00111803814 server_2 96034 Storage Mgmt Team
APM00111803814 server_2 96152 GWP... (6 Replies)
Discussion started by: kieranfoley
6 Replies
10. Shell Programming and Scripting
input
"A","B","C,D","E","F"
"S","T","U,V","W","X"
"AA","BB","CC,DD","EEEE","FFF"
required output:
"A","B","C,D","C,D","F"
"S", T","U,V","U,V","X"
"AA","BB","CC,DD","CC,DD","FFF"
tried using awk but double quotes not preserving for every field. any help to solve this is much... (5 Replies)
Discussion started by: khblts
5 Replies
LEARN ABOUT SUNOS
prtvtoc
prtvtoc(1M) System Administration Commands prtvtoc(1M)
NAME
prtvtoc - report information about a disk geometry and partitioning
SYNOPSIS
prtvtoc [-fhs] [-t vfstab] [-m mnttab] device
DESCRIPTION
The prtvtoc command allows the contents of the label to be viewed. The command can be used only by the super-user.
The device name can be the file name of a raw device in the form of /dev/rdsk/c?t?d?s2 or can be the file name of a block device in the
form of /dev/dsk/c?t?d?s2.
OPTIONS
The following options are supported:
-f Report on the disk free space, including the starting block address of the free space, number of blocks, and unused parti-
tions.
-h Omit the headers from the normal output.
-m mnttab Use mnttab as the list of mounted filesystems, in place of /etc/mnttab.
-s Omit all headers but the column header from the normal output.
-t vfstab Use vfstab as the list of filesystem defaults, in place of /etc/vfstab.
EXAMPLES
Example 1: Using the prtvtoc Command
The following example uses the prtvtoc command on a 424-megabyte hard disk:
example# prtvtoc /dev/rdsk/c0t3d0s2
* /dev/rdsk/c0t3d0s2 partition map
*
* Dimension:
* 512 bytes/sector
* 80 sectors/track
* 9 tracks/cylinder
* 720 sectors/cylinder
* 2500 cylinders
* 1151 accessible cylinders
*
* Flags:
* 1: unmountable
* 10: read-only
* * First Sector Last
* Partition Tag Flags Sector Count Sector Mount Directory
0 2 00 0 76320 76319 /
1 3 01 76320 132480 208799
2 5 00 0 828720 828719
5 6 00 208800 131760 340559 /opt
6 4 00 340560 447120 787679 /usr
7 8 00 787680 41040 828719 /export/home
example#
The data in the Tag column above indicates the type of partition, as follows:
Name Number
UNASSIGNED 0x00
BOOT 0x01
ROOT 0x02
SWAP 0x03
USR 0x04
BACKUP 0x05
STAND 0x06
VAR 0x07
HOME 0x08
ALTSCTR 0x09
CACHE 0x0a
RESERVED 0x0b
The data in the Flags column above indicates how the partition is to be mounted, as follows:
Name Number
MOUNTABLE, READ AND WRITE 0x00
NOT MOUNTABLE 0x01
MOUNTABLE, READ ONLY 0x10
Example 2: Using the prtvtoc Command with the -f Option
The following example uses the prtvtoc command with the -f option on a 424-megabyte hard disk:
example# prtvtoc -f /dev/rdsk/c0t3d0s2
FREE_START=0 FREE_SIZE=0 FREE_COUNT=0 FREE_PART=34
Example 3: Using the prtvtoc Command on a Disk Over One Terabyte
The following example uses uses the prtvtoc command on a disk over one terabyte:.
example# prtvtoc /dev/rdsk/c1t1d0s2
* /dev/rdsk/c1t1d0s2 partition map
*
* Dimensions:
* 512 bytes/sector
* 3187630080 sectors
* 3187630013 accessible sectors
*
* Flags:
* 1: unmountable
* 10: read-only
*
* First Sector Last
* Partition Tag Flags Sector Count Sector Mount Directory
0 2 00 34 262144 262177
1 3 01 262178 262144 524321
6 4 00 524322 3187089340 3187613661
8 11 00 3187613662 16384 318763004
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
SEE ALSO
devinfo(1M), fmthard(1M), format(1M), mount(1M), attributes(5)
WARNINGS
The mount command does not check the "not mountable" bit.
SunOS 5.10 25 Jul 2002 prtvtoc(1M)