Archives of the TeradataForum
Message Posted: Sun, 19 May 2013 @ 11:46:31 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|