-
Urgent please...
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,
-
Re: Urgent please...
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 "