| View previous topic :: View next topic | 
	
	
		| Author | Message | 
	
		| Declan Beginner
 
 
 Joined: 04 May 2005
 Posts: 15
 Topics: 8
 
 
 | 
			
				|  Posted: Fri Oct 21, 2005 8:34 am    Post subject: Removing Trailing spaces |   |  
				| 
 |  
				| HI, 
 I have the following piece of text in a PIC X(80) field:
 
 'DECLAN LIVES IN IRELAND                                   '.
 
 I want to move this piece of text to a variable length field and remove the trailing spaces.
 I have used the INSPECT REVERSE FUNCTION command but it removes ALL spaces and I get the following:
 'DECLANLIVESINIRELAND'
 
 What I want is a field with
 'DECLAN LIVES IN IRELAND'.
 
 Can anyone help me on this? I have unsuccessfully searched other posts for an answer.
 
 Thanks!
 |  | 
	
		| Back to top |  | 
	
		|  | 
	
		| Declan Beginner
 
 
 Joined: 04 May 2005
 Posts: 15
 Topics: 8
 
 
 | 
			
				|  Posted: Fri Oct 21, 2005 8:57 am    Post subject: |   |  
				| 
 |  
				| Please note there are trailing spaces on the text that I didn't show on my first message: 
 
  	  | Code: |  	  | 'DECLAN LIVES IN IRELAND                              ' | 
 |  | 
	
		| Back to top |  | 
	
		|  | 
	
		| kolusu Site Admin
 
  
 
 Joined: 26 Nov 2002
 Posts: 12394
 Topics: 75
 Location: San Jose
 
 |  | 
	
		| Back to top |  | 
	
		|  | 
	
		|  | 
	
		|  |