This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes A function that parses a string Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "A function that parses a string" Watch "A function that parses a string" New topic
Author

A function that parses a string

Vladan Radovanovic
Ranch Hand

Joined: Mar 20, 2000
Posts: 216
Hello everyone, this question maybe more appropriate in Oracle forum but I guess more people visit this forum so I will get more exposure here. I need a pl/sql function that will parse an input string separated by a certain character and returns tokens one by one.
Is anyone aware where can I find this on the web or I should sit down and write it myself?
Thanks,
Vladan
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17250
    
    6

I don't knwo how to explain it right, so I will just tell you what to search for. And you can only do this in Oracle 9i
They have a new feature called external tables. This allows text files to act as an Oracle Table. The external table code looks very much like an SQL Loader control file.
search for external tables here.
Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
Ali Hassaan
Ranch Hand

Joined: May 16, 2001
Posts: 103
use following function when u know the index from where u have to find substring.
substr(vcustomer_fname,initial_index,final_index)
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: A function that parses a string