Skip to Content
avatar image
Former Member

Flat file mapping problem.

we were doing Flat file to IDOC.

we were getting a field of length 12 from which we need to convert take first 10 values from left to right.

we used the sub string function till now...

functional team says...they might also send 5 digits number...so in that case...i need to take the 5 digits number along with the 5 spaces...how will i do that.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 03, 2008 at 05:58 PM

    Can be done with UDF.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      You an also use If-Else-if standard function for it.

      Here is the UDF code.

      String s = // assign your UDF variable here....
      		if (s.length() ==12){
      			System.out.println(s.substring(0,10));	//replace System.out.println with return in real UDF	
      		}
      		else if (s.length() <= 5){
      			String temp = "     ";
      			System.out.println(s.concat(temp));  //replace System.out.println with return in real UDF
      		}

      Edited by: Farooq Farooqui on Sep 4, 2008 12:38 AM

  • avatar image
    Former Member
    Sep 03, 2008 at 07:14 PM

    Hi Reddy,

    Check the length of the field and use if-else accordingly.

    Regards,

    ---Satish

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 03, 2008 at 08:00 PM

    to be honest i am new....

    please tell me step by step ..

    field----ifelse-->receiver feild

    can some one show me dramatically

    Add comment
    10|10000 characters needed characters exceeded