Delete spaces from a variable

[adamos100]

Hello,

I need to delete the spaces from a variable e.g.
?Special Care Assistant? needs to be saved as ?SpecialCareAssistant?. Can?t seem to get this to work after messing around with BIFs.

Any ideas?

[jamief]

Re: Delete spaces from a variable

look at the last example on this post the first parm of %replace = " ' ' "
this cause the replace to remove

http://www.code400.com/forum/showthread.php?t=1820&highlight=%25replace

 d fnd             s              3  0                                 
 d string          s             30    inz('Special Care Assistant')   
  *                                                                    
  *                                                                    
  /free                                                                
                                                                       
        dou fnd = %len(string);                                        
        fnd = %scan(' ' : string:fnd+1);                               
        STRING = %replace('' : string:fnd:1);                          
        enddo;                                                         
        dsply string ' ' ;                                             
                                                                       
       *inlr = *on;                                                    
                                                                       
  /end-free

jamie

[adamos100]

Re: Delete spaces from a variable

Works like a charm. Seems so easy now!
Thanks!

[B.Hauser]

Re: Delete spaces from a variable

Hi,

the SQL scalar function REPLACE is much more powerfull, because it replaces ALL occurrences, instead of only the first one.

To remove all *Blanks the following SQL-Statement can be used

Exec SQL  Set :NewString = REPLACE(TRIM(:OldString), ' ', ''); 

Birgitta

[jamief]

Re: Delete spaces from a variable

Thank Birgitta.....once again you come thru!

Take care and give a good-o-kick to Kit if you run into him again.