on 02-02-2007 1:04 AM
Hi Experts...
I am trying map werks field to another field of the same type .
However we are suppose to map the last two characters of source work field.
The source incoming data for werk can have 2 ,3 or 4 characters.
I have tried various combinations of if ....if without else ...length ...text functions
but they are not working.
can somebody tell me how to go about it using standard functions available .
Regards,
deepak
Hi Deepak -
Much easier with a very simple User Defined function (UDF). Just create a simple UDF with one input parameter (call it 'a' which is default) and just put in the following and save:
<i>return a.substring(a.length() - 2, a.length());</i>
Regards,
Jin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Deepak,
If source file doesn't have fixed lenght , we may not use standard functions in this case.
you can do it with Creating Java or Abap simple New functions in mapping it self.
regards,
ramesh..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
check my reply in ur other posting
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
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.