Text manipulation

User50676

I have the following word after some concatenation:

HYDROCHLOROTHIAZIDE|NIFEDIPINE These are two words HYDROCHLOROTHIAZIDE and NIFEDIPINE with a "|" symbol in between. Can this be manipulated to read HYDROCHLOROTHIAZIDE and NIFEDIPINE, i.e. putting spaces and replacing "|" with "and"? Thank you in advance.

IngoRM

Hi,

Sure, you can use the operator Replace for that (or do this in Turbo Prep quite easily in Transform --> Replace). I have attached a small example process below. Keep in mind though that the operator uses regular expressions and the symbol "|" has a special meaning. You therefore need to quote the pipe symbol with a backslash like this "\|" and simply use " and " as the replacement value. Just see the process and you will see what I mean...

Hope this helps,
Ingo

< ?xml version = " 1.0 " encoding = " utf - 8 " ?> <过程版本sion="9.3.000-SNAPSHOT">
  
    
    

    
  
  
    
    
    
    
    
    
    
      
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
      
      
        
        
        
        
        
        
        
        
        
        
        
        
        
        
      
      
      
      
      
      
    
  

User50676

Many thanks Ingo, most appreciated.

Regards.

Chris