Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Splitting a field with comma separated values in OIC — Cloud Customer Connect
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

Splitting a field with comma separated values in OIC

Received Response
30
Views
7
Comments
edited Jun 24, 2021 7:19AM in Integration 7 comments

Summary

Splitting a field with comma separated values in OIC

Content

Hi All,

I have the below problem. I have a field as below which I read from a table

Entity_List : "A", "B", "C", "D"....and so on.

The no. of entities is not constant. It can be 1 to N

I need to a set of processing for each entity. So, I have to first read each of the entities separately from this single field. Get the count and for each of them I have to run a set of steps.

Any ideas on how we can split this field? Main issue is the no. of entities can change in each run and we have to determine in dynamically.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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