on 12-08-2011 7:07 AM
Hi Experts,
i am trying out a simple mail to file Scenario. But i am facing some issue. Pls help me to solve the issue.
My Source structure is
<Subject>subject pi</Subject>
<From><ABCD></From>
<To><XYZ></To>
<Content_Type>text/plain; charset="ISO-8859-1"</Content_Type>
<Date>2011-12-08T05:56:13Z</Date>
<Message_ID><CAABb8cU+oXFPYHc-DUaaoQfd_seEMToE=UbqZ-CLOfUw9ei8uQ></Message_ID>
<Content>content pi</Content>
This we have reed the Subject and the content of the mail. When we note the From ID we can see that the mail id is generated inside a tag i.e <ABCD> how can we avoid the tag symbol. here in Forum i am not able give a mail address so thats y i didnt mention the From and to id fully.
Regard's
Preethi.
Hi,
You can remove the tags in mapping using UDF...try this
From>UDF>target
UDF:
int start = input.indexOf('<')') ;
int end = input.lastIndexOf('>');
String result = input.subString(start+1, end-1);
return result;
Regards,
Priyanka
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 | |
9 | |
9 | |
6 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.