i 've created a report in excel sheet. i used '|' pipe as delimiter.my output in excel was name|id|account|sex| raj|0345|SB|M kumar|0346| |M i am getting null for column account when there is no data availabe. Now my question is it possible to remove the space between two pipes when there is no data. i.e., || (two pipes immediately) if there is null data . i want data like kumar|0346||M thanks in advance varma
... View more