The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Reload this Page A Doozy of a problem for me
.
google unix.com

Forums Register Forum RulesLinksAlbums FAQ Members List Calendar Search Today's Posts Mark Forums Read



Thread: A Doozy of a problem for me
View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->
  #4 (permalink)  
Old 02-06-2007
aigles's Avatar
aigles aigles is offline Forum Advisor  
Registered User
  
 

Join Date: Apr 2004
Location: Bordeaux, France
Posts: 1,429
You can format the report with sed :

Code:
sed 's/ *,/ ,/g' report

Another way is to modify your Sql query:

Code:
select RTRIM(column1b) || ' ,' || RTRIM(column2b)
from tableb;


Jean-Pierre.