I have a csv file from which i am getting the data into a table. Example: "ABC",1,"Apple" The requirement is that the strings will be inside the quotas " " and integer will be without quotes. The above line will split into three columns. i am using stream reader class to split the line into columns using line.split(','). It was working fine unfortunately i got a record in a file where there is a comma in between the string quotes like these "ABC,DEF,ghi",2,"Orange". So instead of 3 columns now they are acting as five columns and all the conversion are failing. writing the script in C# which will replace the comma between the quotas into semicolon and don't touch the comma in between the columns.
I have written a VBA (Excel macro) to open a workbook, and save it as a semicolon .CSV file, and then close it self. Excel on the server at work has a nasty tendency to start in safe mode (or at least ask if it should start in safe mode), making my Open-And-Shut macro fail. Now I've rewritten the program into VB.NET code (vs2008), but it creates a true .CSV (comma separated value), and I need semicolon. The excel file contains "last name, first name" making comma separation useless. Also making it impossible to substitute "," with ";" [Code]
I use the following code to add a record but get the error:"Missing semicolon ( at end of SQL statement. " I removed the semicolon, placed it before the SELECT but it seems to continuously cause problems.
Quote:
Public Sub AddAccountRecord(ByVal name As String, ByVal type As String, ByVal user As String, ByVal balance As String) Dim strSQL As String Dim objConnection As New OleDbConnection(strConnection) Dim objCommand As New OleDbCommand(strSQL, objConnection)
What I am trying to do is allow the user to enter a list of authors in a textbox separated by semi colons. After each author is entered, followed by a semicolon, I would like the autocomplete to work on the next name and so on (e.g., Smith, John; Eastwood, Clint...). I can get the autocomplete to work in a textbox with one name, but cannot seem to figure out how to get it to work on a list of names in a text box.
I have ran into an issue where I need to save some Excel data to a semicolon delimited file. (Why is an issue unto itself) And I can not find a way to do this using VB. In excel I can use Import Semicolon delimited files but I can not find a way to save them. Is there a VB constant or method I can use to save semicolon delimited files without having to write my own save procedure to format the data? such as the xlCSV, xlDIF, xlTextMSDos formats. I would think that since it can import this format that it should be able to save it.
I'm trying to make the autocomplete work on a list of items entered into a textbox separated by semicolons. I have a list of authors the user can choose from and it autocompletes as they type the name no problem, but what I'd like to do is after the user types a name followed by a semicolon, the autocomplete works on the next name and so on.e.g., Smith, John; Eastwood, Clint?
If checkboxList.Items(i).Selected Then .Fields("DESC1").Value += checkboxList.Items(i).Text + ", " End If
should produce output such as "A, B, C,(space)", which will then be bound to a dynamically created GridView. I would like to remove the last two-char string, that is ",(space)". How can I do this?
i have the folowing problem: i made a combobox on my form and in order to add items to it i use a normal textbox and a string in application settings, the textbox add's the item in both the combobox( with this code ComboBox1.Items.Add(TextBox1.Text) ) and the string in application settings with the folowing code:
I have a string which contains words with parentheses. I need to remove the whole word from the string. For example: for the input, "car wheels_(four) klaxon" the result should be, "car klaxon".
How can you remove number from a sting. The numbers could be anywhere in the sting and they could be any combination of numbers but would be together in the string. Ie abcdefg321hijk....
How can I remove all of the text to the right of the second to last / in a string. Before = ftp://sylenttechnologies.com/text/test/another test/ After = ftp://sylenttechnologies.com/text/test/
I have calulator while pressing the calculator buttons that corrsponding caption will display in text box ex:(12 + 2+ (text1) - sum1+[Ref1]/[ref2])
1. how to remove [i have button for remove] string upto previous oprator 2. ex now if i cliked the remove button ex :(12 + 2+ (text1) - sum1+[Ref1]/ should be like this 3. again i clicked it should be like this ex :(12 + 2+ (text1) - sum1+
This should be simple but apparently it's not. I have a text file, 694 bytes. At byte 500 there's a null in the file. I've tried reading it as text and binary and I end up with a string, 694 bytes long. But anyting I do with this string fails because it appears to stop at character 500. I can do a ? asc(mystring.substring(549,1)) and I get 9 (tab). Print character 550 and I get 0. Print character 551 and I get 32 (space). How do I get rid of this null?