Click to See Complete Forum and Search --> : Urgent please...


December 20th, 1999, 11:42 AM
Hello,
I have faced a problem while 'Reading from File' in VB application.
I want to read data which is not in enclosed in " ".
For example,if I have SQL statement like
select
PRO.ERFNAME "Objekte_Erfassername",
PRO.ERFDATE "Objekte_Erfassungsdatum"
from PRO where PRO.delflag=FALSE

I want to read data only which is not in Quotes i.e.,
(In the example given above I want to read like
select PRO.ERFNAME,PRO.ERFDATE from PRO where PRO.delflag=FALSE)

I want to Delimit " " in the example given above.
Please give me the solution to solve this.
regards,

Weasel
February 9th, 2000, 07:55 AM
Line Input #1, foo$
For i = Len(foo$) To 1 Step -1
If Mid$(foo$, i, 1) = """" Then Where = i
Next i
buffer$ = Left$(foo$, i - 1)

bufer$ should contain everything on the line before the 1st "