01-08-2015
Load an array of 20 entries, "NULL Default_01" through "NULL Default_20". The read your file and replace the first entries in the array with column names from the file. Now, generate a query string from the array, and run it. What does input look like?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I need a script that will run a dynamic Oracle SQL. Dynamic meaning the SQL statement depends on the parameter.
For instance, something like this:
#!/bin/ksh -x
# Set environment
. /home/mine/set_vars
sqlplus $LOGINID <<! >> /home/mine/log.txt
select count(1) from $1
where... (2 Replies)
Discussion started by: laiko
2 Replies
2. Shell Programming and Scripting
I have data extracted like this:
A=%123% B=%456% C=%789%
A=%111% B=%222% C=%333%
A=%777% B=%888% C=%999%
Can someone please help me with a script to remove all the % signs and get the totals for A, B and C.
So output will be:
A=1368
B=666
C=2664
Thank you! (2 Replies)
Discussion started by: tatchel
2 Replies
3. Shell Programming and Scripting
Hi,
I have a huge file with a single line.
But I want to break that line into lines of with each line having five columns.
My file is like this:
code:
"hi","there","how","are","you?","It","was","great","working","with","you.","hope","to","work","you."
I want it like this:
code:... (1 Reply)
Discussion started by: rajsharma
1 Replies
4. UNIX for Dummies Questions & Answers
Hi Gurus,
This below script adds a column extra to my flat file..But how can i add another column, Say if i just put mention an other column beside the first column..it does get generated but as one column only
while IFS="" read r; do
printf "dummy\t%s\n" "$r"
done < xxx.txt > zzz.txt
... (9 Replies)
Discussion started by: saggiboy10
9 Replies
5. Shell Programming and Scripting
I am trying to selectively display several columns from a db2 query, which gives me a fixed-width output (partial output listed here):
--------- -------------------------- ------------ ------
000 0000000000198012 702 29
000 0000000000198013 ... (9 Replies)
Discussion started by: ahsh79
9 Replies
6. Shell Programming and Scripting
Hi Friends,
I have the following input file
cat input
chr1 100 200 0.1 0.2 na 1 na nd
chr1 105 200 0.1 0.2 1 1 na 98
chr1 110 290 nf 1 na nd na 1
chr2 130 150 12 3 na 1 na 1
chr3 450 600 nf nf na 10 na nd
chr4 300 330 1 1 10 11 23 34
My requirement is
1. If $6 is na make $7 nd and... (2 Replies)
Discussion started by: jacobs.smith
2 Replies
7. UNIX for Dummies Questions & Answers
Hi,
I have connected to oracle database with sqlplus -s / <<EOF
select ename, age from emp where empid=1234;
EOF
I want to save the values of ename and age in unix shell variables. Any pointers would be welcome..
Thanks in advance!!1
Cheers :):):):) (1 Reply)
Discussion started by: gonchusirsa
1 Replies
8. Shell Programming and Scripting
Hi all, I know this sounds suspiciously like a homework course; but, it is not.
My goal is to take a file, and match my "ID" column to the "Date" column, if those conditions are true, add the total number of minutes worked and place it in this file, while not printing the original rows that I... (6 Replies)
Discussion started by: mtucker6784
6 Replies
9. Programming
Hi, I have 2 different values in the same column and two different values in other column
Query 1
ins name value
1 Test 12345
1 TestV1 12/10/2014
8 Test 85435
8 TestV1 11/11/2005
9 Test 42232
9 TestV1 19/10/2000
6 Test 54321... (6 Replies)
Discussion started by: faka
6 Replies
10. Shell Programming and Scripting
I have two files, file1 and file2 who have identical number of rows and columns. However, the script is supposed to be used for for different files and I cannot know the format in advance. Also, the number of columns changes within the file, some rows have more and some less columns (they are... (13 Replies)
Discussion started by: maya3
13 Replies
LEARN ABOUT PHP
array_splice
ARRAY_SPLICE(3) 1 ARRAY_SPLICE(3)
array_splice - Remove a portion of the array and replace it with something else
SYNOPSIS
array array_splice (array &$input, int $offset, [int $length], [mixed $replacement = array()])
DESCRIPTION
Removes the elements designated by $offset and $length from the $input array, and replaces them with the elements of the $replacement
array, if supplied.
Note that numeric keys in $input are not preserved.
Note
If $replacement is not an array, it will be typecast to one (i.e. (array) $parameter). This may result in unexpected behavior when
using an object or NULL$replacement.
PARAMETERS
o $input
- The input array.
o $offset
- If $offset is positive then the start of removed portion is at that offset from the beginning of the $input array. If $offset is
negative then it starts that far from the end of the $input array.
o $length
- If $length is omitted, removes everything from $offset to the end of the array. If $length is specified and is positive, then
that many elements will be removed. If $length is specified and is negative then the end of the removed portion will be that many
elements from the end of the array. If $length is specified and is zero, no elements will be removed. Tip: to remove everything
from $offset to the end of the array when $replacement is also specified, use count($input) for $length.
o $replacement
- If $replacement array is specified, then the removed elements are replaced with elements from this array. If $offset and
$length are such that nothing is removed, then the elements from the $replacement array are inserted in the place specified by the
$offset. Note that keys in replacement array are not preserved. If $replacement is just one element it is not necessary to put
array() around it, unless the element is an array itself, an object or NULL.
RETURN VALUES
Returns the array consisting of the extracted elements.
EXAMPLES
Example #1
array_splice(3) examples
<?php
$input = array("red", "green", "blue", "yellow");
array_splice($input, 2);
// $input is now array("red", "green")
$input = array("red", "green", "blue", "yellow");
array_splice($input, 1, -1);
// $input is now array("red", "yellow")
$input = array("red", "green", "blue", "yellow");
array_splice($input, 1, count($input), "orange");
// $input is now array("red", "orange")
$input = array("red", "green", "blue", "yellow");
array_splice($input, -1, 1, array("black", "maroon"));
// $input is now array("red", "green",
// "blue", "black", "maroon")
$input = array("red", "green", "blue", "yellow");
array_splice($input, 3, 0, "purple");
// $input is now array("red", "green",
// "blue", "purple", "yellow");
?>
Example #2
array_splice(3) examples
The following statements change the values of $input the same way:
<?php
array_push($input, $x, $y);
array_splice($input, count($input), 0, array($x, $y));
array_pop($input);
array_splice($input, -1);
array_shift($input);
array_splice($input, 0, 1);
array_unshift($input, $x, $y);
array_splice($input, 0, 0, array($x, $y));
$input[$x] = $y; // for arrays where key equals offset
array_splice($input, $x, 1, $y);
?>
SEE ALSO
array_slice(3), unset(3), array_merge(3).
PHP Documentation Group ARRAY_SPLICE(3)