PL/SQL string tokenizer

Hi all,
I should need a character function which, given a string and a
specific token, gives me back all the substrings.
Then I should load all these substring into a poplist (Forms 6i element).

So, given the string 'foo1,foo2,foo3' the poplist should contain:
foo1
foo2
foo3

I didn't find any suitable PL/SQL function to do this. Does it exist ?
If not, I have no idea of which functions I should use!


I'd appreciate any help,
Best
Irene
iz_a8_ireneAsked:
Who is Participating?
 
jaramillCommented:
Irene:

  First you have to determine what will be your delimiter (i.e. a comma, a pipe, etc...).  In your case it's a comma.  Then you write a function that takes in the string and you then look for the position of the first instance of the delimiter, then calculate the first token based on starting postion 1..to..delimiter.  Then move the pointer 1 passed the delimiter and search for the next delimiter, then calculate the second token based on starting postion delimiter+1..to..second_delimiter.  Repeat this process until you are at the end of the string.  While getting each token, you can add it to a PL/SQL array and return that array, then use it to populate a table which will then read it from a RECORDGROUP which will then populate a ListOfValues.

Gio
0
 
catchmeifuwantCommented:
what is your string and a token...give some examples of input and the output expected !!!
0
 
Helena Markováprogrammer-analystCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Accept jaramill's comment as answer.

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Henka
EE Cleanup Volunteer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.