on 05-17-2010 12:04 PM
Hi SAP Guru's
could you please write the code for me according to the requirement below.
I am struggling in regards to that.
I have write the code which only works for 1 "/" but not working for "//" , so can anybody please write the code for me ASAP.
Thanks,
From right hand side of the field E1IDKU3-INSTEXT1, all characters upto reaching of special character "/". This is because the filed may appear like "/ /MAIL" or simply "/ /". In the first case it is expected to take data MAIL and in second case blank.
solve myself
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Iqbal,
Don't worry about writing a UDF for something which you can easily do with provided functions.
You can do it using two of them;
1) Indexof
2) substring
So do something like this:
a) Use 'indexof' to find the first indexof '/'
b) then use 'substring' from (1, indexof value) and you are done
regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Iqbal,
I am still waiting; not sure if you are there anymore or not.
However even if you did it in a UDF you will still be using substring and index operations. But your requirement is slightly unclear to me on this condition;
/abc/def/ghi
you just want 'ghi' as output? what about the first two? (abc & def?)
In other words what you telling is take the whole string search for last occurance of '/' and take the value from there till the end of the string ?
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.