Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

split string and replace token

CrusoeJul 1 2009 — edited Jul 1 2009
Dear all,

I have a field called "FreeText" which contains data which is more or less in the following format.

"1NEWTON/ISAACSIR NO DAIRY PRODUCTS AND NO PEANUTS PREFERS A FRUIT ONLY DIET"

it contains the name of a person followed by some text. I would like to tokenise this using space as separator and then separate the first token from the rest of it. The expected output would be two columns containing.

"1NEWTON/ISAACSIR" and the second column
"NO DAIRY PRODUCTS AND NO PEANUTS PREFERS A FRUIT ONLY DIET"

Thanks and regards

Crusoe
This post has been answered by 706055 on Jul 1 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 29 2009
Added on Jul 1 2009
6 comments
1,172 views