hi all
hw to identify and remove blank rows from the source file
blank rows in the file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Hi madhur,
Can you be clear whether your balnk line means something like this
XXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXAAA
or
XXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXAAA
In first case no need to wory as these records will be rejected by the sequential file stage if you want these records to be trapped then
use a reject link from sequntial files.
seq---------->Trns---------->.......
|
|
|
V
seq (reject)
Reject file contains all teh blank records.
Can you be clear whether your balnk line means something like this
XXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXAAA
or
XXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXAAA
In first case no need to wory as these records will be rejected by the sequential file stage if you want these records to be trapped then
use a reject link from sequntial files.
seq---------->Trns---------->.......
|
|
|
V
seq (reject)
Reject file contains all teh blank records.
Happy DataStaging
-
- Participant
- Posts: 122
- Joined: Mon Jul 05, 2004 1:33 pm
- Location: MA
I was searching for a solution on a similar problem and found this post. In my experiance the job still throws warnings even when there is a reject link! Would that be right or am i doing something wrong.
dsxdev wrote:Hi madhur,
Can you be clear whether your balnk line means something like this
XXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXAAA
or
XXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXAAA
In first case no need to wory as these records will be rejected by the sequential file stage if you want these records to be trapped then
use a reject link from sequntial files.
seq---------->Trns---------->.......
|
|
|
V
seq (reject)
Reject file contains all teh blank records.
Regards
Sonia Jacob
Sonia Jacob
Use the filter command and use the sed operation to find and delete empty lines.
Put this in the filter command box
Put this in the filter command box
Code: Select all
sed -e '/^$/d'
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.