Search Results

Search: Posts Made By: jam_prasanna
1,213
Posted By jam_prasanna
replace a string in perl - Urgent
Hi,

Can anyone help me to replace ='is NOT NULL' to is NOT NULL in perl.

I tried all the methods which i know, i didnt arrive at the solution.

please help!!

---------- Post updated at...
2,398
Posted By jam_prasanna
Hi aigles, Thanks a ton for your help.
Hi aigles,

Thanks a ton for your help.
2,398
Posted By jam_prasanna
Hi Aigles, My requierement is is.... i...
Hi Aigles,

My requierement is is....

i need to print column1|Sql Query|column7|column8 as the output of this awk script.

like below
R1|select a.V_PRT_NBR, b.V_VMF_NAME, c.V_MOUNT_FEATURE,...
2,398
Posted By jam_prasanna
Hi aigles, Thanks for your help!!!!!! I will...
Hi aigles,

Thanks for your help!!!!!! I will call your awk scipt in my perl script. I need some modification with reference to below file
R1|Array/Network Resistor -...
2,398
Posted By jam_prasanna
Hi aigles, Your code works superb!!!!!!!!...
Hi aigles,

Your code works superb!!!!!!!! but unfortunately i need perl code to do this as i am not able to understand awk........

Thanks a lot for your quick reply.........!

---------- Post...
2,398
Posted By jam_prasanna
create sql query
Hi Everyone,

Can anyone pls help me out......with my requirement, i am struggling since 3 days. Please find the requirement below

my file contains below data
R1|Array/Network Resistor -...
5,230
Posted By jam_prasanna
Thanks for your reply. but i am not getting...
Thanks for your reply.

but i am not getting the output

---------- Post updated at 03:13 PM ---------- Previous update was at 03:11 PM ----------

my need

if 4th field contains Apple i need...
5,230
Posted By jam_prasanna
How to use wildcard * in if?
Hi,

Can anyone help me how to use * in if statement.

File contains below

line1:a|b|c|Apple-RED|
line2:c|d|e|Apple-Green|
line3:f|g|h|Orange|


I need to find line by line 4th field...
1,944
Posted By jam_prasanna
Please see my below sample file ...
Please see my below sample file

M000001866|SN74LS147DR2|9.9|1.75|1.27|DUAL|70|0|5.25|4.75|5|33|9|
M000001866|SN74LS147DR2|9.9|1.75|1.27|DUAL|70|0|5.25|4.75|5|31|9|...
1,944
Posted By jam_prasanna
column value comparison in a file
Hi,

Can any one help with my below requirement.

i need to compare each line by line and in each line i have to compare some columns values with previous line column values in perl script.
...
2,191
Posted By jam_prasanna
Sent mail in junk folder
Hi,

Can any help me? sent mail using Mail::Send is going to to_list junk folder instead of inbox.

Can any one pls help me on this.

Thanks
4,333
Posted By jam_prasanna
can any expert help me on this.
can any expert help me on this.
1,903
Posted By jam_prasanna
cron job
Hello,


Can anyone help me how to set any script as cron job. I have gone through all threads but not able to get the details. Appreciate your help.

I need to set test.pl to run on every...
4,333
Posted By jam_prasanna
Hi, Yes. Query is very much correct. ...
Hi,

Yes. Query is very much correct.

could anyone pls provide the resolution at the earliest........
4,333
Posted By jam_prasanna
sorry agn, still throwing below error ...
sorry agn,

still throwing below error

BD::Oracle::db prepare failed: ORA-00903: invalid table name (DBD ERROR: OCIStmtExecute/Describe)
4,333
Posted By jam_prasanna
Passing Hash variable in to sql query in perl
Hi Everyone,

Can anyone help me how do i call hash variable in to sql query in perl. Please see the script below

i have defined two Hash %lc and %tab as below

$lc{'REFF'}='V_RES_CLASS';...
2,775
Posted By jam_prasanna
.sql file in perl
Hi,

Can anybody help me to create .sql file in PERL.

Requiement:

while executing a query in perl script instead of writting a query output in to a file in .csv, is there a way to create...
7,527
Posted By jam_prasanna
Hi, Thanks for your quick reply. script is...
Hi,

Thanks for your quick reply. script is working fine.

Regards,
jam
7,527
Posted By jam_prasanna
how to get the yesterdays date?
Hi All,

Can anybody help me to get the yesterdays date in perl script.

My script is as below

#!/bin/perl -w
$yes=system("TZ=IST+24 date +%d-%m-%Y");
print "$yes\n";

script is writting...
52,243
Posted By jam_prasanna
os: linux enterprise 4.0 version shell : bash
os: linux enterprise 4.0 version
shell : bash
52,243
Posted By jam_prasanna
sorry madhan, i am not able to get the output....
sorry madhan, i am not able to get the output. can you please provide your screenshot? when i tried its giving an error message as
awk: syntax error near line 1
awk: illegal statement near line 1
52,243
Posted By jam_prasanna
matrix, i need the date to be in %d-%b-%Y...
matrix,

i need the date to be in %d-%b-%Y format. Also can you paste your executable script? cos when i tried i am not getting the output
52,243
Posted By jam_prasanna
I have a file two files rrp1 ...
I have a file two files
rrp1
{optimal@Simha}110:cat rrp1
VALUE|DATE|USER|
123|||
243|||
432|||

rrp2
VALUE|USER|
243|RRP|

below scipt writes the user id in rrp2 to rrp1 corrsponding to...
52,243
Posted By jam_prasanna
date in awk
Hi,

Can anyone tell me how can we assign a system date to a variable in awk script? Also how can we use this varible to print this in an other file.

Regards,
Jamuna
1,594
Posted By jam_prasanna
Thaks a lot, can u pls tell me $$<file name>...
Thaks a lot,

can u pls tell me $$<file name> does?
Showing results 1 to 25 of 40

 
All times are GMT -4. The time now is 01:16 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy