Putting all the data that occurs before a BRACKET into a STRING?

[ftpdoo]

Hi,

I've got a text box called "txtSQLTemplate" while contains an SQL Statement. What I want to do is to extract all the data the occurs before the first opening bracket.

txtSQLTemplate contains:
INSERT INTO myTable VALUES ( WorkOrder, Bla, bla, bla )

So I want a string to contain everything up to the first bracket: "INSERT INTO myTable VALUES ("

Thankx,
Jonathan

 

[nickjar2]

Jonathan,

How about

dim iPos as integer
sim sSQL as string

sSQL = "INSERT INTO myTable VALUES ( WorkOrder, Bla, bla, bla )"

ipos = InStr(1, sSQL, "(&quot

sSQL = left$(sSQL,ipos)

That should do it.

Nick

 

[JohnYingling]

Subtract 1 from Ipos and what do you do if no "(" i.e. iPos = 0?

ipos = InStr(1, sSQL, "(")
if ipos > 0 then
   sSQL = left$(sSQL,ipos-1)
End if

http://www.VBCompare.com

http://www.VBSortGen.com