Loading SAP Negative values via TI

[digger1914]

We are just moving to a SAP payroll system, and it produces negative values with the sign at the end, ie 2.365- instead of -2.365.

Does anyone have any brilliant idead for loading this via TI? I currently get a warning telling me that it cannot the value to a real number.

Thanks

[Alan Kirk]

We are just moving to a SAP payroll system, and it produces negative values with the sign at the end, ie 2.365- instead of -2.365.

Does anyone have any brilliant idead for loading this via TI? I currently get a warning telling me that it cannot the value to a real number.

Best option is to get the SAP DBA / Guru to fix the export format. Failing that there's always something like this. (The real variable is of course defined as String on the variables tab):

Code: Select all

# Let's pretend that...
s_StringVariable = '3.25-';

# Check whether the last character is a - sign...
If ( Subst ( s_StringVariable, Long ( s_StringVariable), 1 ) @= '-');
    dbl_Multiplier = -1;
    s_StringVariable = Subst ( s_StringVariable, 1, Long ( s_StringVariable) -1 );
Else; 
    dbl_Multiplier = 1;
EndIf;

dbl_NumericVariable = StringToNumber ( s_StringVariable ) * dbl_Multiplier;

[digger1914]

Thanks Alan for the prompt reply,

I had exactly the same thought a minute after posting. I went with


## Look for negative value entitlements with trailing sign

IF(SUBST(LSL_Hours_Ent,LONG(LSL_Hours_Ent),1) @= '-');
LSL_Hours_Ent_Calc = '-'|SUBST(LSL_Hours_Ent,1,LONG(LSL_Hours_Ent)-1);
LSL_Hours_Ent_Load = StringToNumber(LSL_Hours_Ent_Calc);
ELSE;
LSL_Hours_Ent_Load = StringToNumber(LSL_Hours_Ent);
ENDIF;