Solved

Assign a particular line of text in a multi line text box to a string variable

Posted on 2002-04-04
5
147 Views
Last Modified: 2010-05-18
How can I assign a particular line of text in a multi line text box to a string variable?

Say for example the text box Text1 contains these text:

This is the first line
This is the second line
This is the third line

I would like to assign the text on the third line (i.e."This is the third line") to a variable

It is best that the function does not utilise vbCrLf or carriage return.

Hopefully the function can have the form :
Getline( Text1.Text,2) where Text1.Text is the text inside the textbox and 2 is the content of line 2 i.e. "This is the second line".

So to extract the second line to a variable, the code will be something like:

Variable1=Getline(Text1.Text,2)

Thanks a million for the help!
0
Comment
Question by:kkclub23
5 Comments
 
LVL 1

Expert Comment

by:falconew
ID: 6920204
kkclub23,
Why not to check the VBCRLF? I think it is the only way to getting the line you want.
0
 
LVL 43

Expert Comment

by:TimCottee
ID: 6920282
http://www.vb-world.net/php-bin/printfriendly.php?articlepageid=74

Is an API solution that shows you how to achieve this.
0
 
LVL 43

Expert Comment

by:TimCottee
ID: 6920284
You will also need to include the api declaration for sendmessage:

Private Declare Function SendMessage Lib "user32" Alias "SendMessageA" (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, lParam As Any) As Long
Private Const EM_GETLINE = &HC4
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 6921548
Please maintain your open questions:

Questions Asked 11
Last 10 Grades Given A A A A B  
Question Grading Record 5 Answers Graded / 5 Answers Received

Thanks,
Anthony
0
 
LVL 4

Accepted Solution

by:
RichW earned 50 total points
ID: 6922395
'Declarations
Public Const EM_EMPTYUNDOBUFFER = 205
Public Const EM_CANUNDO = 198
Public Const EM_GETMODIFY = 184
Public Const EM_SETMODIFY = 185
Public Const EM_UNDO = 199

Public Const EM_CANPASTE = 1074
Public Const EM_FINDTEXT = 1080

Public Const EM_GETFIRSTVISIBLELINE = 206
Public Const EM_GETLINECOUNT = 186
Public Const EM_GETLINE = 196
Public Const EM_LINEFROMCHAR = 201
Public Const EM_LINEINDEX = 187
Public Const EM_LINELENGTH = 193

Public Const EM_EXLINEFROMCHAR = 1078
Public Const EM_LINESCROLL = 182
Public Const EM_SCROLLCARET = 183
Public Const EM_SETTABSTOPS = 203


Declare Function SendMessage Lib "user32" Alias "SendMessageA" (ByVal hWnd As Long, ByVal wMsg As Long, ByVal wParam As Integer, ByVal lparam As Long) As Long
   
'Code
Dim sFileName As String
Dim Lines
Dim WinH As Long
Dim i As Integer
Dim LineLength As Long
Dim charOffset As Long
 
'Get the windows handle of the multiline text box
 WinH = txtFileName.hWnd
   
   'Get the number of lines in the mutiline text box called txtFileName
    Lines = SendMessage(WinH, EM_GETLINECOUNT, 0, 0)
         
    For i = 0 To Lines - 1
 
       'Retrieve the offset of first character in the line
        charOffset = SendMessage(WinH, EM_LINEINDEX, i, 0)
       'Now get the length of the line
        LineLength = SendMessage(WinH, EM_LINELENGTH, charOffset, 0)
       'Debug.Print LineLength
        sFileName = Mid$(txtFileName.Text, charOffset + 1, LineLength)
        Debug.Print sFileName
             
    Next i

0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

943 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

4 Experts available now in Live!

Get 1:1 Help Now