DosTips.com

Hi,

Thanks for the response. How about if I change my delimiter to |(Pipe) instead of ,(comma).

Will that make our life easier.

thanks
Satish

That's right, we don't want to remove the comma's in between the text, Wanted to just remove leading and trailing spaces in between the data columns.

Not to remove text in between text's

Hi, Need help to replace leading and trailing spaces on to the csv file spooled out of Oracle Sqlplus. Unable to do it. Below is the sample data ASSET ,PARENT ,SERIAL ,ASSET ,LOCATION ,DESCRIPTION ,VENDOR ,FAILUREC,MANUFACTURER,PURCHASEPRICE,REPLACECOST,INSTALLDATE ,WARRANTYEXPDATE , TOTALCOST, YTDC...