I have a file like this:
*NEW ZEALAND DOLLAR 0.6486 0.6506
NORWAY KRONE 6.6930 6.6750
SINGAPORE DOLLAR 1.7100 1.7059
SOUTH AFRICA RAND 6.3200 6.3750
How can I get rid of the extra line in between using vb script in DTS package. I know there is an extra line feed at end of each line.
Thanks a lot.
*NEW ZEALAND DOLLAR 0.6486 0.6506
NORWAY KRONE 6.6930 6.6750
SINGAPORE DOLLAR 1.7100 1.7059
SOUTH AFRICA RAND 6.3200 6.3750
How can I get rid of the extra line in between using vb script in DTS package. I know there is an extra line feed at end of each line.
Thanks a lot.