10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All, when I executed the query in normal unix mode, the output is
expected. if I executed the query using shell script, I am not getting the result. not sure whether I need to use dbms_output.put_line or echo.
dbms_output.put_line("COUNTRY_CODE"||" "||"SUB_TYPE"||" ... (3 Replies)
Discussion started by: arun888
3 Replies
2. Shell Programming and Scripting
Hi, i'm just after a simple explanation of how the following awk oneliner works.
gawk -F"," '{for(i=m;i<=n;i++)printf "%s" OFS,$i; print x}' m=1 n=70 OFS=, input.csv > output.csv
In particular i'm trying to understand how the two print statements work? How is the "x" variable being assigned... (3 Replies)
Discussion started by: theflamingmoe
3 Replies
3. Shell Programming and Scripting
can someone help me how to interpret this line?
my ($class, $hashref) = @_;
my $portfolio = {};
if ($hashref->{portfolio_id}) {
($portfolio) = GEmySQL->get ("select * from portfolio where portfolio.id=$hashref->{portfolio_id}");
}
===============
Question: how do... (2 Replies)
Discussion started by: onlinelearner02
2 Replies
4. Shell Programming and Scripting
Hello,
is there a way to use the awk print statement on two files at once? I would like to take two columns from one file, and one column from another file and print them as consecutive columns to a third file. Seems simple...as in:
file 1
1 a
2 b
3 c
4 d
5 e
file 2
1 t
2 u... (3 Replies)
Discussion started by: HugoHuhn
3 Replies
5. Shell Programming and Scripting
Hi,
I am using awk statement to extract data from a file and write a new file with certain columns rearranged and few hard coded values added to new file.
Now i need to add a column with sysdate. can i do that inside the awk print statement?
Now:
nawk ' /^3/ BEGIN {FS=","}... (2 Replies)
Discussion started by: selvankj
2 Replies
6. UNIX for Dummies Questions & Answers
Hi All,
I am writing a perl script where I take 2 variables from the user as STDIN to scan the lines of a file to produce as output.
How can I do an IF loop to test this for example in the mock file
12 10
35 20
37 5
45 12if I take user input as 40 and 10, how can I get the output lines in... (3 Replies)
Discussion started by: pawannoel
3 Replies
7. Shell Programming and Scripting
How can i print the output of a perl script on a unix console and redirect the same in a log file under same directory simultaneously ?
Like in Shell script, we use tee, is there anything in Perl or any other option ? (2 Replies)
Discussion started by: butterfly20
2 Replies
8. Shell Programming and Scripting
:confused: I have a ksh script which gathers data from a file. I need to find a way to direct the output to a new file. The code looks something like this:
DUP_FILE=`touch /export/.../.../dup_social_$1`
while (($# > 0 ))
do
# Make sure the file exists
if ]
then
print "$1: does not... (4 Replies)
Discussion started by: Muga801
4 Replies
9. Shell Programming and Scripting
Hi all,
I have some code like this
awk -F, '{
if ($1==3)
print $2 > "output_file"
print "1" > "new_file"
}' "input_file"
When I check output_file this has the correct values in it. However the new_file has 1 in it for every line in the input_file. If the input file has 20 lins then... (2 Replies)
Discussion started by: Donkey25
2 Replies
10. Shell Programming and Scripting
Hello guys,
I was wondering why my code doesn't read a variable when using if statement as follows:
$userlist='users.txt';
$user='b999';
open (ACTULOG, ">>$userlist");
print ACTULOG "$user\n";
close (ACTULOG)
this will work and prints... (3 Replies)
Discussion started by: Bashar
3 Replies