Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sat, 13 Mar 2004 @ 09:42:51 GMT

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

Subj:   Re: Manipulate string spaces
From:   ulrich arndt


I didn't send too much time on this but my first guess is that the trim causes the problem as this will remove the second bank prior to the further evaluation as it is the first char after the substr.

      index (Str_Address,' ') as Index_1,
      (character_length (str_address) - index_1) as rem_add_1,
      index (trim(substr(Str_Address, index_1+1)), ' ') + Index_1 As Index_2,


  <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