on 11-25-2015 9:07 AM
Hi,
I have a requirement to convert a plain file to XML of structure
File Received is in format
ABCDEF,123456,ZYS123
I need the values to be mapped into BPNumber
I have used Content Conversion as below.
Though I have specified endSeparator as ',' only the first value is picked, rest of the values from the file are not picked.
Can some one guide if endSeparator ',' is acheivable or any other ways of handling it?
--
Sendhil
Hi,
I have used UDF to achieve the requirement. I have got the whole line in single field and split in mapping using UDF
String[] arg = a[0].split("/");
for(int j=0; j<arg.length; j++)
{
result.addValue(arg[j]);
}
Closing this thread.
--
Sendhil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I've never used Advantco's SFTP adapter but did you try just using a single comma , without the enclosing single quotes?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.