+8
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
Best answer by dsj
View original
+20
Hi
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
+1
Hi Pamith
Just try as below. I also haven’t tried earlier.
+8
Hi
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!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
