Search found 19 matches

by sribuz
Wed Dec 26, 2007 12:21 pm
Forum: General
Topic: New Year Wishes
Replies: 15
Views: 6443

HAPPY NEW YEAR

I wish all DSXchange users a HAPPY NEW YEAR.
by sribuz
Wed Dec 26, 2007 12:13 pm
Forum: General
Topic: Deleting header of Data file In UNIX
Replies: 7
Views: 2821

Sed command I used

I used sed -e "/Header Start/,/End Word/d" orginalfile.dat>newfile.dat This will search for 'headerStart' and delete lines till it reaches 'endword'. using this command I have deleted the all header instances and saved into newfile. FYI we put /Header Start/,/End Word/d in double quotes (a...
by sribuz
Tue Dec 25, 2007 11:38 pm
Forum: General
Topic: Deleting header of Data file In UNIX
Replies: 7
Views: 2821

Deleting header of Data file In UNIX

Hi, I am getting a data file into Unix box and it is generated using COBOL. The file has Header and footer repeating every page, my objective is to eliminate header and footer and process records between them. I used sed command to delete Header but the real problem is the previous record is also de...
by sribuz
Sun Dec 02, 2007 1:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: To spilt the year to Months
Replies: 4
Views: 1793

I think simple If statement will do

compare the second character in year
012007 take 1 assign as a
052007 take 5 assign as b

if a<=b
then incerase a by 1
and write year as 0a2007
(this gives your result as 012007,022007,032007,042007)
and rate = prev rate (=2 in first case)
else
rate=newrate (= 5 rate of 052007)
end