 |
 |
Archives of the TeradataForum
Message Posted: Sun, 19 May 2013 @ 11:46:31 GMT
| 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.
| |
