VS 2010 .CSV Delimiter Settings?
May 6, 2010I have a Java-based csv file that uses the format:
"data","data","data, data","data",
"data","data","data, data","data",
"data","data","data, data","data",
[code].....
I have a Java-based csv file that uses the format:
"data","data","data, data","data",
"data","data","data, data","data",
"data","data","data, data","data",
[code].....
1. I can't find the file which reflects changes to user settings. This might be because I just can't find it (I can see a bunch of user.config files but they are all empty - weird!), or...
2. I'm not actually saving them when I think I am.
Regarding 2. - do I need to invoke
Is this all I need? And if so, why are my user.configs empty?
I'm working with an Treeview and i'm new at it and i have 2 questions.
1. How can i save the treeview items, to settings (my.settings.history)
2. How can i save the treeview items as an TXT or XML file or another exception.
Small questions about the settings.settings. Are these settings saved into the registry? I'm want to use and external file for my connection-commands. I don't want to use the registry to store the strings. What do you recommend?
View 11 RepliesI have the following problem in VB.net. I have a string like Dim str as String = "ABCDEFGHIJKLMNOPQRSTUVWX" now i want to add a delimiter from any one of them (Comma, Hyphen, Slash, Tab) into the string at the specified position like after every One, Two and so on characters. i WANT THE RESULTANT STRING LIKE
[Code]....
I am working on finishing up a mvc 3 vb.net app... I have to parse about 2000 entries in a database and get the string value to the right of a " : " delimiter from one of the columns... Everything to the left I am not worried about but I need the value that is to the right of the colon for that item.. I have more issues involving needing to select string characters to the right or left of a delimiter... But if someone can show me how to achieve the above I can figure out the rest from there...
a example of the string is Jackson Smokehouse Fish Food:John Jacob JinggleHimer Schmit I would want to eliminate the first part of the string or just select the second part and put it in a variable for later processing...
I'm working with VB.Net. I have imported some data into the Data Set.I have four columns of data.
[Column 1]This is a test[/Column 1]
[Column 2]This is a comma, Test.[/Column 2]
[Column 3]This is a double quote " test.[/Column 3]
[code].....
I've been working on this program all week and I've been able to finally get it to work except for one problem. The program is suppose to parse strings from a text box to a list box and then from a list box to a text box using the users choice of delimiters. I can't seem to figure out how to get the last comma off the end of the list. ie cat,dog,elf,It seems it should be easy, but since I've worked on this program so long I believe I can't see the forest for the trees. I don't want for you to do my work for me.
[Code]...
I want to split a string at a delimiter, but I don't want to discard the delimiter; It needs to become its own variable. [code] Is there any way of achieving this short of writing my own method?
View 3 RepliesI have word : "Banana". And i want it to split into :
B
a
n
[code].....
this is my code -
With ad.Tables(2)
For i As Integer = 0 To .Rows.Count - 1
If .Rows(i)("name") & "" <> "" Then
temp &= .Rows(i)("name") & ", "
[Code]...
I am developing an appilcation which requires a text box with auto-complete/suggestions (drop down) for multiple words (seperated by a delimiter like space) like the tags text box here in SOF. E.g. I start typing 'app' it should show all words in the suggestions list starting with app, and when I enter a word and press space and start typing a new word it should show all suggestions for that part-word.
View 1 Replieslets say I have a string that I want to split based on several characters, like ".", "!", and "?". How do I figure out which one of those characters split my string so I can add that same character back on to the end of the split segments in question?
Dim linePunctuation as Integer = 0
Dim myString As String = "some text. with punctuation! in it?"
For i = 1 To Len(myString)
[Code].....
I'm trying to use VB.NET to parse a very large plain text file (2 GB). It is a database and has a field delimiter of SOH and a record delimiter of STX. I want to separate the fields and records of the file.
I would normally read each line of a text file and then use the split function to separate out the fields. I can't use this approach as there isn't always a delimiter on every line.
Is there any way to read a file until STX is found (rather than one line at a time)?
I have an string that is returned from an xml file and looks similar to this name1="test 1" name2="test2" name3="test 3".I want to split this into 3 elements of key=value. I can't just split using a space because some of my values may contain spaces, e.g., test 1.So, I'd like to split the string using the " before the space. I've tried many variations but can't figure out the correct syntax to specify that my split characters are a " followed by a space. For instance, I've tried text.split({""" "}) but that returns elements split by " and ignores the space after the ".It shouldn't be this difficult. Can someone please help me with the correct syntax?
View 2 RepliesThe Data looks like this:
Quote:
057359-001 Pip Drt329 Auburndale, Fl (aub) - Pompano Beach, Fl (pob) 1:0 10gbe Lan Phy.
MyArr(0) ends up "057359-001" which is correct.
MyArr(1) ends up "Pip" only which is incorrect.
[Code]....
When the user clicks any item in the listbox ie lviproducts it passes that item to a textbox. The problem is that I want everything before the $ sign not to appear so only the amount ie 4.50 etc would appear in the textbox. So far I have no idea how to do this, but have the following code which is not working at all.
[Code]...
I have a string builder that has a structre like[code]...
View 6 RepliesWhat would be the simplest way to find the n-th position of delimiter in a string.For example, say, I have a string variable called FullFilePath that contains the path of a file, like, C:SourceFiles<mthyr><subject><filename>.txt From this, I would like to extract out mthyr, subject, and filename, using the delimiter, "".
I was hoping string.IndexOf would let me find the n-th position of the delimiter "", in which case I can use the result to do a string.Substring. But it looks like IndexOf only finds the first occurence of a certain string, which means I would have to interate this somehow to look for the n-th occurence.
Or is there another method that will help me do this more efficiently.
I am wanting to write an application which opens a delimited text file (either comma, pipe, colon, semi colon) and displays the file on the form. The same feature is in Excel when you import a data file. After selecting the file it shows the contents and you can choose the delimiter. Once the delimiter is chosen the data shown reflects this and updates to show the correctly formatted data.
View 5 RepliesAlright, im trying to load a text file into a list box using a delimiter(sp?)I have 2 list box's lstFirstName and LstLastName I have the code to load it into a list box
r = New IO.StreamReader("c:\test.txt")
While (r.Peek() > -1)
lstFirstName.Items.Add(r.ReadLine)
End While
r.Close()
And at the moment this will just load the whole list box, how can I use a delimiter to split it up?So John Doe in the text pad will show up as lstFirstName: John lstLastName: Doe Sorry if im not all that clear, if you dont understand I will try to explain it clearer.
How should I split a string separated by a multi-character delimiter in VB?
i.e. If my string is say - Elephant##Monkey, How do I split it with "##" ?
I have a multiline textbox which I need to split into an array using new line as a delimiter, I've tried what I think should work but it doesn't:
HTML
Dim strArr() As String
strArr = TextBox2.Text.Split(Environment.NewLine)
I need to take the items in a listBox and post it in a textBox with a delimiter. I worked some code but it does not work correctly. I think my array is wrong but i am lost.
[Code]...
eally been struggling with this one, and i cant seem to find a simple method of doing it...surely there must be one? I have a list of values that i am loading into a variable. I am trying to split that variable by the whitespace that separates each value...the only thing is the whitespace varies in size. eg.
View 3 RepliesHow do I rearrange the Settings in VB.Net 2010 to be near the ones they are related to?I edited the app.config file to rearrange them, but when VB loaded again they were still shown in the old order.
View 4 RepliesI've read through multiple tutorials, set up my settings, and have entered said code but the program still will not retrieve what supposedly saved.
vb.net
Public Class Form2
Public ReadOnly Property MarkUp() As Integer
[Code]......
I have 2 settings in my application, username and password.
When a user types in a username and password in my text fields i wanted it to save these values to the application settings that i set.
Now it does this fine while the application is up. If i close the app, and reopen it, the application settings are removed, and back to default.
VB 2010 Express, Windows 7 The settings on the main form save properly. My problem is that I have a usercontrol that is changed to a tabpage that I use to 'clone' tabs. Is there a way to save the cloned tabs along with there settings?
Multiple people use the program and the number of tabs and settings are different for each person.
Are My.Settings values saved in the program itself or do they get stored in the registry? o, for example, if I set a My.Settings value with a program, then I copy the program itself to another PC - is the My.Settings value still set?
View 3 Replies