When you are putting in a long string of code it doesn't all fit, so I want to know if there is a way to continue that string on the next line. I believe it's something like & _ if I'm correct in thinking. But I'm not perfectly sure, I guess the question I'm asking is if you can continue a string with & _ or if it is something else.
View 6 RepliesThis is a easy one (i think) I am using MS access 2003 and. I am having problems continuing SQL statments to another line. I have been trying &_ and that doesnt seem to work with my SQL statements. How do I do this. I have some long SQL statments and it would be easier to break to another line, but I can't seem to do this. The statment below gives an error.
sqlz = "SELECT [Crosstab AUS].* INTO [AUS REQ] &_
FROM [Crosstab AUS]"
How do you continue a select statement on additional line in vb
View 3 RepliesI have this do while loop that I am having trouble with. I need to know how to make the loop continue to the next line after it has looped around once. So far I have it outputting like this.
$*$*$*$*$*$*$*$*
But what I really need it to do is output like this
$*$*$*$*$*$*$*$*
*$*$*$*$*$*$*$*$
$*$*$*$*$*$*$*$*
*$*$*$*$*$*$*$*$
$*$*$*$*$*$*$*$*
*$*$*$*$*$*$*$*$
$*$*$*$*$*$*$*$*
*$*$*$*$*$*$*$*$
I'm writing a command-line application in .Net. The app itself is fairly simple, but it has to connect synchronously to a web-service, which in turn has to connect to a Oracle database, and those pieces are fond of taking their time.
Is there a straightforward way (without dividing my app exe in two) to continue executing but nonetheless yield execution to the command prompt?
It's Windows, so no "&". Also, I cannot use cmd.exe's "start" cmdlet.
If i have a line in a txt document "text.txt".Now what i want to do is open the file and read the contents.
When it find this "search.selectedEngine" term then it should delete that particular line and replace it with another string ("REPLACED STRING").
I'm having trouble with reading a .txt file line by line, converting it into a string, then putting it into a listbox. When I execute I get an error saying "IndexOutOfRangeException was unhandled" Here is my
[Code]...
Ok, So I have a string that has its formats like this:
Line 1
Line 2
Line 3
[code].....
I like search a file TXT with this contains:
Name "Paul"
Age "11"
City "Chicago"
my question is: Its possible get a string "Name" and give me the value "Paul"? I have this function for get strings:
[code]...
I need to read a xls/xlsx/ods/txt file line by line,to get a column name of file .how to read a file line by line in vb.net?
View 1 RepliesI have a string that contains many lines.It is someething like:
I
want
to
be
a
millionaire.
I need to read this string line by line, that is to assign line 1 of the string to a certain variable, line 2 to another, and so on.Do you know how that can be done?
Input file
Type Reference
WIN 00001
WIN 00001
WIN 00001
MAC 00001
MAC 00001
Basically I need to compare if the first 3 character that are not equal
preferred output will be
Type Reference
WIN 00001
WIN 00001
WIN 00001
[Code].....
I have googled this but all it comes up with is some C# and how to read a file line by line which is not what I want, what do you have to use to do this I tried this loop:
for each line in str
msgbox (line)
next
but it does not work, how do I get this to work?
For example I have a strint containing text with more than 1 line. For example:
"Hello How Are You"
I want to read a specific line of the string, if I choose to read line 1 of the string in a messagebox then the word "How" will probably pop up.
I have a textbox and i need to get text of every lines without newline
View 15 RepliesHow to get a line number that contains a specified string in a text file?
Example text file contains:
Red
White
Yellow
Green
How to get "Yellow" line number? and can i write a string in a specified line, lets say i want to write a string in line 2?
I'm an inexperienced programmer,I want to count the number of line's in a string.In "hulp" are several line's, all ending with "vbCrlf".I have tryed If hulp.Substring(i, 1) = vbCrLf Then .... but that doesn't seem to work.
View 1 Replieswe have Form1 and in this form we have several Subs like this:
Public Sub Sub1
Dim a,b,c as integer
a=1
b=1
[code]....
I want to put into str1 and str2 as strings the lines below specifying only the line number of the form where these particular instructions are found
Example:
str1="if a+b=c then msgbox("Correct")"
str2="if a2+c2=b2 then msgbox("Incorrect")"
Any function to do this?
How to get a line number that contains a specified string in a text file?Example text file contains:d White Yellow Green
View 3 RepliesHow do I read a certain line of a string? Here is my current code:
TextBox2.Text = SuperVB.ReadFile(OpenFileDialog1.FileName)
Dim lineFirst As String = TextBox1.Text.Line(1)
MsgBox(lineFirst)
I don't want to read a file's line.
i would like to do it almost the same way like in my recent other topic, read a file and put every line of it in a listbox.
View 5 RepliesI have two a strings when i use them in msgbox() i get this
View 6 RepliesI was just wondering is there an easy way to replace a line in a string where I don't know what line it will be and I don't know what will be on that line apart from the first three characters which will always be:
To:
And that shouldnt be anywhere else in the string.
This string will be the contents of an email (read in via an EML file) I then need to change the line that says 'To: <someones@email.address> to a series of addresses then save them eml again.
I have read then entire email in and stored it in a string and can save again just struggling on the replacement of that line.
what i need to do is open a txt file, read line by line, decode each line into an array and display. Now all works ok apart from one line.
sTextLine = objReader.ReadLine() <-- Value of string cannot be converted.
full code here
-------------
Dim objReader As New System.IO.StreamReader(sOpenFile.Text)
Dim sTextLine As New ArrayList()
Dim sText As String = ""
Dim i As Integer = 0
[code]....
I'm adding some content within a long concatenated string (it's horrible, I know).
I have to display 3 columns of data from a datatable and my code looks like this.
If Not IsNothing(MyBase.EligibilityQuestions) Then
Dim sw As System.IO.StringWriter
For Each row As DataRow In MyBase.EligibilityQuestions.Rows
[Code]....
My problem is I end up with text that overflows to a new line and doesn't line up with the text from the column it belongs, I'm writing this for a DynamicPDF so I can't insert HTML, and I'm trying to get this to look like a table (all the columns lined up).
Short of Counting characters in each line
I really need line with this I can't figure this out . I am looping through items in a list view box, I am then adding them to a string. I need each new line in the listview box to be a new line in the string. I will then add this string an access database.But I can't get it to skip a line in the string
This is the code For Each lvItem As ListViewItem In lstVParts.Items
[Code]...
If i have a string "mystring" and it holds something like
"aaaaaaaa bbbbbb fffffff qwrt afsa hghf"
how can i get each word into its own string "mynewstrings()"? the number of spaces between the words isnt always the same either.
I am trying to figure out a way to set a string equal to vb code and then run that string as a line a of vb code.
for example
set string x = "TextBox1.Text =
"test1".ToString"
[code]....
i have a simple statement of code that reads:
Return String.Format("{0} {1} {2}", _var1, _var2, _var3)
i'm trying to get this formatted string to output each var on it's own line. i'm new to vb.net but i did try one thing:
"{0}
{1}
{2}"
that didn't work.
I wana know what is the code (VB 2008) to get line that contains selected data that the user want from notepad?
[Code]...