Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Substring last 5 characters from a string - OIC GEN 3

in Integration 3 comments

Need to Substring last 5 characters from a string from an integration in OIC GEN 3.

I am expecting substring("r e dwood", -5, 5) will result "dwood". So I tried below formula in OIC integration, but it is resulting Null value.

substring (oraext:left-trim ($Read810File/nsmpr0:ReadResponse/ns24:InvoiceSet/ns24:Invoice/ns24:Header/ns24:SYSTAD4 ), -(5),5 )

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!