11-12-2013
Duh me! Thanks Yoda. I had c&p'd the $y and forgot to take the $ sign off!
~Guss
10 More Discussions You Might Find Interesting
1. Programming
Hi I was hoping that maybe someone could help me with a small piece of C code. I have a number of files, which are all of similar layout ie. three lines of text and 5-6 columns of numerical data. I need to add each of the elements of the second column in one file to their counterparts in the second... (17 Replies)
Discussion started by: Boucho
17 Replies
2. Shell Programming and Scripting
Hi,
How can I remove all non numerical data from line, so I don't want to delete the line but to have only the numbers.
e.g.:
#########
123
aaa124
125bbb
126
127
#########
So I want all the leading and trailing non numerical stuff(letters/white space/tabs anything else except... (10 Replies)
Discussion started by: Juha
10 Replies
3. Shell Programming and Scripting
Hi
I have a variable which should be any number between 1 and 50.
It could also be any string/empty string.
I have a code written below. The point is when the variable contains string.
I don't want the code below to error out. Instead fall in the else bucket.
&& dothis_1 || dothis_2 (1 Reply)
Discussion started by: tostay2003
1 Replies
4. Shell Programming and Scripting
I have a file, let's say X
BTS 0 UNLOCKED ENABLED NONE
TRX 0 UNLOCKED ENABLED NONE
TRX 1 UNLOCKED ENABLED NONE
BTS 1 UNLOCKED ENABLED NONE
TRX 0 UNLOCKED ENABLED NONE... (4 Replies)
Discussion started by: amaulana
4 Replies
5. Shell Programming and Scripting
Hi ,
I need to extract data from below mentioned data, having no delimiter and havin no fixed column length.
For example:
Member nbr Ref no date
10000 1000 10202012
200000 2000 11202012
Output:
to update DB with memeber nbr on basis of ref no.
... (6 Replies)
Discussion started by: ns64110
6 Replies
6. Shell Programming and Scripting
frnds:
i want to divide data on the behalf of dotted line and redirectd into new files
)
-------------------------
M-GET CONFIRMATION (
-------------------------
M-GET CONFIRMATION (
INVOKE IDENTIFIER
final data shuld be into 3 files ...... (6 Replies)
Discussion started by: dodasajan
6 Replies
7. Shell Programming and Scripting
hello!
i need a little help from you :) ... i need to split a file into separate files depending on two conditions using scripting. The file has no delimiters. The conditions are col 17 = "P" and col 81 = "*", this will go to one output file; col 17 = "R" and col 81 = " ". Here is an example.
... (3 Replies)
Discussion started by: chanclitas
3 Replies
8. Shell Programming and Scripting
Hi All,
here D Prints the bytes value .plz help to convert the variable D value to MB in new variable $E
D=`more $C |awk '{print $6;}'`
Thanks in Advance.:) (3 Replies)
Discussion started by: netdbaind
3 Replies
9. Shell Programming and Scripting
F= `expr $E/$S`
output
test5.sh: line 45: 1296863.27001857757568359375/21997: No such file or directory
can any one help me ,i just want to divide the $E/$S and Print o/p in F. (3 Replies)
Discussion started by: netdbaind
3 Replies
10. Shell Programming and Scripting
File 1
---------
N_ACCT,CARD_TYPE,CARD_BAL,CUST_CODE
---------------------------------------------------
0301,38,0.00,10
0319,38,54422.92,10
0392,38,0.00,10
0418,38,35254.87,10
0442,38,0.00,10
0491,38,0.00,10
0558,38,45988.76,10
0616,38,0.00,10
0665,38,0.00,10
0699,38,0.00,10
File 2... (3 Replies)
Discussion started by: suresh_target
3 Replies
LEARN ABOUT OSX
dbix::class::sqlmaker::oraclejoins
DBIx::Class::SQLMaker::OracleJoins(3) User Contributed Perl Documentation DBIx::Class::SQLMaker::OracleJoins(3)
NAME
DBIx::Class::SQLMaker::OracleJoins - Pre-ANSI Joins-via-Where-Clause Syntax
PURPOSE
This module is used with Oracle < 9.0 due to lack of support for standard ANSI join syntax.
SYNOPSIS
Not intended for use directly; used as the sql_maker_class for schemas and components.
DESCRIPTION
Implements pre-ANSI joins specified in the where clause. Instead of:
SELECT x FROM y JOIN z ON y.id = z.id
It will write:
SELECT x FROM y, z WHERE y.id = z.id
It should properly support left joins, and right joins. Full outer joins are not possible due to the fact that Oracle requires the entire
query be written to union the results of a left and right join, and by the time this module is called to create the where query and table
definition part of the sql query, it's already too late.
METHODS
select
Overrides DBIx::Class::SQLMaker's select() method, which calls _oracle_joins() to modify the column and table list before calling
next::method().
BUGS
Does not support full outer joins (however neither really does DBIC itself)
SEE ALSO
DBIx::Class::Storage::DBI::Oracle::WhereJoins - Storage class using this
DBIx::Class::SQLMaker - Parent module
DBIx::Class - Duh
AUTHOR
Justin Wheeler "<jwheeler@datademons.com>"
CONTRIBUTORS
David Jack Olrik "<djo@cpan.org>"
LICENSE
This module is licensed under the same terms as Perl itself.
perl v5.16.2 2012-08-16 DBIx::Class::SQLMaker::OracleJoins(3)