Search found 19 matches
- 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.
- 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...
- 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...
- 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
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