Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Put repeated values into a table
Top Forums Shell Programming and Scripting Put repeated values into a table Post 302876596 by Akshay Hegde on Monday 25th of November 2013 01:47:04 PM
Old 11-25-2013
Quote:
Originally Posted by RavinderSingh13
Hello Akshay,

Thanks for great code could you please explain the same.


Thanks,
R. Singh
awk '!A[$1]++{s = s ? s OFS $1 : $1}.... --> Here unique records from column 1 are stored in variable s

{B[++i]=$2} --> Array B holds column2 records

and finally in END block

END{print s;.. --> Prints unique records in variable s

for(j=1;j<=i;j++) --> Looping for 1 to i

B[j] !~ /[[:alnum:]]/ || j == i ? RS : OFS --> if B[j] is not alphanumeric or j equal to i thats end of loop print B[j] and Row separator ("\n") else print B[j] and output field separator (OFS)
This User Gave Thanks to Akshay Hegde For This Post:
ritakadm
 

10 More Discussions You Might Find Interesting

1. Solaris

Can I put my own tags in a partition table

I have X4500 running Solaris 10. I have formatted a disk and created partition table as given below. Specify disk (enter its number): 0 selecting c0t0d0 /dev/dsk/c0t0d0s0 is part of active ZFS pool zpool1. Please see zpool(1M). FORMAT MENU: disk - select a disk ... (3 Replies)
Discussion started by: bharu_sri
3 Replies

2. Shell Programming and Scripting

To Delete the repeated occurances and print in same line by appending values

Hi All, I am trying to work on below text a b c 1 a b c 2 a b c 3 x y z 6 x y z 44 a b c 89 Need to delete the occurances and get in single line like below: a b c 1 2 3 89 x y z 6 44 89 Please help me i am new into unix scripting ..... ---------- Post updated at 03:00... (8 Replies)
Discussion started by: shaliniyadav
8 Replies

3. Shell Programming and Scripting

comparing the values of repeated keys in multiple columns

Hi Guyz The 1st column of the input file has repeated keys like x,y and z. The ist task is if the 1st column has unique key (say x) and then need to consider 4th column, if it is + symbol then subtract 2nd column value with 3rd column value (we will get 2(10-8)) or if it is - symbol subtract 3rd... (3 Replies)
Discussion started by: repinementer
3 Replies

4. Shell Programming and Scripting

select values from db1 table and insert into table of DB2

Hi I am having three oracle databases running in three different machine. their ip address is different. from one of the DB am able to access both the databases.(means am able to select values and insert values in to tables individually.) I need to fetch some data from DB1 table(say DB1 ip is... (2 Replies)
Discussion started by: aemunathan
2 Replies

5. Shell Programming and Scripting

remove brackets and put it in a column and remove repeated entry

Hi all, I want to remove the remove bracket sign ( ) and put in the separate column I also want to remove the repeated entry like in first row in below input (PA156) is repeated ESR1 (PA156) leflunomide (PA450192) (PA156) leflunomide (PA450192) CHST3 (PA26503) docetaxel... (2 Replies)
Discussion started by: manigrover
2 Replies

6. Shell Programming and Scripting

How do I put data piped to my script into an array for repeated processing

Hi folks, Sorry for something I'm sure was answered already, I just could not find it in a search of the forums. I am trying to build a script that eats a config file as: cat file.cnf | ConProcess.shWhat I want to do inside the script is: !#/usr/bin/bash # captured piped cat into an... (6 Replies)
Discussion started by: Marc G
6 Replies

7. Shell Programming and Scripting

Resume and count repeated values

Gents, Please can you help me. Input file 1050 , 9 ,9888 1050 ,10 ,9888 1050 ,11 ,9888 1050 ,13 ,9888 1050 ,15 ,9888 1051 , 9 ,9889 1051 ,12 ,9889 1051 ,15 ,9889 1051 ,18 ,9889 1052 , 9 ... (7 Replies)
Discussion started by: jiam912
7 Replies

8. Shell Programming and Scripting

Query the table and return values to shell script and search result values from another files.

Hi, I need a shell script, which would search the result values from another files. 1)execute " select column1 from table_name" query on the table. 2)Based on the result, need to be grep from .wft files. could please explain about this.Below is the way i am using. #!/bin/sh... (4 Replies)
Discussion started by: Rami Reddy
4 Replies

9. Shell Programming and Scripting

awk file to read values from Db2 table replacing hard coded values

Hi, I want to replace a chain of if-else statement in an old AWK file with values from Db2 table or CSV file. The part of code is below... if (start_new_rec=="true"){ exclude_user="false"; user=toupper($6); match(user, "XXXXX."); if (RSTART ==2 ) { ... (9 Replies)
Discussion started by: asandy1234
9 Replies

10. Shell Programming and Scripting

Adding the values of repeated ids

File1 consist two columns, first some weired ids and second the numbers t|v203.1@t|k88711.1 0.1 t|v190.1@t|k90369.1 0.01 t|v203.1@t|k88711.1 0.5 t|v322.1@t|k88711.1 0.2 t|v207.1@t|k90369.1 0.11 t|v326.1@t|k85939.1 0.5 t|v207.1@t|k90369.1 0.7 t|v207.1@t|k90369.1 0.3 t|v326.1@t|k89421.1 0.33... (3 Replies)
Discussion started by: ashmit99
3 Replies

LEARN ABOUT HPUX

df_vxfs

df_vxfs(1M)															       df_vxfs(1M)

NAME

       df_vxfs: df - report number of free disk blocks on a VxFS file system

SYNOPSIS

       [special|directory]...

DESCRIPTION

       prints the number of free blocks and free inodes in VxFS file systems or directories based on the counts kept in the super-blocks.

       VxFS dynamically allocates inodes from a pool of free blocks.  The number of free inodes and blocks reported by is an estimate based on the
       number of free 8K or larger extents and the current ratio of allocated inodes to allocated blocks.  (Extents smaller than  8K  may  not	be
       usable  for all types of allocation, so does not count free blocks in extents smaller than 8K.)	Allocating additional blocks may therefore
       decrease the count of free inodes and vice versa.

       If the operand to is a special device name, the file system can be an unmounted or mounted file system  (for  example,  If  you	specify  a
       directoryname, displays information for the file system at that mount point.  If neither special nor directory is specified, the free space
       on all of the mounted file systems is printed.

   Options
       recognizes the following options:

	      Report only the number of kilobytes free.

	      Report the number of files free.

	      Report only an actual count of the blocks in the free list
			     (free inodes are not reported).  When this option is specified, reports on raw devices.

	      Specify the file system type

	      Report the entire
			     statvfs(2) structure.

	      Report the total number of inodes, the number of free inodes, number of used inodes
			     and the percentage of inodes in use.

	      Report the allocation in kilobytes.

	      Report on local file systems only.

	      Report the file system name.  If invoked with no other options this
			     option prints a list of mounted file system types.

	      Print the number of free extents of each size.
			     Free extents are always an integral power of two in length, ranging from a minimum of one block to the maximum extent
			     size supported by the file system.

	      Report the total allocated block figures and the number of free blocks.

	      Report the percentage of blocks used, the number of blocks used and the number
			     of blocks free. This option cannot be used with other options.

	      Echo the completed command line, but performs no other action.
			     The  command  line  is  generated by incorporating the user-specified options and other information derived from This
			     option allows the user to verify the command line.

       There are a number of options that specify output formats, some combinations of which are incompatible.	If an incompatible combination	is
       specified, one of the options will override the other(s).

   Operands
       recognizes the following operands:

	      directory      Name of the mount point from which the VxFS file system is accessed.

	      special	     Device name, which contains a mounted or unmounted VxFS file system.

EXAMPLES

       Report the number of free disk blocks for all mounted file systems:

       Report the number of free extents of each size, for all mounted VxFS file systems:

       Report the number of free files for all mounted VxFS file systems:

       Report the total allocated block figures and the number of free blocks, for all mounted file systems:

       Report the total allocated block figures and the number of free blocks, for the file system mounted as

FILES

       File-system devices.
       File-system devices.
       Static information about the file systems.
       mounted-file-system table.

SEE ALSO

       du(1), df(1M), fsck_vxfs(1M), statvfs(2), fs_vxfs(4), mnttab(4).

STANDARDS CONFORMANCE

       : SVID2, XPG2, XPG3

																       df_vxfs(1M)
All times are GMT -4. The time now is 06:21 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy