I have 2 strings one index: 4, 2, 5, 3 and second one times: 205, 153, 320, 300. I need to sort second string ascending, but to change also positions of elements for the first string and maintain position which corresponding with position for second string:For example initial i have:
index: 4 2 5 3 2 4 3 5
time: 205 153 320 300 after sorting 153 205 300 320
Is there a way to sort an array in VB that would put J10 and J11 after J9?
J1 (PN= 605848)
J10 (PN= 605987)
J11 (PN= 605987)
[code].....
This is what I get after I run myArray.sort()
Each array string represents a text file in a folder. I want the array to be sorted based on what the text file contains. How would I do that?
View 1 RepliesSay I have a List(Of Tag) with Tag being an object. One member of Tag, Tag.Description, is a string, and I want to make a comma-separated concatenation of the Description members.Is there an easier way to do this than to read the Description members into a List(Of String) and then use the Join function?
View 2 RepliesI'm having my program sort an excel sheet by a few columns. However, it is only sorting by the first column not the rest that I specify.ere is my sort code below:
myRange.Sort(Key1:=myRange.Range("A:A"), Order1:=XlSortOrder.xlAscending, Key2:=myRange.Range("G:G"), Order2:=XlSortOrder.xlAscending, Header:=XlYesNoGuess.xlYes, Orientation:=XlSortOrientation.xlSortColumns)
[code]...
I have a WPF ObservableCollection which is bound to a ListBox and I have a Sort() method which when called will convert the ObservableCollection to a List(Of T), and undertakes a sort based on a date/time column within the collection.
The data is sorted, even when new items are added to the ObservableCollection, however the date/time isn't being correctly sorted. The data is sorting based on the date however it is very much random when it comes to the time portion. The following is an example of the outcomes I am experiencing:
[Code]...
Is there anything that I am doing incorrectly in this method that would cause the time portion not be included in the sort? Is there a better way of doing a sort?
I am working on a UDP Client/Server, and currently i have them sending back and forth strings, which i convert to bytes, and then open the bytes to read. I want to now send an Object instead of those strings, which includes multiple unsigned integers and strings.
View 39 RepliesI have a list of strings. For each string in that list, I want to prepend another string. I wrote a method to do it, but I was wondering if there was something already in .NET I could use to do this. It seems like something that could be built in, but I was not able to find anything.
Here is the method I wrote:
Private Function PrependToAllInList(ByRef inputList As List(Of String), ByRef prependString As String) As List(Of String)
Dim returnList As List(Of String) = New List(Of String)
For Each inputString As String In inputList
returnList.Add(String.Format("{0}{1}", prependString, inputString))
[code].....
It works, but I would rather use built in functions whenever possible.
I'm migrating from VB6 to VB.NET, in hence my questions below:
I have to write a function that returns array of strings.
How can I initiate it to empty array? I need it since I have to check if it's empty array after it returns from this function.
Is list of arrays better for this purpose? If I use a list - Is it empty when it firstly defined? How can I check it it's empty?
I have been looking for examples to find the string between two strings. This top one works fine;
Public Sub ReadData(ByRef keywordStart As String, ByRef keywordEnd As String, ByVal filename As String)
Using reader = New StreamReader(filename)
[Code].....
Now the first one is fine - Ext_Volume is result of the string between the strings <Volume> and </Volume>. <Volume> and </Volume> are unique so this is straight forward.
However the second one - "^FDExp:" is unique, but "^FS" is not unique. There are occurances of "^FS" before and after "^FDExp:".
How do I get the string to search AFTER the occurrence, not before etc?
Dim str As String
Dim str2 As Array
str = "blabla duhduh"
str2 = str.Split(" ")
Say the string is something like
bla bla bla bla (cat) bladfdskdfd dsgdsdksf (dog)
dfdshfdskdskfsdfkhsdf sdkfhdsfkdf (kathy) fdsfhdskfhdsfkd (doggy)
I want a generic.list (of string) containing
cat
dog
kathy
doggy
How to do that with regular expression in vb.net
Later I want to do something more complicated like getting all strings between "url":" and ", from this strings
[Code].....
Is there an easy way to find a certain string within a string and then return the strings that you find as an array?I have written this:
Public Function FindStrings(ByVal strSourceString As String, ByVal strStartString As String, ByVal strEndString As String) As String()
Dim StringStartposition As Integer
Dim StringEndPosition As Integer
Dim Currentposition As Integer = 1
[Code]...
I have this string called time. It's value is in this format: HH:MM:SS The numbers change, but the format stays the same. I want to separtate the code into 3 strings Hour, Minutes, Seconds.
View 2 RepliesI have a DataGridView that has some columns with dates. It binds to an in-memory Datatable which gets loaded from an string array of data passed back from the backend Some of the rows returned have nulls for the date columns. Solution 1: If I define the Date column in the DataTable as "string" I can easily convert those nulls to empty strings and display it in the grid as empty strings (desired results). However, if the user clicks on the date column header to sort by date, it doesn't order the rows as you want. You get a purely string sort order. Not acceptable
[Code]...
Here's the weird problem I am trying to solve but cannot get my mind around it. In a text box 1, the user enters 2 or more strings separated by comma. then in text box 2, the user enter 1 or more strings separated by comma. The output then puts the strings from text box 2 between the strings in text box 1
Example:
TextBox1 = visual basic, java, perl
TextBox2 = is better, compared to
[Code]...
i have a string that looks like this "apples,fish,oranges,bananas,fish" i want to be able to sort this list and get only the uniques. how do i do it in vb.net? please provide code
View 3 RepliesI have a dictionary in the form of: { "honda" : 4, "toyota": 7, "ford" : 3, "chevy": 10 }
I want to sort it by the second column aka (the value) descending.
Desired output:
"chevy", 10
"toyota", 7
"honda", 4
"ford", 3
how to sort the files in the directory ?i'll have more than 500 no of files in the below format.
prod_orders_XXX_<TimeStamp>.dat
XXX = symbol of the product and the length may varies between 3-6.
<TimeStamp> = date and time
Multiple files for the same XXX are possible with different time stamps.Here are some examples:
prod_orders_abc_20122001083000.dat
prod_orders_abc_20122001083111.dat
prod_orders_xyz_20122001093157.dat
[code]....
I have a the need for key value pair that I wish to sort so I decided to use a SortedList instead of a HashTable.I am adding the data in the order below to my SortedList which is the order I need it in
Key | Value
--------------------------------
1 "700-800" | List(Of Object)
2 "900-1000" | List(Of Object)
[code]....
The key is a string and the value is a List of objects. The key is representing a time slot that has been concatenated from two integer values and delimited by "-". "700" as a string was 0700 initially an integer.e.g.
Dim key As String = slotTimeStart.ToString() & "-" & slotTimeEnd.ToString()
But once these key value pairs are added to the SortedList they appear in the order
3 "1100-1200" | List(Of Object)
4 "1700-1800" | List(Of Object)
[code]....
Unfortunately I recieve the times slots as two integer values which cannot be changed.Is there any way to force a sort on a SortedList? or is this problem because of the way I am storing my key? Is there a better way to store it?
I have a VB.Net 2005 application in which I access a SQL Server DB to pull data into a Dataset. Within my app, this dataset is read sequentially. Then, a cross reference file is read against the dataset record. If there is a match (based on 2 fields from the dataset record), a field value from the cross reference file is used to replace a certain value in the dataset record. Once a dataset record has been read and processed...it is written to a new CSV file. This CSV file contains 5 columns.
I've been requested to now sort this new CSV file using 3 of the 5 columns as the "Sort Key". What would be the fastest way to do this?
I know one way would be to create a new dataset and insert the finished record into this new dataset in the order of the 3 fields (which I'm not sure how to setup).
I have an XML that looks like this:
<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="library.xslt"?>
<Library>
[code].....
How to sort a recordset using vb 6.0 coding?
View 2 RepliesI need to know if there is any simple way to sort an array in visual Basic.net. I have been trying for some time without any real reliable results or wierd results. Here is the code this is the sort routine which transfers a csv text file read earlier into an array.
Private Sub btnSort_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSort.Click
Dim i As Integer = 2 'inner loop
Dim j As Integer 'outer loop
Dim tempstore As String = String.Empty
ProgressSort.Minimum = 0
[Code]...
The data seems to be read into the array but the sorting takes a very long time and I am not sure if it is working or not. I have read from other forums that it is easier to sort the array read from csv before splitting it. This record I am trying to sort is 250 records long. I have no idea how long that should take. Not even sure if the algorithm I chose is correct.
I have a problem with sorting in datagridview. I load an xml file in a datagridview and I sort the collums for check. when I try to sort it according to it's number the sorting goes like this:
[Code]...
I have two columns in a datagridview, one is a year and the other is a month. These two form a date, but unfortunately the structure in the database I'm forced to use is that of two integers. I need to sort the rows by date, using these two integers. I tried creating an unbound column with a date, but sorting this way seem quite difficult. So, I thought I could do a multicolum sorting by year first and then by month using two columns
View 1 RepliesHow do I disable datagridview sorting?
View 1 RepliesI have this hierarchy of XML
<Chapters>
<Chapter @num="">
<Section @letter="">
[Code]....
There has got to be a simple way of doing this....
I've written the following class to create CheckedListboxes that use a Natural Sort algorithm. The overridden Sort() method, however, is not getting fired.(The code within that method is from the MSDN example on how to implement your own sort algorithm on a regular Listbox.)
[Code]...
A CheckedListbox derives from a Listbox, so I figured the Sort() override would work, but I'm stuck as to why it doesn't.I am setting the instance's .Sorted = True, but it's just sorting items using the default algorithm, and not the Natural Sort algorithm (which has been tested and shown to work as expected elsewhere).
I have a list of keys and values that I would like sorted by key via a custom Comparer(Of T). I tried using a SortedDictionary, but kept getting incorrect results because it used the comparer to see if the items were the same. For example calling SortedDictionary.ContainsKey() would return false, even though it did contain the key.
When I stepped through the code after calling ContainsKey(), it would go to the comparer.Compare(x, y) function. It would then only compare against a few of the keys in the dicionary, and somehow skip the matching item (which I ensured did exist). I take it that this is some sort of optimization, where some items are skipped depending on what is returned by the comparer.Compare() function? Is it possible to have a dictionary that only uses the comparer for sorting? EDIT: I am using a Type object for the dictionary's key
[Code]....