getting one textline from a field

Results 1 to 2 of 2

Thread: getting one textline from a field

  1. #1
    Mariam Guest

    Default getting one textline from a field

    I have a text field in a database, and I need to display the first line (or x lines) of that field (although they might not contain carriage returns). Is there something like getline or readline to get the lines I want after I get the content of the field from the database? Please I need an answer even if it applies only if there are carriage returns. Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: getting one textline from a field

    If you don&#039t have carriage returns, then by definition your text data is one line. If you have carriage returns, you could just take the line up until the Chr(13)&chr(10) characters that make up the carriage return.<BR><BR>If you are doing something like just getting the first line or two from a paragraph (to give a summary of the content for example) then one method would be to take the first (say) 50 characters {left(myText,50)} then continue along the line until you reach the next end of sentence character such as .?! etc.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts