Skip to Content
0
Former Member
Dec 27, 2007 at 07:08 AM

UDF

15 Views

Hi,

All

Iam getting a string of 600 charecters in a Filed ,In that i need to fill the 5 fileds of target data. I wrote the UDF Given below.In the mapping UDF Desigh iam getting to pass 1filed , But in the target iam not getting the UDF Split to pass 5 fields(Iam getting only on) . Could guide to pass 5 fileds.

//write your code here

String Name.

//Debit Account

String s1 = s.substring(42,52);

//Instrument Number

String s2 = s.substring(85,95);

//Check Amount

String s3 = s.substring(111,130);

//Instrument Issue Date

String s4 = s.substring(165,173);

//Customer Reference No

String s5 = s.substring(189,204);

return s1;

return s2;

return s3;

return s4;

return s5;

Regards

Kumar