DSXchange

hai
i just have a problem here guys
i am getting an empty row as the first row when i use the sort stage and i want to delete it(imp thing is there is an empty in the input file)

Welcome aboard. :D

Limit it from getting to the sort. Use a filter on the Sequential File stage that reads the file, using grep or awk to bypass the empty line.

Hi,

Since you are on Windows, you can use a transformer to filter the empty row.

If you have MKS tool kit, then I guess you can grep or awk like Ray suggested. I'm not sure about the utility of MKS toolkit.

Does having MKS tool kit help us in using grep and awk functions in Windows environment?

Thanks,
Whale.

If you are sure that you are getting just one empty row in your flat file, you can do this

Include a Transformer between the input file and the Sort stage.

Add a constraint @INROWNUM>1 in your Transformer. you will get your desired result.

Most of the UNIX-on-Windows products give access to the full range of frequently-used UNIX commands. Recently I astounded some folks by opening a CMD shell, typing in SH as a command, then displaying man pages!

I do err, however, in assuming that everyone has one of these, because they can be had for free.

Ah... the Astounding Ray! :D