Hi guys
I am trying to remove carriage return /space in perl from my file
using this function :
$record =~ s/[\r\n\r]+/ /g; OR
chomp($record);
nothing is working , can anybody help me please with this
Shrutisinha
Last Activity: Aug 15 '07, 07:55 PM
Joined: Feb 9 '07
Location:
-
Removing carriage returns
-
not working still :( -
well STATUS_EFF_DT is a date record .. so that not the problem.. thanksLeave a comment:
-
need help with dates in teradata
Please somebody could help me with dates .. its giving me error thanks
select c.bill_dt from
emp c,dept b
where c.ban=b.ban
and c.BILLED_DT Between (add_month(b.ST ATUS_EFF_DT,-1)
And b.STATUS_EFF_DT -
Create table as copy of existing table
Hi Guys
Really need your help I donno what I am doing wrong in here
Want to create a table with another existing table
Here is the syntax I am using
create table pctemp1
As
(SELECT distinct a.Promo,b.Ban,b .[Ban Status],
b.[BAn Statys Reson Code],b.[Last Ban Status Date]
FROM PC_FUSION_07042 4 a
LEFT OUTER JOIN ARCL05_070423 b
ON a.BAN = b.BAN
WHERE b.BAN is not... -
Create Table Syntax
Hi Guys
Really need your help I donno what I am doing wrong in here
Want to create a table with another existing table
Here is the syntax I am using
create table pctemp1
As
(SELECT distinct a.Promo,b.Ban,b .[Ban Status],
b.[BAn Statys Reson Code],b.[Last Ban Status Date]
FROM PC_FUSION_07042 4 a
LEFT OUTER JOIN ARCL05_070423 b
ON a.BAN = b.BAN
WHERE b.BAN... -
syntax error near unexpected token `('
I am getting this error in unix ..
syntax error near unexpected token `('
when i am running my parser , can anybody help me plzz .. i am new to all this
thanks -
its working thanks a lot :)...Leave a comment:
-
I found dos2unix,but I do not know how to properly implement it
my code is all fallows ... i do have ^M, plz help me
# Declare the subroutines^M
sub trim($);^M
sub ltrim($);^M
sub rtrim($);^M
^M
# Perl trim function to remove whitespace from the start and end of the string^M
sub trim($)^M
{^M
my $string = shift;^M
$string =~ s/^\s+//;^M
...Leave a comment:
-
Running script on Unix. Created on DOS.
Hi
please anybody can help me again !!!
I created a code in perl(which parse my current file) but using dos evniornment , now want to run same code made in perl but in Unix
do i have to change any coding ??
I can put the code if somebody can help me plzz -
thanks a lot .. it worked , thanks you lot guys for all your help...Leave a comment:
-
Do i have to put in loop bez all my number don't have ","
some are 800.50
765.34
1,234.80
so nervious with perl
thanks...Leave a comment:
-
Removing commas from numbers
I need a help in perl as very new to perl
I have balance 1,00.00 and want to change it to 1000.00
I want to remove "," from my balance
I am doing parsing my orignal record has a "," in my balance and want to remove that come
I can't understand what can i do to remove that in perl, may be there is replace fuction or something , somebody plese help me with this issue
Thanks -
b doesn't exist...Leave a comment:
-
help me with update
i want to update 2 coloums balance and methord type and its showing me error , some plz help me
UPDATE CREDIT_SRVCS_TA BLES.Baseline
SET BALANCE = b.BALANCE,
PAYMENT_TYPE = b.PAYMENT_TYPE
Where ban IN (
Select Distinct b.ban
From CREDIT_SRVCS_TA BLES.Baseline a
INNER JOIN CREDIT_SRVCS_TA BLES.Weekly b
ON a.BAN=b.BAN
Where a.End_dt is Not Null ) -
select * from emp H
where H.BILLED_DT BETWEEN Max(H.BILLED_DT ) AND add_months(Max( H.BILLED_DT),-1)
ERROR IMPROPER USE OF AN AGGREGATE FUNCTIONIN A WHERE CLAUSE...Leave a comment:
-
select * from emp H
where H.BILLED_DT BETWEEN Max(H.BILLED_DT ) AND add_months(Max( H.BILLED_DT),-1)
ERROR IMPROPER USE OF AN AGGREGATE FUNCTIONIN A WHERE CLAUSE...Leave a comment:
-
well u don't need value clause when u are using select statment...Leave a comment:
-
Use Of Between Operator In Teradata
need a help in using between operator in tera data
i want to ose as condition and other conditio too
where H.BILLED_DT BETWEEN Max(H.BILLED_DT ) AND add_months(Max( H.BILLED_DT),-1)
ERROR IMPROPER USE OF AN AGGREGATE FUNCTIONIN A WHERE CLAUSE -
I need a help in TERADATA
I have 2 tables baseline and weekly, baseline is master table andi update baseline by weekly but comparing the new records in the weekly tablle
can somebody help me i have ban number in both the tables and end_date in the baseline table , once the ban is out from the weekly table it get end date in teh baseline table saying that ban is out , now if the ban come back in weekly table with new strat date how do i insert the record in baseline...
No activity results to display
Leave a comment: