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 302876584 by ritakadm on Monday 25th of November 2013 12:46:12 PM
Old 11-25-2013
Thank you, but my columns are not restricted to only 4, there may be 20 or more, can we make the header variable? should be the maximum number of lines in all blocks
 

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 PLAN9

dd

DD(1)							      General Commands Manual							     DD(1)

NAME

       dd - convert and copy a file

SYNOPSIS

       dd [ option value ] ...

DESCRIPTION

       Dd  copies  the specified input file to the specified output with possible conversions.	The standard input and output are used by default.
       The input and output block size may be specified to take advantage of raw physical I/O.	The options are

       -if f   Open file f for input.

       -of f   Open file f for output.

       -ibs n  Set input block size to n bytes (default 512).

       -obs n  Set output block size (default 512).

       -bs n   Set both input and output block size, superseding ibs and obs.  If no conversion  is  specified,  preserve  the	input  block  size
	       instead of packing short blocks into the output buffer.	This is particularly efficient since no in-core copy need be done.

       -cbs n  Set conversion buffer size.

       -skip n Skip n input records before copying.

       -iseek n
	       Seek n records forward on input file before copying.

       -files n
	       Catenate n input files (useful only for magnetic tape or similar input device).

       -oseek n
	       Seek n records from beginning of output file before copying.

       -count n
	       Copy only n input records.

       -conv ascii    Convert EBCDIC to ASCII.

	    ebcdic   Convert ASCII to EBCDIC.

	    ibm      Like ebcdic but with a slightly different character map.

	    block    Convert variable length ASCII records to fixed length.

	    unblock  Convert fixed length ASCII records to variable length.

	    lcase    Map alphabetics to lower case.

	    ucase    Map alphabetics to upper case.

	    swab     Swap every pair of bytes.

	    noerror  Do not stop processing on an error.

	    sync     Pad every input record to ibs bytes.

       Where  sizes are specified, a number of bytes is expected.  A number may end with or to specify multiplication by 1024 or 512 respectively;
       a pair of numbers may be separated by to indicate a product.  Multiple conversions may be specified in the style:

       is used only if or conversion is specified.  In the first two cases, n characters are copied into  the  conversion  buffer,  any  specified
       character  mapping  is  done, trailing blanks are trimmed and new-line is added before sending the line to the output.  In the latter three
       cases, characters are read into the conversion buffer and blanks are added to make up an output record of size n.   If  is  unspecified	or
       zero,  the  and	options  convert the character set without changing the block structure of the input file; the and options become a simple
       file copy.

SOURCE

       /sys/src/cmd/dd.c

SEE ALSO

       cp(1)

DIAGNOSTICS

       Dd reports the number of full + partial input and output blocks handled.

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