Return Rows That Have A Matching String To Predefined List?
Jul 8, 2009
1 within each section of a SplitContainer. The left hand side will be for inputing text that is copied/pasted from a word, excell, or text file.The right hand side would be for my output. What I would like it to do is return just the rows from the left hand side that contain a match to any one of the predifined strings. This will be used to search large lists of company names and circuit IDs and return the rows with matching namesSo far I have the form created, the Splitcontainer in place along with the richtextbox on each side and a submit button at the bottom.
View 12 Replies
ADVERTISEMENT
Jul 29, 2011
I want the Function to accept List(Of String), Array & String and similarly return List(Of String), Array & String respectively. The Function simply adds a string (month) to the input collection. I just want to use it for string, array and list with needing to think of conversions.
[Code]...
View 2 Replies
Dec 2, 2010
How to return Ilist of strin that object a has username i want return that name
View 1 Replies
Oct 8, 2011
Is there anyway way to delete those rows not matching certain criteria?For example, required rows in Column A - always have either xxxxx-x formatted Account# or Date or word begins with "Total :" anything other then this- those rows are not useful and i want to automatically delete all those unwanted rows.Delete the the rows which has value other then xxxxx-x formatted account# or date or word "Total :"[Account# could be xxxxx-x or xxxx-x or xxx-x or xx-x or x-x means 5digit-1digit or 4digit-1digit or 3digit-1digit or 2digit-1digit or 1digit-1digit.[code]
View 5 Replies
Oct 8, 2011
Is there anyway way to delete those rows not matching certain criteria? For example, required rows in Column A - always have either xxxxx-x formatted Account# or Date or word begins with "Total :" anything other then this- those rows are not useful and i want to automatically delete all those unwanted rows. Delete the the rows which has value other then xxxxx-x formatted account# or date or word "Total :"
[Account# could be xxxxx-x or xxxx-x or xxx-x or xx-x or x-x means 5digit-1digit or 4digit-1digit or 3digit-1digit or 2digit-1digit or 1digit-1digit
====INPUT====
Column A
56981-3
1459-3
10/25/2010
69655-9
Apple
Orange
Total:
01/02/2009
Paint1
987-1
Yellow
Total:
====OUTPUT===
Column A
56981-3
1459-3
10/25/2010
69655-9
Total:
01/02/2009
987-1
Total:
View 4 Replies
Aug 31, 2009
I have this problem with this macro. I think it's a VERY common problem, but I just kind find a straight answer since it's so specific.
I have data like this:
juanA50
juanB60
juanD70
pedroA50
pedroC70
pedroD80
pedroF90
felipeA50
felipeH100
felipeL200
The first column is the name of the employee.
The second one contains the name of payment concepts (salaries, insurance, etc).
The third column contains the actual amount to be charged or discharged.
The desired output should be like this:
___A_B_C_D_E_F_H_L
juan_50_60__70___
pedro_50__70_80__90__
felipe_50____100_200
Delete duplicated values in the names, merge the matching rows of an employee and put them in the correct colum that matches the payment concept. I'm using SQL Server 2000 and Excel 2007, so feel free to talk about querys and Excel 2007 new functions. This is done with a VB6 application (not VBA), so I'm using Excel's object model as a reference in my project. I was originally trying to do it with SQL Server, instead with a macro, but I couldn't find a way.
View 2 Replies
Apr 22, 2010
For a project i am working on, i am taking bookings. These bookings are stored in a database alongside a users personal details. The personal details are assigned an ID according to the user who booked it. A user can book more than once with different personal details.
My problem is that i want a user to be able to edit a booking. I want a list of all the names that user booked to be listed in a combo box. This is the part i am having trouble with. i am using an access database and using sql statements to pull out the data. This is what i have tried so far:
SELECT [First Name]
FROM PersonalDetails
GROUP BY [First Name], UserID
HAVING (UserID = ?)
If i execute this query in the query editor, it works and shows the two records currently assigned the input id. However, if i try to output this to, for example, a text box, then it remains blank. I am assuming thisis because there is more than one output, but i'm not sure.
View 7 Replies
Nov 9, 2011
I'm programming a basic slot machine in Visual basic, and want to use a for loop to randomly choose the image for each slot, display the image in each slot, and change the slotName variable (so I can check later on which symbols are in the slots) for each slot. The problem I'm finding with a for loop is that the variables and objects for each slot have different names (slot1Name, slot2Name, slot3Name, lblSlot1, lblSlot2, lblSlot3, etc). Is there any way I could have could something like:
currentSlotName = "slot" & i & "Name"
This is the code at the moment, this code is repeated (with different variable and object names), for each of the 3 slots, which is pretty inefficient.
' Randomise numbers and assign images to slots based on random numbers, if the hold isn't on
' Slot 1
If Not held1 Then
slot1Value = Int(Rnd() * numbersGenerated + 0.5)
Select Case slot1Value
[Code] .....
View 1 Replies
Jan 25, 2012
Is there an approach to preselect the items in checkedlistbox on formload.
1) I have a form with checkedlistbox
2) items in checkedlistbox are "One" "Two" "Three" "Four"
3) i have a string str="One,Two"
at formload i want these items in the checkedlistbox to be selected.
is there a way other than selecting these item by looping through the items in listedcheckedbox.
i.e., as we can get the selected items by using ".checkeditems" property
i need a way to select the items of checkedlistbox from a string or array in single statement without looping.
View 3 Replies
Feb 7, 2012
Public Class Form1
Dim strname As String
Dim intage As Integer
[Code]....
i am trying to make this program that asks for your name, age and a password the user already has and returns a id number that is generated randomly. my question is how would i match a word to a predetermined list of words then it would get deleted off that said list so it could not be reused.
View 6 Replies
May 16, 2009
I was playing with ASP.NET MVC 1.0 a couple of days ago. I started out with a single table DB named 'Contacts', with very simple structure e.g. Title, FullName, SurName, Email, Phone, Address etc.I'm using LINQ as my Model.In my main view I wanted to display a list of alphabets that have matching FullNames starting with that alphabet plus the count of FullNames. Someting similar as shown below:
A - (2)
D - (4)
J - (1)
and so on.One particular thing about the display is that i don't want to display those alphabets that have no names starting with them.I tried a couple of queries but didn't succeed.
View 3 Replies
Apr 28, 2011
I have an 'In' folder that users drop all different types of files into (.doc, .xls, .rtf, .pdf etc.).Each file that gets dropped into the 'In' folder should have a matching .pdf file (i.e. abc123.doc and abc123.pdf)I have a program which looks into this 'In' directory at regular intervals and moves filename.* to another directory. The folder the files get moved to depends on the first 2 characters of the filename (12-abc.doc might get copied to folder '12' etc).All the files placed in the 'In' folder should have both a native file and a matching .pdf i.e. (abc123.doc and abc123.pdf)In some cases the native file is missing. In some cases the .pdf is missing.There are 2 things that I want to do.
1.) I want to prevent files being moved from the 'In' folder if a .pdf does not exist (I think I can deal with this one ok).
I think perhaps a For Next Loop Array for filenames minus the file extension and if it already exists in the array then copy them (but what if someone has got a .doc and a .xls but no .pdf?!?!? I'm sure somebody could tell me a simple way of achieving this.
2.) This is the part I am struggling with. I need to look in existing folders that files have already been copied to and list:
a.) Native file without matching .pdf
b.) .pdf without matching native file
c.) .pdf with matching native file
View 2 Replies
Jun 30, 2010
I am to make a program that lets the user save certain data values with a delimiter(":") to a text file(done) Example of data entries [code]Then i am to load those values to a listbox , i was able to do that as well and i include the delimiter when i load the values.Now i am supposed to let the user enter any month/year value for date(mm/yyyy) such as 06/2010 and if any of the entries match the search string then either the program selects those values in the listbox or a popup msgbox is used to show the entries. How the result is displayed is a little irrelevant, but how do i search and atleast select the matching entries in the listbox ? and not just the first instance but all instances of the search string.
View 3 Replies
Jun 22, 2010
I have a specialized string dictionary of (string, string) (_RulesAndTheirDescriptions) that contains the name (key) and description (value) of methods in a given class. I currently do the following query to search for a match on the key or value and then bind that to a grid.
[Code]...
View 1 Replies
Jan 19, 2009
I am parsing or attempting parse an xml file that looks like this [code] myNode.FirstChild is where I think I might be going wrong here but anyway.What I want to do again is search through xml searching each tagNum then return all info associated with the matching tagNum.
View 1 Replies
Mar 24, 2009
I am getting this error in MySQL on search for keywords. The error: Can't find FULLTEXT index matching the column list. My Database Table is a MyISAM and my dataTypes I am searching are Text. Any Ideas why I would get the above error?
View 6 Replies
Jul 22, 2011
In javascript I know you can put for instance if date= "2010"* which would do the if for the string if it starts with 2010 but it doesn't matter what comes after that.
View 4 Replies
Jun 9, 2010
I want to check each of the strings in an array (currently in a hashtable, but that shouldn't necessarily matter right?) with the user's input, if the words in each of them match. This might have sounded a little tricky so let me elaborate.
Problem: Comparing an input string with a collection of strings, and know which string in the collection matches the input string the most - based on words. What I'm trying to do here is a chatbot that works with keywords. For example, in the bot script, you could find "HOW ARE YOU" and the response "I am fine." If the user then sends input to this bot, it could look like this: [Code] This may not sound like a tricky thing, but the tricky part comes when I want to know which of the strings (e.g. "HOW ARE YOU") match the input string the most, based on the words.
View 1 Replies
Feb 28, 2012
[Code]...
In this exmample textData is a string of text and alpha is a single letter a through z or A through Z. I don't need the criteria to be case sensitive, but I do need only the first letter of textData to match alpha. I have tested the LIKE comparator and it does not return all records that begin with alpha.
View 3 Replies
May 23, 2012
That was probably bad title, but I'll illustrate what I'm trying to do. I have a method in a class that I need to call several times. The method returns a List(Of String). I'm just grabbing some information from a database.
VB.NET
Public Function GetTestList() As List(Of String)
Dim int As Integer = 0
[code]....
View 4 Replies
Oct 18, 2009
I have a table in my database and I want to return the rows in a data reader and retrieve them in variables. I can do that well but I can only return the last record. The reader doesn't process all the rows.
Try
Dim myconecction As String
myconecction = My.Settings.DataSource
[Code]......
View 10 Replies
Aug 16, 2010
There is something wrong with my filter expression it isnt working. I am simply trying to return the rows that have a CompanyID of mCurrentID. objts is a datatable
Dim mCurrentID As String = lookupInTrenCustomer.EditValue
'populate grid here
Dim mFilter As String = "CompanyID=" & mCurrentID
[Code].....
View 1 Replies
Mar 17, 2012
I have the following code that loads an XML file into a datatable (I went this route because I do not know how to query XML directly). I want to use the Select method to return a row where "age = 72". However, I can't seem to get this to work. Also, if there is a better way to search through a datatable for specifc values that would not require iterating through the whole table to get the results
Imports System.Xml
Module Module1
Sub Main()
[Code]....
View 1 Replies
Jul 8, 2009
I have to scan through documents. Excell, Word, txt, ect looking for company names that match a pre-difined list of companies.I then email the companies some specifics in regards to that doc.The problem I have been having recently is that the list of companies keeps growing and I am starting to miss some more than I used to.What I would like to build is a tiny app that has 2 Text boxes.1 on the left for input (where I would copy/paste) the document text I receive.and one on the right for the output where it will highlight any line that contains the name of any of the pre-defined companies.
I started toying with the idea and so far I have form with a SplitContainer. Within that SplitContainer each side has a TextBox... Below the Textbox on the left hand side splitcontainer I have a submit button with no actions currently assigned to it.
View 6 Replies
Nov 22, 2011
I'm having the datatable with three columns, i need to return the rows in which the third column having the null values.
ie., I need to do like this below mentioned coding,
Dim rows As DataRow() = ds.Tables("Tablename").Select("col3 is null")
Is it possible? if no, anyone tell me the way to get the results.
View 1 Replies
Jul 11, 2009
My datagridview.rows.rowcount always returns 1 no matter how many rows i have in myatagridview?The datagridview is populated by a loop in another function
View 4 Replies
Jul 6, 2011
I have a list of names of players and their names in some game. Now an administrator of that game might want to contact one of the players by sending him a message. He does that by writing a command that basically has the format "tell <player> <message>", where <player> is the name of the player.The problem is simple: player names might be quite complicated and long (it's their screen name not their real name), and it would take the admin quite some time to find out how to spell the name exactly and he will probably make a few mistakes. Basically, having the admin type out the exact name is not practical.So I am trying to implement a 'fuzzy logic' search (is that even the correct term?) but with a twist, I guess.The idea is that the admin can type just part of the name and is even allowed to make a couple mistakes. For example, suppose a player has a screen name of "Mr.Smith34", then the admin should be able to type, for example.[code]
The problem now is that there can be absolutely no ambiguity in which player is meant. Instead of sending a message (which is quite harmless) the admin should also be able to 'kick' or ban someone from a game server, banning them from ever playing there again. Obviously, the admin should then not accidently ban a player named "Mrs.Smith" when he meant "Mr.Smith"! My solution (unless someone else can come up with something better) is to just not allow the command if there are multiple matches. If the admin searches for 'smith' and there are multiple names that are similar to 'smith' (maybe even 'sith' or similar) then I disregard that search and tell the admin he needs to try again with a more specific name.(If all else fails he can always look up the ID of the player and use that, which should be foolproof as long as the admin doesn't make a mistake and picks the wrong ID..., but that is even more work it does not have preference).But this brings further problems. The example I just gave might be good: suppose there's a player "Mr.Smith" and a player "Sith". If the admin searches for 'Smith' then there should be no question who he meant (Mr.Smith), but I am sure any fuzzy logic implementation would count Sith as a very close match... Another thing is that my solution of only allowing the search if there is just a single match probably wouldn't work. I have never used fuzzy logic searching before, but I can imagine some names being marked as 'slightly similar' even when they are completely different ('smi' might match 'smith', but also 'ims' perhaps, in which case it would possibly match a whole new range of names), even though 'for humans' it is clear which result is meant.
I am assuming any fuzzy search would return the matches and rate them according to how similar they are to the search term. Perhaps I can choose some kind of cut-off value, where any matches that are less than 30% similar (I've no idea just guessing here) are assumed not equal whereas higher ranked matches are assumed a possible match. Perhaps this makes it easier (perhaps harder, I dunno), but I forgot to mention that the search term cannot contain any spaces. Player screen names can contain spaces though. I am thinking to just strip out the spaces of each name before starting the search, but perhaps there are better solutions in combination with fuzzy searching...
View 13 Replies
Sep 15, 2010
I've got two tables:
tClient:
ClientID Name=============1 John2 Sally3 Joe4 Nick
tInvoice:
InvoiceID ClientID DateAdded==========================1 1 2010/09/012 1 2010/09/023 3 2010/09/01
I'm trying to write sproc where I need the following info:
[Code]...
View 6 Replies
Jan 20, 2012
I can't figure out the syntax for searching an array of stored words for a string matching an input string. I understand the pseudocode of it, but I'm tripping up over what variables I need to put where, and how they should be formatted. More than happy to provide more details should anyone request them.
[Code]...
View 1 Replies
Jun 5, 2011
I am using vb.net to parse my own basic scripting language, sample below. I am a bit stuck trying to deal with the 2 separate types of nested brackets.
Assuming name = Sam
Assuming timeFormat = hh:mm:ss
Assuming time() is a function that takes a format string but
has a default value and returns a string.
[code]....
I could in theory change the syntax of the script completely but I would rather not. It is designed like this to enable strings without quotes because it will be included in an XML file and quotes in that context were getting messy and very prone to errors and readability issues. If this fails I could redesign using something other than quotes to mark out strings but I would rather use this method.
Preferably, unless there is some other way I am not aware of, I would like to do this using regex. I am aware that the standard regex is not really capable of this but I believe this is possible using MatchEvaluators in vb.net and some form of recursion based replacing. However I have not been able to get my head around it for the last day or so, possibly because it is hugely difficult, possibly because I am ill, or possibly because I am plain thick. I do have the following regex for parts of it.
Detecting the parentheses: (w*?)((.*?))(?=[^(+)]*((|$))
Detecting the square brackets: [[(.*?)]](?=[^[+]]*([[|$))
View 2 Replies
