I am trying to input a very long list of dog breed names into a DB via phpmyadmin, this will take me for ever manualy and I was thinking if I could work out how to write something quick and nasty to create the sql string for each dog breed it would save me so much time. The sql query for each added forum is in the following format:
[Code]...
I need to create a VBA script that can be used to input a list of workstation names and display the memberOf, Home Server and OU for that workstation?
View 9 RepliesI'm trying to create a form that accepts names (or any strings) as input and stores them in a object. See attached form sample.Form Image:
Operations: ï Initially the NumericUpDown object on the form should be disabled.The user enters a value (string) in the textbox and clicks the Add button or presses the Enter key to activate that button.The application then stores that name in a List object, and displays the last entry in the Label underneath.The NumericUpDown should become enable after the first entry. The user should be able to move between all the values entered using NumericUpDown.
I want to convert a List (of Long) into a string array.
Reason: it's a list of database IDs and I want to make a comma delimited string to pass into a stored proc.I tried this:
Dim commaDelimitedList As String = String.Join(",", itemIDList.Cast(Of String)().ToArray)
but I'm clearly not using the Cast correctly since it throws an exception:
System.InvalidCastException: Unable to cast object of type 'System.Int64' to type 'System.String'..
Is there a way to get Cast working for this, or am I stuck with ConvertAll and a delegate function?
the form loads, it loads the fetch data from mysql in a datagridview, but when i click cancel button, it will again load the same data.
View 1 RepliesI have 4 string lists as follows
Dim input_list As New List(Of String) Dim input_POS As New List(Of String) Dim trigger_list As New List(Of String) Dim trigger_POS As New List(Of String)
I want to compare the contents of the input list (containing words (e.g., want, the) etc. to the ones of the trigger list (containign again words) and if a same entry (i.e. word) get the POS for both input word and trigger word from the relevant lists and put them into a property list. For example
input list (want, the, right)trigger list(want, there, wait)input list POS (verb, article, adjective)trigger list POS (verb, pronoun, verb)
Output property list (want:verb, want:verb) (only want is common between input and trigger list). Then I need to conduct a test between the two property items for similarites. If they are exactly the same, the code should output a confirmation "i.e., Yes" into a textbox. If not the code should output a "No" plus the contents of the property list into a textbox.
I wanted to know if it's possible to remove a paticular item in my collection and then add it back at a certain location? e.g. say I use RemoveAt and remove the first item in the colleciton; after, I want to add it back at a particular location (index)? Maybe this isn't possible with this type or any other type collection?
View 6 RepliesI'm trying to create an application that is able to find products from a XML file, which will contain the following data:EAN (Barcode as a string, not an image)
Description
Price
Stock
So basically, I enter the EAN and my program will lookup the XML file for this EAN and will return the description of this product, the price and the stock in a new messagebox. However, I don't understand how to create a XML file, add items, remove items, edit items, and most of all: read items from a XML file.
im working on a small application that lets you input a phone number with "-" hyphens, and then copy that number to a label control minus the hyphens. So for instance 111-234-567 would become 111234567, i have accomplished this using the string.
replace command, however i was wandering if it would be possible to iterate through the string with a for next loop looking for the hyphens and then removing them with the string.
remove command, ive spent nearly 5 hrs trying to get the code to work, but to no avail, no errors are being thrown up, but the hyphens still display along with the number, i am currently teaching myself, and its a sloooooooow process. here is my unsucessful code
[code...]
This is probably quite a simple question, but I can't remember how to do it off hand.I have an e-mail address of "foo@bar.com".I want to grab the @ and everything after it and then I'll be adding a prefix to the front of the address as I go.
I'm just wonderng how I get hold of the @bar.com from the string?
I know I should know how to do this as this is a really simple operation.
My.Settings.regLibCardNo = "10-0000"
I want it to increment
CODE:
I am used to C like languages such as C#. I added a list box with a list of names. In the code behind I added the below code. When I run the code I am getting the MessageBox but it will state "UserName favorite color is " but does not show the color. I thought it might be misspelled or non-matching names but this is not the issue due to the names being correct.
Public Class Form1
Private Sub lstData_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lstData.SelectedIndexChanged
'Declare Variables
[CODE]...
When I try to remove the last few characters of a string, I get an index out of range error. I am using the following to remove the characters from the end of the string:
objJSONStringBuilder.Remove(objJSONStringBuilder.Length - 1, 6)
The string has <hr /> at the end which I want to remove.
I'm suppose to end up with a label box with my name spelled out in it using string manipulation. This is suppose to happen using the concatenated string to output the name into the label box. I don't have any error codes but I also don't have my name in the label either. [code] "Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using 'Content here, content here', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for 'lorem ipsum' will uncover many web sites still in their infancy. [code]
View 2 RepliesSo I have a string "New". What is the simplest way to convert that string to "New". Basically right now I'm doing this:
Case "NEW"
makes = connector.GetMakesByYear(_AuthorizationKey, "NewCar", CDate(Now), Year)
Case "USED"
makes = connector.GetMakesByYear(_AuthorizationKey, "UsedCar", CDate(Now), Year)
And I would prefer not to use a case statement because it's only one parameter that needs to change, and both are appended with "Car".
The idea is simple, if I have a string value "ABCD" then with a ButtonClick event it should randomly reveal a char while others are hidden. i.e, "B*" another click would "AB**" and so on. So far, my I have been stuck in a for loop.
[Code]...
I am trying to do string manipulation of an OpenID in my codebehind. For example, if the user enters " url...I want to do the following:
1. Remove the http:// or https:// if it exists
2. Remove the "/" at the end of the OpenID if it exists
So that all would be returned is url...I have used the Right, Mid and Left functions before with a string that contained spaces but I'm not sure how to accomplish what I'm trying to do here.
I am trying an encrypting exercise which takes the txtmessage and encrypts it in characterarray.IStartAt is the starting point and by taking one character at a time from txtmessage I need to insert it in characterarry allowing a gap in between which is IUseGap. KeyGap and Keyfirst will be the next two characters after txtmessage and when insert have no gap in between.I think the logic I done is good however, I get syntax errors on the red lines.[code]
View 11 RepliesI need some help writing a program that navigates to a certain URL, and then when I click a button, it gets the string after the word(in the HTML source code)MD5:and then there is a 32 bit string. How could I list the 32 bit string in a textbox?It can contain MD5: aswell too.. I don't mind
View 2 RepliesI am getting a syntax error missing operator, I have tried this so many times by eyes are crossed can someone spot my mistake?
HTML
"SELECT * , Left([DateSold], Len([DateSold])-(InStr([DateSold], 'AM')-InStr([DateSold],'1')+1) AS DateSold , FROM " & Me.OpenFileDialog1.SafeFileName & " Where
[code].....
[code] How to substring only the line(s) below the explanation e.g. No match for "VBFORUMSBLAHBLAH.COM". Everything else should be ignored.
View 10 RepliesI am having some problems with manipulating a one dimensional string array in VB.NET and would like My objective is to get 4 variables (if possible) from a file path. These variables are: myCountry, myCity, myStreet, Filename. All declared as string. The file location is also declared as string. so I have:
Dim filePath As String to illustrate my problem, and what I am trying to do, I have the following examples:
1- C:mylocationisUKBirminghamSummer Road his house.txt.
[Code]...
So I'm working on a software in VB.Net where I need to scrape information and process it according to rules. For example, simple string replace rules like making "Det" into "Detached" for a specific field, or a split/join rule, basic string operations. All my scraping rules are RegEx and I store them in a database in rows of rule sets for different situations.What is the best way behind creating/storing rules to manipulate text? I do not want to hardcode the rules into the software, but rather be able to add more as there will be a need for them. I want to store them in a database, but then how do I interpret them?
View 1 RepliesI have an IEnumerable as a result of LINQ, which contains Value and Count. After I get the result, I want to do a string manipulation on the Value and make the corresponding Count to half. Is that possible with LINQ?
View 6 RepliesI thought you could use a structure as a container. I have line_1 with a line of data read in from a file. I only want to Look in position 1 of the line and position 8 for 9 and position 31 for 11. If I create a line_2 with the parts broken out for pieces that I want to look at then I could use a with statement right?
[Code]...
Is there a way to get the fraction parts of a Double without using string manipulations? Specifically in vb.net?
There are numerous examples for a decimal in various languages. One for vb.net is this one
Basically they all seem to use either a mod or Truncate method or they take advantage of casting to integer behavior. But none of those approaches will work for a double/float type due to the inherent inaccuracy of the double/float type. There is also the problem that doubles don't cast to decimals reliably. Below is a test case to show what I mean and expect.
<TestClass> _
Public Class BasicNumberTests
Function DecimalFractionalPart(ByVal number As Decimal) As Decimal
[Code]....
I have a very simple question: I have a string that may say "3x itemname", or "32x itemname". How do I get it to return the number infront of the x?
View 4 RepliesVB.NET 2010/ASP.NET 4. I am using a web service which returns a string like this:
US,"UNITED STATES",MN,MINNESOTA,"MAPLE GROVE",45.1234,-93.4947,613,763,AMERICA/CHICAGO,NA,55311,"COMCAST CABLE","COMCAST CABLE",COMCAST.NET,"AS13367 COMCAST CABLE COMMUNICATIONS HOLDINGS, INC",CABLE/DSL,RESIDENTIAL,3,99,35,96,,
If I split by comma it's usually fine except in the above string I have the following:
"AS13367 COMCAST CABLE COMMUNICATIONS HOLDINGS, INC"
Which contains a comma and splits into two. This I don't want.
How to see if this field (array(15)) contains a comma & if it does to leave it intact into one array field? It's always constant in the same place in the array
Example:
(14) = COMCAST.NET
(15) = "AS13367 COMCAST CABLE COMMUNICATIONS HOLDINGS"
(16) = "INC"
(17) = CABLE/DSL
But I wish to keep it so it's:
(14) = COMCAST.NET
(15) = "AS13367 COMCAST CABLE COMMUNICATIONS HOLDINGS, INC"
(16) = CABLE/DSL
i have a string "The quick brown fox" i want to return the first letter of each word.. "The Quick Brown Fox" will be "TQBF"
View 5 RepliesI have a Richtextbox with many lines. The data is as follow:
[Z=100, A=10, B=20, C=100]
[Z=100, A=33, B=50, C=255]
I want to split the lines to 3 new Richtextboxes, with the A, B and C values + the line number. Should maybe not be so hard, but I got stuck.
This code extracts the A, but obvious only the first line.
Dim values As String
values = RtbAll.Text
Dim Rawdata As String() = Nothing
Rawdata = values.Split(","c)
Dim s As Integer
For s = 0 To Rawdata.GetUpperBound(0)
RtbRed.Text = (Rawdata(1) & Environment.NewLine)
Next s
