I want to sort the binding source column (Product Code) which formatted like (AA-AAA AAA AAAA)
but i do not want straight sort on product code column, i want the sort as :
substring of 1,2 + 8,3 + 3,3 and then the rest of the column.
I know i can do it in the table direct using the OrderBy and the substring function, but the problem is that sort is not static it is dynamic according to different status means it change the substring order.
I have a column in my GridView which pulls in an individual's name. Unfortunately, the name is contained in one column in the database - both first and last. I'd like to sort on the last name, not the first...is there a way for me to tell the GridView to sort based on a substring? [code]...
View 1 RepliesI need to sort the rows in a bindingsource. When I sort by a field name, ASC, it works correctly, but when I sort in DESC mode, instead of being the opposite of ASC, it sorts the rows whose fields have the same value in ASC order. For example:
I've got a column with the values A, B, P, P, P and P
ASC: A B P(1) P(2) P(3) P(4)
DESC (as i want it to be): P(4) P(3) P(2) P(1) B A
DESC (as it sorts):P(1) P(2) P(3) P(4) B A
Is there any property in bindingsource which I can use to change this?
I am trying to display a football league table in datagridview. my code gets that data for each column from ms access and displays it in datagridview. I want to sort rows according to the value of the "pts" column.I've tried using using BindingSource.Sort = "pts" but this has had no effect.
[Code]...
I have a Datagridview whose source is a BindingSource. The grid has columns Source,FormatShort, and Number among others. I would like to sort the grid's appearance according to the order below:
View 6 Replieshow to sort a bindingsource basing on a column that has alphanumeric values
View 11 RepliesI'm trying to create a valid RegEx replacement pattern for correctly formatting specific .XML file names. Specifically, if a file name does not begin with a prefix, let's say, ACE_. If the XML file name and extension does not begin with ACE_, prepend the string ACE_ to the file name.For example, if my input source string is the following:
Widgets.xml
I would like to execute a single RegEx Replacement that would result in the string being:
ACE_Widgets.xml.
Conversely, if the string already begins with ACE_, I would like it to remain unchanged. Also,how can I include the pattern ".xml" to ensure that the string pattern for the file name and extension ends with ".xml" in the same matching pattern for the RegEx Replacement pattern? As for the match, I have some luck with the following:
^ACE_{1}[dD]+
Which indicates there is a match for the pattern if the input string is ACE_Widgets.xml and no match if the string is Widgets.xml
The RegEx pattern would suffice, but if you need to know the language in which I'd like to use the replacement pattern is in .NET 4.0 in either C# or VB.NET.
The following posting is close to what Im looking for, but with the inclusion of the *ix directory path prefix, and the use of preg_replace() in PHP, I'm having a bit of a struggle getting it to work with what I need to do:
Regular Expression: How to replace a string that does NOT start with something?
How will I select a substring with 2 criteria? I have a Richtextbox where I select a number after a : with this code; For Each line As String In Richtextbox1.Lines Dim equalsPos As Integer = line.IndexOf(":") + 1 txtFound.AppendText(line.Substring(equalsPos, line.Length - equalsPos)) Next This is working ok, but the whole line.length is appended for number2. The line ex. Some text:my number some text-my number2. I want my number appended to txtFound, and my number2 appended to txtFound2. With my code only number2 can be appended correct.
View 4 RepliesHow can I improve this bit below to make the items in the TreeView to sort faster or something totally different to sort them easier?
[Code]...
I am trying to remove VB6 type code and use VB.Net code, in particular, remove "Left" and use "Substring". This code does not do what the old style code does. It seams to ignore the first two chars and forces the msgbox prompt no matter what I type in the textbox (at "Leave").
Private Sub TextBox5_Leave(ByVal sender As Object, ByVal e As System.EventArgs) Handles TextBox5.Leave
If TextBox5.Text = "" Then
'Do nothing
[CODE]...
I have a MyObject; myObjects as List(Of MyObject) and a delegate Comparison(Of MyObject) that uses a lot of comparison functions (ByA, ByB, ByC etc) Ã la:
Shared Function CompareMyObjectsByName(x As MyObject, y As MyObject) As Integer
Return x.Name.CompareTo(y.Name)
End Function
[Code].....
Sub Sort()
ReDim RollsCC(NumOfPlayers - 1)
For N As Integer = 0 To (NumOfPlayers - 1)[code]....
Here I am creating a temp single dimensional array, merging my 2d array into it, and then attempting to sort it by Rolls(N,1), which is a integer 1-6, Everything seems to be working right with the exception of this.
RollsCC.Sort(RollsCC, 0, 1)
How would one specify a numeral sort based on the first character in the string? im aware that I am switching Rolls(n,1) and Rolls(n,0) information during the sort.
Currently my ListView sorts items by image.index. So 0 is at the top, then 1, 2 and so on. Think of it as an IRC chat room nick list. Ops at top then the rest are sorted alphabetically
[Code]....
I'm getting an ArgumentOutOfRange error when using substring function in .NET. I'm new to .NET so probably doing something wrong. I have a txtField, which is a text field component in GUI. I'm using Microsoft Visual Basic 2010 Express
txtField.Substring(txtField.Length-4,txtField.Length-1)
If txt.Field contains only numberic values it works ok, but as soon as the text field contains characters it breaks.
I have a piece of code that I am using a for next statement and stepping through a string a little bit at a time. The problem is I get an error towards the end of my loop because my substring goes beyond the bounds of my string.
Dim Right As Integer = StartNumber.Value
Dim left As Integer = LengthNumber.Value
Dim i As Integer = 0
[code]....
Also my streamwriter is not writing to my file?
I have a string that contains a file location[code]..."
I want to get a substring of String 1 that does not contain the name of the actual file (e.g. "C:SomeDirectoryEntries")
Which one would you prefer to extract a sub-string from the given string and why?I am thinking that since Left and Right are VB functions and not .NET functions, they may cause problems in the future in terms of compatibility.
View 3 RepliesThis question was resolved in C#, and I don't know how to do it in VB net. I want to search through a directory of files and see if my string is contained within any of the filenames. Then I just need a bolean answer if it exists or not. I know how to use the file.exists...this is not what I need. The link below is to the C# response. How to check if filename contains substring in C#
[Code]...
Example i have string =D:aaabddddd.jpg
string =D:aaabdddddfsdfsdfdd.jpg
i want to flexible sub string from right to ""
so answer=ddddd.jpg and dddddfsdfsdfdd.jpg
My problem is at SubString will do the job for me, but next string could look like this: 101OldGranny91222 So I can't determind the number - for the split - of char in the string, because it changes depending on there name etc.
View 4 RepliesExample : Dim t as string="My game is football"
How can i write flexible code substring word?So Result is
My
Game
Is
football
I have a text label, split half-and-half with a "/".label1.text = "I like dogs/I like cats"This will not be the same text (and not the same textlength)every times. I need to delete everything before the "/" with only a button. (for example, delete "I like dogs")
View 6 RepliesI am trying to sort an arraylist using .Sort() but am not sure what to put in the () for the field/column I want to sort on. Here is the portion of my code that creates the array from a SQL Query
[Code]...
substring and the indexOf method
I have this problem that I'm going in circles on. The error message is "no accessible IndexOf can be called with these arguments."
My professor said that "to search for the string Los Angeles and substring will return it from the textbox, but it needs to know what position to start returning a word at, and that is where the IndexOf comes in." Does that mean substring and IndexOf are used together? That's what I did and may be the problem. Here's the code:
Private Sub btnOrder_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnOrder.Click
'Declare variables
[Code]....
Can a substring have mutiple arguments? I am pulling a substring from a drop down list into my database for records, the string is between 6 and 8 numbers, is it possible to pass more than one argument to make this work?
Sample data:
DropDownList
123456 | Name
1234567 | Name
[Code]....
I am using ASP.NET with VB.NET. This is my code
[Code]...
I just want to trim the value to give me the 20.00 and convert it ToDouble End Result Must be 20.00 C# code will also help me undertand what needs to happen and why I am getting the error messsage Index and length must refer to a location within the string. Parameter name: length
I am working on a simple Point of Sale Program for my Intro to Visual Basic class. I am trying to pull a substring with a decimal point (ex 0009.50) from the string I get from my readline and turn it into a decimal value for calculating money values. Something is wrong with they way that I am converting and I can't find how to to it write in my book.
Private Sub addButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles addButton.Click
Dim currentLine As String = String.Empty
[Code]....
I'm trying to remove a sub string after the last occurrence of a ".". [ocde]...
When I debug, I get an argument out of range exception for the second, counter, parameter; dummy in this case. I'm not sure why; the total length of my test string is 72, when debugging, the dotIndex is 68 and the length is 71, so I'm within the bounds of the string.
This is a tricky situation. I want to extract a certain substring from the strings given below, using VB 6.0. I process each string (row) in a for loop one by one.
[Code]...
I want to keep away from string object. I have a stringbuilder object, and I want to know if it contains 'Firefox'.
View 6 Replies