I have a string array Array1 and a string array A2. I want to combine these in a 3rd array A3 but excluding duplicate values. Can this be done through lambda expressions or only through iterating through the array and checking array.Contains()?
View 2 Replies
This is my problem: I have an array with dates in it and I want a list with the dates and how much that date is sequel to the amount of that dates in the array.
This is my code so far:
arrsVerschillendeDagen(iTellerke) is declared on moduleniveau
arriMaand(iTellerke) is declared on moduleniveau
arriJaar(iTellerke) is declared on moduleniveau
I have a subroutine too that redimension my arrays.
Private Sub FillArray()
For iCounter As Integer = 0 To arriDag.Length - 1
arrsVerschillendeDagen(iCounter) = arriDag(iCounter) & "/" & arriMaand(iCounter) & "/" & arriJaar(iCounter)
Next
'result: 14/10/2009, 20/12/2009, 20/12/2009, 14/12/2009, 14/12/2009, 14/12/2009
[Code] .....
I would like to count the frequency of words (excluding some keywords) in a string and sort them DESC. So, how can i do it?
In the following string... This is stackoverflow. I repeat stackoverflow.Where the excluding keywords are
ExKeywords() ={"i","is"}
the output should be like
stackoverflow
repeat
this
I am trying to find duplicates in a string. The code works more than I would. The purpose is to create a jagged array with values and positions like this one:
myString = "1123464263948465475965069068547363532627281901"
jagged= {{{1},{0,1,42,45}},{{2},{2,7,36,38,40}},{{3},{3,9,31,33,35}},{{4},{4,6,11,13,16,29}},.........}
Value Positions
1 0,1,42,45
2 2,7,36,38,40
3 3,9,31,33,35
4 4,6,11,13,16,29 ......... and so on with unique keys and multiple or not values.
My code do this, but looping all over the string there a moment when it repeats values and positions, because already found them earlier. How do I make to keep just the UNIQUES? How do I skip the loop when the value is already in?
My code below
Public Class Form1
Public myString As String = " "
Public jagged()() As Integer
Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
myString = "1123464263948465475965069068547363532627281901"
jagged = New Integer(myString.Length - 1)() {}
[Code] .....
I have for-next loop that loops 6 times around before exiting. Each time it loops it adds a small number and a space to a string so I end up with a string containing 6 numbers separated by spaces. Whats ends up happening is I get "555 555 666 666 777 777" when I should get "444 555 666 777 888 999". I know for sure it isn't the code that generates or applies the numbers because when you put a messagebox.show at the end of the loop it works perfectly, so it seems to me something is happening to quickly but showing the message box every loop gives it time to catch up. What can I do here?
View 2 RepliesI want to remove duplicate values from a string using VB.NET. If values = "3,40,15,109,15" then I need the end result to be "3,40,15,109". I'm using the code below but receiving the error message 'Value of type 'String' cannot be converted to '1-dimensional array of String' and I'm not sure how to proceed.
Dim values As String
values = lblIDList.Text
'Remove duplicates
values = RemoveDuplicates(values)
[code]....
Value of type 'String' cannot be converted to '1-dimensional array of String'.
This seems like a simple question, How do i remove duplicates from a string collection?
View 12 Repliesi have been trying to combine the items in textbox1 with textbox2 and then displaying it in textbox3 with a colon in between but i can not get it to happen. i have tried searching it but cant seem to find any answer.
View 11 RepliesI have a customers List(of String) on which I am trying to find the duplicate customers.[code]...
View 2 RepliesOkay so i have a very large list of string (500 000 strings) i want to check the number of duplicate strings and maybe even isolate the duplicate strings if i can.
i cant find a fast method to do so :S
i tried using a string array (slower than list) takes ~15mins
i tried using list with the code below takes ~10 mins
that wont cut it :S i need something faster.
[Code]...
I've followed examples here and here to create a generic sort with memberexpressions, but how I'm supposed to add a "ThenBy" clause, or combine multiple columns for sorting in the methodcallexpression. Ideally, the ThenBy should go before skip, but it can't because it can't see the orderby clause that I made with the methodcallexpression. GridSortExpression is a Telerik class - it just describes which column and direction the query should be sorted.
Here is what I have right now:
Dim exp As Expressions.Expression(Of Func(Of Product_Catalog, Boolean)) = PredicateBuilder.True(Of Product_Catalog)()
exp = exp.And(Function(e) e.Chapter_Price > 30)
Dim sortExpression As New List(Of GridSortExpression)({New GridSortExpression() With {.SortOrder = GridSortOrder.Descending, .FieldName = "Id"}})
[Code] .....
below i have a piece of code, i have to calculate the next working day +5 from today but this calculation has to calculate days from monday to friday and exclude weekends(saturday & sunday) and also excluse public holidays.i have tried but what i got is that it calculates 5days without excluding anything.example if a record is taken out monday, the return date must be the next monday but with this code calculates weekends as well it says return date is saturday.
Public Function AddWorkingDays(ByVal DateIn As DateTime, _
ByVal ShiftDate As Integer) As DateTime
' Adds the [ShiftDate] number of working days to DateIn
[code]....
Is there a way to get a list of all files in a folder but exclude a certain filetype/extension? Or is the only way to do it is to get all files & loop through them & exclude the filetype with an If statement?
View 3 RepliesWhat's the best way to do this in sort of thing in VB:
[Code]...
Is there any way to select items in a list that aren't contained in another? For example:list1 = From t In list1 Where Not list2.Contains(t.column1)That gives me the error:Value of type 'Integer' cannot be converted to '<anonymous type>'which makes sense, since list2.Contains is expecting the same type as list2. However, the list types are different. I want only to select based on column comparisons.
View 3 RepliesI am uploading Excel File and below is my code. I have no problems so far with filling my dataset but when I tried to validate required fields, I get the error that some values are missing. I checked the Excel files and noticed that there are hidden rows that the user was not able to checked when he's adding values.[code]...
View 2 RepliesI got this DLL functions explained in C++ as below :Void GetResultData(int pIndex,char pStrData[100][255], double pDoubleData[100])
View 2 RepliesI am developping an app which talks across a network and will eventually be used to read in a text file (on the client) and transfer it to the server. Currently, the server and client succesfully connect to each other using the Tcplistener/Tcpclient classes. I am now trying to send some data across the network using the networkstream class, which I have implemented.Currently for testing purposes i am sending a char array which contains the characters "hello" which succesfully sends and outputs to console on the server. Although, "hello" is followed by a long list of whitespaces. I have tried converting this to a string array on the server and/or client and using the string.Trim() function (amongst trying many other things over the past couple of hours) although the output remains the same.
View 19 RepliesThe below code imports my CSV file into the data grid. Only issue is it populates the header with a row from the CSV file, I want the header to be left blank and rows to be imported after it.[code]
View 1 RepliesI want to select all text in a richtextbox excluding any images in it.richtextbox1.SelectAll() will select all objects in the richtextbox not only the text
View 2 RepliesI'm trying to make a function in VB.net that will loop through an algorithm. I've split the algorithm into an array using the Split command, so I have an array with the values. I then try to loop through them and replace a # with "Number" where necessary, however VB.net throws an error. Algorithms are in the format A B C D E F 1 2 3 #
Function generate(ByVal alg As String)
Dim algSplit As String() = alg.Split(" ")
For Each digit In algSplit
[Code]....
I have a string array of size 51 CardListIn() representing randomly ordered cards in a deck {1d, 2d, ...14c} e.g. 9d = 9 of diamonds and so on. I then have 52 text boxes for user input. These have been put into an array of text boxes as so:[code...]
I want to search my original string array for any cards the user may input in any of the textboxes and then delete those entries from the string array.So say the user enters "1d" in one of the textboxes, I then want that removed from the string array.
I'm parsing through both the array and the text boxes fine, but for some reason that I cannot fathom, it doesn't find a match. The string array definitely contains "1d" and the textbox definitely contains "1d", but it doesn't register as a match. I've tried using Val() for the string array and the text boxes, but then it removes every entry beginning with a 1, e.g. "1d", "1h", "1c" & "1s".
Im coming from a background of writing vba in excel, but have go to the point where im fed up of having everything running in excel and have started leaning vb.net. i am trying to do something i have done before, but am pretty much rewriting it as having got the end i now see a better way of doing things
Normally Google is full of help full answers but today it isn't, i may be i'm doing something odd or am trying to use completely the wrong tool for the job am happy to be told either.
I am trying to take data from a text file dumped from one of our databases, i have read the (huge) and oddly formatted text file in, converted it to a 1d array = InPutArray
[Code]...
I have 2 groups, the information i get comes out as follows.
Dim group1 As String = "3 4 7 8 10"
Dim group2 As String = "0 1 2 5 9"
The placements are predetermined, so when the first perso
[code].....
To use StringCollections instead of String Arrays for My.Settings. I've opened a file and have this:
CODE:
But I error on line 2, saying "Object Reference not set in Instance of an Object". So then, I try to use New before I go Into the loop: My.Settings.Trunk = New System.Collections.Specialized.StringCollection
But then i get "index outside bounds of array" still on line 2. This is weird to me. Is it because my StringCollection doesn't have an array size? If so how do i declare an array size for this? Or is this just so totally different from String Arrays?
I am trying to compute time off, I have a datetimepicker which allow user to select a day he wishes to start leave and a textbox to specify no of days applying for.Now I wand to use dateadd function to calculate resumption date excluding Weekends.
View 2 RepliesI'm currently counting all the checked checkboxes in an asp.net gridview using:
$('#cphMain_gdvSalesOrder').delegate('input:checkbox', 'click', function() {
var count = $('#cphMain_gdvSalesOrder').find('input:checkbox:checked').length;
Whereas I need to count all the checkboxes that are checked apart from the one in the header.
Given an input string like the following:I, Need, Some, Coffee, Before, I, "Fall, Asleep" I need to split this into parts like so:
I
Need
Some
[code]...
Splitting on the comma character alone is easy enough, but how can I handle the quotationmarks? Regular expressions is not on my strong side, and I have been googling for quite a bit without any good results.
VS 2010, VB.NET, WINFORMS. In my app i have a need to import foxpro database tables and exclude the deleted records. The problem is that FOXPRO tables keep deleted items inside the same table. I have tried using DELETED=NO in the connection string but vb throws "Format of the initialization string does not conform to the OLE DB specification."
My function is as follows:
Dim _DBConn1 As String = "provider=vfpoledb.1; Data Source = " & file1 & ";DELETED=NO"
Dim _DBConn2 As String = "provider=vfpoledb.1; Data Source = " & file2 & ";DELETED=NO"
Dim _DBConn3 As String = "provider=vfpoledb.1; Data Source = " & file3 & ";DELETED=NO"
Google results pointed me in the direction of DELETED=NO but its throwing that exception error now that I have added it..
In VB6 I load a recordset containg all of the records (6 fields per record)in a table into an XArray and then manipulate the records in the array and then write them back to the original table. The array issorted by the first field (1 to maybe 8000 or more) I need to find records in the array by an ID field and then move them (because of some external criteria that happens many times) from say number 400 to number 375. Then all of the other records between 375 and 399 were renumbered up 1 to fill the gaps left by the move.
The XArray worked well as it could find and also move to a next record easily to facilitate the revisions to each record quickly. Everything is done in VB6 in code and nothing visual needs to be shown to the user until say 2000 of these external changes are complete. What is the best, most efficient way to do this in the .Net framework in VB2010. Datasets, Dataviews. tableadapters, arrays. enums ?
