In a Select Case statement is there a way to test if an expression contains a part of a string? Something like this:
Select Case myString
Case "*abc*" 'any string that contains "abc" falls here
Case "*def*" 'etc
End Select
I don't understand the error, Argument not specified for parameter 'test' of 'Public Shared Function TestThis(test As String)'.
Partial Public Class Form1
Shared Sub ReceiveCallback(ByVal ar As IAsyncResult)
Form1.Invoke(TestThis, New Object(){"test"}) 'error
[code].....
Why I am getting this error frmProduct' is a type in 'Test' and cannot be used as an expression.
Below is the code.
[Code]...
Simple question and hoping for simple answer :)
Here is the code:=First(Fields!Asiakas1.Value, "DataSet1") & vbCrLf & First(Fields!Asiakas2.Value, "DataSet1") & vbCrLf & First(Fields!Asiakas3.Value, "DataSet1")
how do i make First(Fields!Asiakas1.Value, "DataSet1") Bold?
I am trying to save date in my database' datetime field.My variable catches date as
vrDteTimePprBgn As Date = Today.Date
then I save it as
drNewRowMCQsAns.Item("DTE") = vrDteTimePprBgn
At runtime, I get error .There was an error in a part of the date format. [ Expression (if known) = ]
There was an error in a part of the date format [ Expression (if known) = ]
View 1 RepliesI am working on an application in Visual Basic Express using an Access 2000 database.I am trying to get athe following SQL query to work but get an error in Access.
The query is:
SELECT [ID], [Title], [Author], [Series], [YearPublished], [ISBN], [CoverPrice], [Style], [Condition], [Signed], [Comments], Count([Title]) AS CountOfBooks, Sum([CoverPrice]) AS TotalCoverPrice
FROM tblBooks
WHERE ID=[@ID];
The error is:"You have tried to execute a query that does not include the spec ified expression 'ID' as a part of the aggragate function."
The query works fine without the 'Count' and 'CoverPrice' count and sum to the query.
I must convert string data from a CNC that is arithmetic expression to a number that I can use in a VB application that I wrote. The following is what I get out of the cnc. [18722*65536+19377]/67108864. I need to evaluate this expression in my VB ap. The format of the string is not always the same as what I have illustrated.
View 2 RepliesI need a regular expression that can validate that a string is an alphanumeric comma delimited string.
Examples:
123, 4A67, GGG, 767 would be valid.
12333, 78787&*, GH778 would be invalid
fghkjhfdg8797< would be invalid
This is what I have so far, but isn't quite right: ^(?=.*[a-zA-Z0-9][,]).*$
I have a string of 5 characters out of which the first two characters should be in some list and next three should be in some other list.How could i validate them with regular expressions? [code]My Strings are going to be: VBBEG, CSBEG, etc.My regular expression should find that the input string first two characters could be either VB, CS, HT and the rest should also be like that.
View 5 RepliesOne number is represented with four hex values.First two hex parts are my "whole number" part, third and fouth hex numbers are my "decimal" part. I just wanted to store my complete number (whole and decimal) in an excel table.My problem is following when I am storing whole part and decimal part of my number separately, then it works fine am getting f.e. 3017 and 0,9445123 in my excel table, but when I am concatenate them, then I am getting following expression in my excel table f.e. 30,179,445,123 but I want 3017,9445123.
rx_str_buf(str_cnt) = CStr(Convert.ToInt64((Hex(rx_str_buf(Factor + 7)) & Hex(rx_str_buf(Factor + 8))), 16) +
(Convert.ToInt64((Hex(rx_str_buf(Factor + 9)) & Hex(rx_str_buf(Factor + 10))), 16) / 65536))
[code].....
I am building an application to update a database.I have a Map table where row 0 holds the target table field name Row 1 holds an update value or Source table Column name Row 2 holds a Where condition eg
Map: CustNo CustName Val1 Val2
Update: 25
Where: =[CustNo] > [Fld14]
In this example I am going to update the Target Table Field 'Val1' to 25 where the Target Table Rows have Field 'Val1' data > 14 AND Target Table Field 'CustNo' = the Source Table Field 'CustNo' AND the Target Table Field 'Val1' > the Source Table Field 'Fld14' Where I am stuck is I at the moment is wondering how I should convert the strings into test conditions as I iterate the Target Table eg Say my test string is stTest and it holds " = 25" For each dr as datarow in dtTarget
some code
... stFld = "Val1"
if dr(stFld) { convert stTest into literal '=' and then 25}
... do something the only way I can think is to build up a series of test cases like:
Select stOp
Case stOp = "="
Case stOp = "<>"
etc.
Reverentjim kindly gave me this code the other day that worked well. There are two more things i am trying to do but cant get my head around it.
1) I want to be able to extract the text after the second and before the period e.g. profile
2) if exists, I want to change the text to lower after the period
I'm looking for some code in .net to allow me to test an xml file to determine if it is well-formed. I am not validating the file against a schema at this point in my code, just testing that it conforms to xml specification for being well formed.
View 1 RepliesI need to retrieve an html page and then isolate part of the code. First, I have a large bit of html. I need to find this:
[Code]...
I am trying to find the best way to extract parts of a string within a string. Take the following line:
[Code]....
How can I say extract just "16" for the height field?
How do i detect a part of a string from a string? For example: i want to check if the part of the string "mummy" exists in a string:"Mummy loves Daddy and loves me too"
View 1 Replieshow do I get a bit of a string? Here is an example:
I have a string:
Hello, my name is James, and I was born on 10.5.1990
How can I get the last part of the string (10.5.1990)
note that the last part could vary in length and could be any other date (but in that format)
How to cut part from this string..."abb.c.d+de.ee+f.xxx+qaa.+.,,s,"... where i know position by this: Result is always between "." (left side of result) and "+" (right side).I know number of "." from left side and number of "+" from right side, to delimit resulting string.Problem is right side, cause i need to count "+" from end.
Say...
from left side: begining is at 4th "."
( this is easy ), result is =
[code].....
Function to test first char of string
View 9 RepliesI would like to display only part of string. I am able to do that as long as my string is constant, how the string is not constant. How would display only the last part of my string. The string will actually be displayed by using a browse button and selecting a file.
[Code]...
I'd like to be able to store the word swimming, the 2 words either side are always the same but the text before and after that is different each time.
Basically I'd like to be able to grab a piece of text in between 2 strings.
I want to extract part of a string starting at a specific character, in this case the asterisc[code]...
View 4 RepliesI want to make a function that takes a string and then returns only a specific part of that string.
The string the function will take is a path to a file such as
D:FolderFolder2Untitled Document_1_2.tif
What i want the function to do is return the
Untitled Document_1
Portion of the supplied string.
how do I remove a certain part of a string, but I don't know what it will be, I only know that it will start with: [Code]
View 4 Repliesi have the folowing problem: i made a combobox on my form and in order to add items to it i use a normal textbox and a string in application settings, the textbox add's the item in both the combobox( with this code ComboBox1.Items.Add(TextBox1.Text) ) and the string in application settings with the folowing code:
[Code]....
How can I remove all of the text to the right of the second to last / in a string.
Before = ftp://sylenttechnologies.com/text/test/another test/
After = ftp://sylenttechnologies.com/text/test/
I would like to have a only part of a string... I have a string[URL] and i want only the part thats past the last / so i would actualy get only "file.part4.rar"I know that this can be done through Regex, But I have never used that, and I read the documentation on it, but I do not understand the part of...
Dim rx As New Regex("^-?d+(.d{2})?$")
What dose each of those characters do and how dose it effect the output...
I have a load of content as shown below:
<td width="20%"><a href="/search?tbs=shop:1&q=camping+lantern&sampleq=1">camping lantern</a></td>
<td width="20%"><a href="/search?
[code].....
I have a string which look like this
dim abc as string
abc = "example=1234"
I would like to remove everything before "=" and "=" so that i would only get "1234". How can i do this.