Substring from a specific word

[Raj kalaria]

Hi


I hava a string sql

sql = select object_name, tilte, subject from dm_document where

Now if i want a susbstring say

newsql = object_name, tilte, subject

how can i acheive this

sql.substring( ) ???

pla help

[marc weber]

Sorry, but I'm not understanding what you need to do. Can you provide more detail on your critera for creating the substring?

[Raj kalaria]

yeh

see i have a string

string abc = "select object_name, tilte, subject from dm_document where"


Now i want a susbstring from abc containing "object_name, tilte, subject"
that is
newabc = "object_name, tilte, subject"

how can i achieve this

[Stan James]

StringTokenizer or String.split() will split a string on some delimiter. You could replaceAll() commas with spaces and use a space delimiter to process the words one at a time:

get a word
if first word != select"
   error, I'm confused
get a word
while word != "from"
   add word to word list
   get a word
end while

Try that and see how it works. Then we can talk about regular expressions. If you don't know them they are significantly trickier and could "capture" all the text between "select" and "from" and probably even capture one word at a time.

[Raj kalaria]

Hi james

thanks for yr input i will defi try that

but for time bieng i did as follow
--------------****************---------------------------
int pos = str.indexOf( "select");
int pos1 = str.indexOf( "from");
String str1 = str.substring(6,pos1);

---------------************--------------------

but i am not happy with the logic .

I will look to yr logic thanks a lot

Raj