Skip to main content

Hi,

 

I am trying to set a RIGHT TRIM function in an external file template (bank statement), but it doesn’t seem to work when it is set according to the template shown in the LOV. My objective is to pick the first 100 characters of the uploaded field.

I get an unpack error as below

“ExtFileFunctionHandler.VALUEERROR2: Value error on column no TRANSACTION_INFO1 function no 10”

 

 

Any idea how to set this function detail? 

This is on Apps10 Upd13


Thank you

 

Pamith

Hi @PamithK 

 

RIGHT_TRIM function removes the right-most characters defined in the set

 

If you need to pick the first 100 characters, use SUB_STRING function.

Function arguments:

COLUMN_REF(TRANSACTION_INFO1),1,100

 

Hope it helps!

Damith

 

Hi Pamith

 

Just try as below. I also haven’t tried earlier.

 

Hi @PamithK 

 

RIGHT_TRIM function removes the right-most characters defined in the set

 

If you need to pick the first 100 characters, use SUB_STRING function.

Function arguments:

COLUMN_REF(TRANSACTION_INFO1),1,100

 

Hope it helps!

Damith

 

Thank you! this worked!

Reply


Terms & ConditionsCookie settings