|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Put repeated values into a table
Post 302876582 by bartus11 on Monday 25th of November 2013 12:42:26 PM
|
|
10 More Discussions You Might Find Interesting
1. Solaris
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
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
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
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
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
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
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
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
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
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 PHP
px_get_info
PX_GET_INFO(3) PX_GET_INFO(3) px_get_info - Return lots of information about a paradox file SYNOPSIS
array px_get_info (resource $pxdoc) DESCRIPTION
PARAMETERS
o $pxdoc - Resource identifier of the paradox database as returned by px_new(3). RETURN VALUES
Returns an associated array with lots of information about a paradox file. This array is likely to be extended in the future. o fileversion -Version of file multiplied by 10, e.g. 70. o tablename -Name of table as stored in the file. If the database was created by pxlib, then this will be the name of the file without the extension. o numrecords -Number of records in this table. o numfields -Number of fields in this table. o headersize -Number of bytes used for the header. This is usually 0x800. o recordsize -Number of bytes used for each record. This is the sum of all field sizes (available since version 1.4.2). o maxtablesize - This value multiplied by 0x400 is the size of a data block in bytes. The maximum number of records in a datablock is the integer part of (maxtablesize * 0x400 - 8) / recordsize. o numdatablocks - The number of data blocks in the file. Each data block contains a certain number of records which depends on the record size and the data block size (maxtablesize). Data blocks may not necessarily be completely filled. o numindexfields - Number of fields used for the primary index. The fields do always start with field number 1. o codepage - The DOS codepage which was used for encoding fields with character data. If the target encoding is not set with px_set_targeten- coding(3) this will be the encoding for character fields when records are being accessed with px_get_record(3) or px_retrieve_record(3). SEE ALSO
px_numfields(3), px_numrecords(3). PHP Documentation Group PX_GET_INFO(3)