Skip to Content
avatar image
Former Member

idoc to file

Hi,

i am working in Idoc to file....

for certain filed they mentioned the mapping rule as 'Do not Map' ...

For DO NOT MAP fields >>> If AlphaNum - blank fill

If Numeric - zero fill

For All AlphaNum fields >>> Left Justify

what it menans ...how can i achieve this....

thanks.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 14, 2009 at 10:20 PM

    FLW,

    For DO NOT MAP fields >>> If AlphaNum - blank fill

    If Numeric - zero fill

    Write a UDF which will check whether the incoming value is Numeric or Alphanumeric.

    If Numeric, then pass a constant "0" to the target,

    Else if AlphaNumeric, then pass a "blank" value.

    This is pretty straight forward, a simple UDF will be good enough to achieve this.

    Regards,

    Neetesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 15, 2009 at 03:43 AM

    Check these two recent threads....same requirement is discussed here....you need to implement a UDF for this purpose (UDF logic present in the thread)

    how-to-check-whether-incoming-field-is-alpha-or-nu

    how-to-check-incoming-field-value-is-complete-alph

    Regards,

    Abhishek.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 15, 2009 at 06:14 AM
    Below is the UDF created to check whether the incoming value is Numeric or Alphanumeric.
    If Numeric, then pass a constant "0" to the target,
    Else if AlphaNumeric, then pass a "blank" value
    

    UDF with one argument input.

       //write your code here
     try{ 
           Integer.parseInt(input); 
        }
    
     catch(NumberFormatException nfe) {    
        return ""; 
       }   
     return"0";
    

    Do the mapping as below

     DO NOT MAP fields------>UDF----->TargetField
    

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 15, 2009 at 06:27 PM

    thx

    Add comment
    10|10000 characters needed characters exceeded