|
-
December 20th, 1999, 12:42 PM
#1
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,
-
February 9th, 2000, 08:55 AM
#2
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 "
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|