Hi Ksharp, Thanks for the reply. But when i used your code.Remaining spaces in the other columns are also getting compressed without space. For ex: "Alfred Nick"|" "|"14"|"69"|"112.5" - original line after Compress with space "AlfredNick"|""|"14"|"69"|"112.5" - Here Alfred Nick became AlfredNick(Space is compressed) But I want as follow: "Alfred Nick"|""|"14"|"69"|"112.5" - Only " " is stripped to "". Please can you help me. Many Thanks.
... View more