Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sun, 19 May 2013 @ 11:46:31 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Iterate INDEX function
From:   howard.bradley

Could you answer the following:

1) what do you expect the final result set to look like, do you want to know the position of all spaces, the next space etc. Based on your example 'YX84 JHJHJ HJH ' do you want to know 5, 11, 12, 16, 17 or something else?

2) what is your actual requirement, what are you going to do with the information once you have it ? Are you going to trim all the spaces, return the string after the second space etc ?

3) What is the maximum length of your string, there are differing solutions depending on what exactly you want and how many characters are involved.

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