Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 17 Apr 2003 @ 16:28:31 GMT


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


Subj:   Re: Parsing the StatementText from the Accesslog
 
From:   Debbie Doran

Sorry about the formatting on the following message. Here's the my point #4 a little bit better formatted (I think!).

4. Find and replace the following (be sure to select match case):

 Find   Replace
 WHERE^w   <>
 (^w   <> Note1
 )^w   <>  Note1
 AND (BETWEEN stmts) and   Note2
 AND (all others) ^p   Note3
 OR   ^p  Note3
 ^p^w   ^p  Note4

Key: Code  Value
 ^w   (whitespace)
 ^p  paragraph mark

Note1 - for all except IN statements (I have to run this manually, not Replace All)
Note2 - have to manually replace as searching for BETWEEN
Note3 - be sure to do this after all others as it will separate each condition with a CR/LF
Note4 - cleanup of whitespaces

Debbie :-)



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023