I have a sql table with the following fields
ID = PrimaryKey (nvarchar(50))
Name Surname
sample value of ID = RHO-1 How do i automatically increment the numeric portion when adding a new record to the database eg: RHO-2, RHO-3 and so on.
Is there a way to make it so that when a person clicks the up arrow on a numeric updown it decreases the value by one? (only when they click it, not when they type a new value in)?I seek not answers, but understanding, that I may not solve, but learn.What good is a fish without the skill to catch it?
View 4 RepliesI was wondering what the easiest way is to get a portion of text from a string for example, you have:
"example1,example2,example3"
And i need to be able to get all three of the items separate:
"example1"
"example2"
"example3"
The length and number of items will change, I'm using a listview subitem
Lets say I have a variable: varEmail. It contains a variable equal to the user's email address, so it might contain a value likeNow, lets say I want to get just a portion of the email address, e.g. strip off the domain, like so:
View 5 RepliesI am trying to extract the first portion of a string up to the first SPACE or any non-numeric digit.I thought I could do it but the string may contain an alphabet in the front followed by varying digits of numerals, making it more complicated.Here are some examples of the string to be parsed and the expected results:
String[code].....
I would have to use a series of instr statements but the code would be much cleaner using RegEx.
I have a combobox which is filled with items from a table like this: [Code] What Im trying to do is to when I choose one name from the dropdown list the firstname shall go to one textbox1 and lastname go to textbox2. One way doing this may be to use the ID column wich is the the Primary Key. And do a new search in a button with that ID which fills the textboxes. But how can I get just a portion of the selected string in the combobox to a string so I can do a search on it.
View 5 RepliesI have a userform in 2008 vb express edition. A part number is created from user input via a concat string. I want to then check if a certain portion of the part number exists in the existing file names in a directory. Below is a more detailed explanation.[code]...
View 2 RepliesI have a problem when I select a portion of a string from a RichTextBox. For instance, if I have the following string: (23*6)+5 and I want to select (23*6) the "+" is also selected. I have search for a means to correct this problem, but I have not been able to find a solution.
View 4 RepliesI have thios code that will load a php file (text file) into a sting via streamreader then its supposed to find and replace a portion of the text and write the changes back out to the file via streamwriter. I put my code together and after running it look at the file and it's unchanged. After looking closer it appears the problem is the find & replace operation I am doing on the string. Here is my code:
[Code]...
In my VB project I need to create a unique string of alphanumeric characters 4 in length from a numeric string 8 in length.This numeric string will always be 8 in length and could range from 00000001 through to 99999999
View 12 Repliesi have ID number which is string and i went to do query for maximam ID but it was not come
View 5 RepliesHow to create a string auto Increment like this
For Example.
NTAA001
NTAA002
....
....
[code]....
how can i increment an alphanumeric string? ex : ABC0001 and increment it to ABC0002
View 12 RepliesIn VB.NET, I would like to increment a number in a string and have it zeroed filled. Here is the sample string with the 5 digit number: R00099 What I would like returned after incrementing it by one: R00100
View 5 RepliesIn order for me to increment a Number, It's just too easy.Here's How to Increment a Number.[code]
View 5 RepliesI have a StatusStrip and is filled with Year in the format say "June2009 - May2010". I want to get the years from this string like 2009,2010 from the above string. [Code]
View 2 RepliesI have a StatusStrip and is filled with Year in the format say "June2009 - May2010".
I want to get the years from this string like 2009,2010 from the above string.
I have tried this but not able to further separate June2009.
Dim strYearDet As String()
strYear11, strYear2 As String
strYearDet = StatusStrip1.Items(0).Text.Split("-")
strYear11 = strYearDet(0)
strYear2 = strYearDet(1)
I HAVE A double value as 4 now i want to convert this to string format as "04"
So it must convert each number to a format as "00"
How do you do this using string.format?
I know Val() is a VB6 function, but one thing I like about it is that you can wrap a string in it and it will "extract" the numerical value from the string if there are other things present (i.e. Val("123 Main St.") returns 123). This is the way my teacher taught us to use it. I know about the .TryParse and .Parse methods of the different data types, and how those can be used to check for a numerical value, but is there a replacement that can strip any non-numeric value from a string to put it in an integer (or double, single, decimal, etc.)?
View 14 RepliesHow would I go about replacing a portion of text in a text file with a string?
View 1 Repliesis there a way to check if a string contains characters other than numeric? ive used isnumeric quite a bit and its pretty usefull, but cant find a way to check for text in a string. Having searched around theres a few ways of doing it slowly that ive found using an array of letters and a loop / instring, but thats much more hassle than checking for numbers, so strikes me there must be a way.
[Code]...
I am trying to check if a string is numeric but in vain. here is my code:
If Val(fnumField.Text.Trim) > 0 Or fnumField.Text.Trim = "0" Or Val(phnField.Text.Trim) > 0 Or phnField.Text.Trim = "0" Or Val(ophnField.Text.Trim) > 0 Or _
ophnField.Text.Trim = "0" Or Val(treeField.Text.Trim) > 0 Or treeField.Text.Trim = "0" Then
[code].....
I used a regular expression, which handles both numbers and letters in strings of arbitrary length, in one line of code.
dim rtn as String = Regex.Replace(input, "..", "$& ")
I'd like to take numeric strings of arbitrary length and insert a space every 2 characters.
So 1233456 becomes 12 33 45 6. Is there a way I can use format as string or IFormatProvider, like? That would put a limit on how long the string could be though, right? Since I'm casting to a long.
CLng((input)).ToString("## ")
I'd like to take strings of arbitrary length and insert a space every 2 characters.
123dssas4rr should become 12 3d ss as 4r r
Do we have increment operators in VB.Net? I want to use post increment and Pre increment operators in VB.Net.I want touse the statement like, i++ and ++i.
View 5 RepliesI'm using Entity Framework code first and pulling some data back from our database. In the table I'm accessing is 13 columns that store the number of a items a customer purchased per week for the last 13 weeks as a char field. I have no control over how this data is stored. I need to total the 13 weeks results together to get a combined total, so take week1 + week2 + week3.... = Total Items Purchased over 13 weeks.In SQL I'd just Cast the char to an Integer and add the values together. But I'm struggling finding a solution to do this in linq.
I tried
(From c in Table
Select New With {.Usage = (Convert.ToInt32(c.week1) +
[code]......
I am using standard String.Format method. It is using numeric objects.
Console.WriteLine("obj1 = {0} and obj2 = {1}", "obj1", "obj2");
I want to use named indexes.Like this
Console.WriteLine("obj1 = {o1} and obj2 = {o2}",
new { o1 = "obj1", o2 = "obj2"});
How I can use same last code?
I have an application where the user and search the database and return the values from it. They can also figure the Average, Median, and the Standard Deviation from it. BUt I have a problem with this since the business rules won't allow the result column to be anything but a string so now I am getting error messages on the Select commnad text since it is trying to perform the calculations. I am wondering if there is a way to convert the values in the command text to a numeric value then perform the calculation. Here is the code I am using at the moment.
[Code]...
how to search a string for numeric type characters and return only the numeric characters to an int field? For example: A field contains a string of "Net 30 days" or "Net 10 days" etc. I want to return only the "30" or "10" or whatever # to a int field.
View 17 Repliesdear all i have a list<string> which has the following c1, c1a, c30, c3a, c2,c4b ,c10b,c10a
i cant use the in built sorting function because it gives me in this order
c1
c1a
c10b
[Code]....
ie i want to sort based on second intiger in numeric order ie 1,2,3,...10...30 and then the third a,b,c etc for example c10a,c10b,c10c
I have a strings with different number of characters (30-50). But each string contain only two "x"-characters in different positions. I need code that will extract only a portion of string between the "x".
View 5 Replies