Archives of the TeradataForum

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

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

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>>