on 06-23-2009 12:46 AM
Hello,
In my mapping, if my source description field size is greater than 120 characters, then i need to map target field's element 'A' with first 70 characters and element 'B' with remaining characters.
else if its less than 120, map all characters to element A.
Thanks,
Vishal
UDFs to the help...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>
> Hello,
>
> In my mapping, if my source description field size is greater than 120 characters, then i need to map target field's element 'A' with first 70 characters and element 'B' with remaining characters.
>
> else if its less than 120, map all characters to element A.
>
> Thanks,
> Vishal
use a UDF,
for element A
if(a.length() > 120)
{
return a.substring(0,70);
}
else
{return a;}
for element B
if(a.length() > 120)
{
return a.substring(70,a.length());
}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
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.