AnsweredAssumed Answered

Gel Load of Table fails when value contains & symbol

Question asked by Lowell on Jun 22, 2009
Latest reply on Jul 10, 2009 by Lowell
The following script is meant to import new values from a particular  text output.   The issue comes in when the  output  contains an '&' symbol.   The particular record containing this symbol fails.    How do I test for this character and  modify it to a string value?      
   
   
   
   
   
   
   
           
                   
                           
                   
                   
           
           
                   
           
   
    Reading file named - ${vFile}
   
           
File name "${PLocalDirectory}/${vFile}"
                            
      delete from trg_beeline_charge_code
        
   
           
                    File ${vFile} sucessfully read into
memory.
                   
                            locate($amp;,${row[5]})                                    
                      INSERT INTO trg_beeline_charge_code BC
                    (BC.tkc, BC.project_id, BC.activity_id, BC.cost_center,
BC.account, BC.project_name
                    )
                      VALUES ('${row[0]}','${row[1]}','${row[2]}','${row[3]}','${row
[4]}','${row[5]}')
                                   
                                                
                   
                      select count(*) as num
                      from trg_beeline_charge_code
                   
                    Number of records insert into
trg_beeline_charge_code - "${vrec_count.rows[0].num}"
           
           
                   
                    Error locating or reading file - "$
{ex}"
           
   

Outcomes