CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Guest

    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,


  2. #2
    Join Date
    Feb 2000
    Location
    South Carolina, US
    Posts
    36

    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
  •  





Click Here to Expand Forum to Full Width

Featured