idoc to file

[Former Member]

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.

[Former Member · Accepted solution]

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

[Former Member]

thx

[Former Member]

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

[former_member200962]

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)

Regards,

Abhishek.