cancel
Showing results for 
Search instead for 
Did you mean: 

File Content Conversion - SFTP Advancto

sendhil_kumar
Active Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

sendhil_kumar
Active Participant
0 Kudos

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

Answers (1)

Answers (1)

engswee
Active Contributor
0 Kudos

I've never used Advantco's SFTP adapter but did you try just using a single comma , without the enclosing single quotes?

sendhil_kumar
Active Participant
0 Kudos

Hi Eng,

Yes,  I did try that but still the same.

Can we use the endseparator as comma? 

Should I go for any standard modules rather using content conversion?

--

Sendhil

Former Member
0 Kudos

Hi Sendhil,

Maintain Record 0..Unbounded and the BPNumber as 0..1. Then try.

Regards,

Suhale Shaik.

sendhil_kumar
Active Participant
0 Kudos

Nope.. Still the same.

Former Member
0 Kudos

Can you please provide the mapping screen shot.

Regards,

Suhale Shaik.