Take A String Out Of A Database Field And Match It With Another String?
Oct 8, 2009The database field has text inside the field and I want to match it with another string...How do I convert a field to a string?
View 7 RepliesThe database field has text inside the field and I want to match it with another string...How do I convert a field to a string?
View 7 RepliesDim query as String = "Select * from openquery (devbook, 'SELECT wb.arrival_time FROM web_bookings wb ')"All I need is to convert my arrival_time into a datetime field in the query
View 1 RepliesI am trying to match words driven from a database in a string input using VB .NET
The syntax I am using is so simple:
[Code]...
Im trying to work out what the best way to match 2 strings together, but with a difference.
String1 = "dog cat bird chair book table"
String2 = "the dog chassed the cat around the chair"
No I know I can break string1 up by space character and check if each word appears in string 2, I would prefer to not have to do that.If there some sought of regex that would take a group of words and retrun how many of them matched ?
I want to convert a database field that is text into a VBasic String...
View 3 RepliesI have a textbox, I want that if I write a name in the textbox it will automatically append or suggest any names that match from the TblNames field of my Access database
View 2 RepliesI'm pulling records from a db table (sybase) where I have run into a problem with a long varchar field. Using the OLEdb class I convert the field into a string variable which works fine in most cases, but there are problem with a few records. Examining the field in the database it shows that the value is not null, but the length of the field is 0.(SELECT field, length(field) FROM table). When I try to convert this into a string the result is rubbish.strContent = objReader.Item(i). I can't figure out what's the problem here, so I have avoided the issue by doing a table update before I start the process of getting data (I set the field value to null if field.length = 0
View 3 RepliesI have already connected my database and have completed multiple forms and reports.Just discovered that I missed adding ONE field in an Access table.Since it is attached how can I add a field to the database without disconnecting it? If I do disconnect it and reconnect will I have to redesign all my forms and reports?
View 1 RepliesI'm looking for a way to search a string variable for two words and copy the text in between them into another variable. This needs to be done as many times as the match occurs.
View 3 RepliesI have a function that is getting passed a String and a DataRow.The String is a custom formatter. The idea is to do this
String.Format(passed_in_String, DataRow("ColumnINeed"))
The reason this is being done is at this point we have no idea what the column contains.However, if the formatter is "{0:MM/dd/yyyy}" and the DataRow("ColumnINeed") is an integer containing 42, String.Format is returning: MM/dd/yyyy In this situation I need it to throw an exception instead of returning nonsense.Is there anyway to make String.Format throw an exception if the object does not match what the format string is expecting?
I have :
[Code]...
I think I have explained my problem properly..
I'm currently trying to match a word in a string - to a word in an 1 dimensional arrray.
So it does this.
1.Goes into array, gets first word.
2.Looks for that word in the string.
3.If can't find it, go to next word in array.
4.And so forth until it finds it or runs out of words in array.
Problem is the string can be upto 2000 characters long. And the Array with the possible matches can have upto 8000 entries.
So when it runs, if the word begins with 'A' it finds it dead quick as the 'A's are at the top of the array, ordered alphabetically. This is great.
But if the word starts with 'Z' then it takes 4-5 seconds before finding it.
I'm basically using InStr to find the word in the string.
how to check if the user input has a match in my given string
Dim a as string
a = "abc"
if the user input in the textbox "erty" the message box will be shown string not found. if the user input 123abc the message box will be string found
I am making a question and answer game, and I would like to be able to give the user some slack in the answers if they were to misspell a word by a letter or two, like if the answers was Jumps and they type Jump if you did a comparison of them like If string1 = sring2 then do whatever, but obliviously those to string dont match, so it would return false, even though it is the right answer, I came up with this routine to compare two words and if the percentage of the letters are higher then 82 % right it will give you credit for your answer.
[Code]...
i have a string named Workers that had multiple lines of text. I need to search those lines for the term "BackGroundWorker1" if it is found then do something if not do something.
View 3 RepliesI need a way to compare multiple strings to a test string and return the string that closely resembles it:
TEST STRING: THE BROWN FOX JUMPED OVER THE RED COW
CHOICE A : THE RED COW JUMPED OVER THE GREEN CHICKEN
CHOICE B : THE RED COW JUMPED OVER THE RED COW
CHOICE C : THE RED FOX JUMPED OVER THE BROWN COW
(If I did this correctly) The closest string to the "TEST STRING" should be "CHOICE C". What is the easiest way to do this?
I plan on implementing this into multiple languages including VB.net, Lua, and JavaScript. At this point, pseudo code is acceptable.
I am not a regex guy, so I need a little help, just cant get my head around this...
I am writing registration page and using asp.net validators. I need a regex validator to match a special character anywhere within a word, so it will satisfy requirement which says that "ID must have at least one special character." Allowed characters are[code]...
Once again, I am a junior, and having problems with wrapping my head around this stuff at this moment..
I want to match a string for example "yes" but where it is not in brackets so that the following would be matched: yes (bla yes bla) bla yes
View 7 RepliesI want a regular expression for the following issue:I want to match a string that contains A,B,C,D,E and F. string length should be 0 to 6. and not character should be repeat in the string.Example: ABCDEF, ACDEFB, EFBCDA, etc. but not ABBCDES/W Engineer
View 3 RepliesI have a simple string : s:10:"char1";s:2:"13";i:1;a:8:, i'd like to match that 13 from inside " ", in PHP i would do something like :
/s:dd?:"char1";s:dd?:"(.*?)";i:dd?;a:dd?:/i but i'm not good in vb's match methods,so please give me full example how i can match what i need ( it is possible to be multiple matches (2) ).
I'm trying to replace a string with another but the problem is that the string is matching some other string partially.
For e.g. -
Dim x as String = "I am Soham"
x = x.Replace("am","xx")
After this replace I would only like the word am to replaced with xx but because my name also contains am its also getting replaced.
new with Linq and very excited with this feature. However, I want to see if I can do the following with LINQ:
[code]...
Notice that I have a break in my foreach loop, meaning that I just need to reset the first match row's column value to empty string.
How can i filter a DataView to a string nearest match? Almost like a FullTextSearch, is this posible using a DataView?
View 1 RepliesWell my question is simple, I want to match a string with following attributesNo white spaceMust start with a letterMust not contain any other special characters other than nderscore
View 2 RepliesI have a text file contains " staff id, male/female, first name+surname", which look like this[code]...
1: i dont know how to display a error message if the text file is not found
(i can display all the staff's in listbox with one click)
2: i need to display "male" only in the listbox.[code]...
[Code] Which (when looped) checks all items that contain X, However, I am getting a lot of false positives (i.e. if PGA is legit, PGA, LPGA, JLPGA, WHATEVERPGA will all be highlighted as well) Any way to change .indextof to an .exactindexof or something?
View 1 RepliesHeya so im close to be done with this project but unfortunately i still have a couple of questions ill start with the first, imagine this listbox contents:
[Code]...
Now imagine theres a string with : "2-12-2009 | 11:30"How can i delete a listbox item if the string matches the listbox item text after the arrow?It might sound a bit confusing but what im planning to do is to delete a listbox item based on the date of the event and not the date of the alarm.
I have been trying to solve this with no luck. If i have an array Private _msg() As String = {"You have been successfully logged in.", "This message has been sent successfully.", "This message has been posted successfully."} And a string (page source) can LINQ try to find any of the Three elements in the array with out having to use a loop?
View 11 RepliesI am pulling a random name from my database that matches up with images (embedded images) in my project.[code]
View 2 RepliesI want to match whole words for any kinds of strings, my
Text: to happening behitond .to.the to curtains of this .<NET> open <NET> sou<NET>rce project.<NET>
now i have tried this to find "<NET>" (without quotes) the whole word with[code]...