how can i get the illegal character in a string
for example
dim Strto_check as string = "1+2-2"
dim Listof_Illegalstrings = "~!@#$%^&*()_-+=-?/.,><|" ""
now i want a function to find out which is the invalid character available in the strto_check variable and then replace it with a standard place holder
I got this problem, is there way to use "replace" function to replace multiple strings of same list?
Like;
Dim rList As List(Of String)
rList.Add("A")
rList.Add("B")
[Code]....
I found this function that replaces multiple substrings within a string on the internet but it gives an error on one of the parameters.It doesn't like this one:
ByVal ParamArray FindChars()) As String
Can you look at the code and correct the error since I don't yet know about explicitly typed parameters?
Emad
Public Function ReplaceMultiple(ByVal OrigString As String, _
ByVal ReplaceString As String, ByVal ParamArray FindChars()) _[code]......
I am using replace function to replace a character in the file
sw.WriteLine(Regex.Replace(strLine, "\", Chr(13)))
This code is working fine, but now I want to replace two times and I want to use the replace function twice. Something like this, but it is not working . Can anyone tell me how to use Replace function multiple times?
sw.WriteLine(Regex.Replace(strLine, "\", Chr(13)).Replace(strLine, Chr(13), ""))
I am doing a simple database project.I need to give the input in the database which is an access db from my input form and i have managed to do this part right.then i need to retrieve the details from the db using multiple search fields and show them in the datagrid view.I have 8 search fields(5 textboxes and 3 combo boxes). I also have included 4 other buttons which respectively clears the search boxes;clear the results of the gridview; show all results from the database;go to the input form and offcourse 1 search button.now all the buttons working fine except the search button. actually when i click on the search button if i include sql query for all the search fields only the first one works and also if i have clicked any other buttons before clicking the search button nothing happens, no result is shown and it happens the same if i search once and clicked any other buttons and come back to search, no result. I need to show the results in the gridview depending on the user input on those search criterias. user should be able to search in any combinations.I am using the below codings in my search form. the combo boxes are not bound.datagrid is bound to database though.
Public Class Paxsearchfrm
Private Sub Paxsearchfrm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'LAFDataSet.Table1' table. You can move, or remove it, as needed.
End Sub
[code]....
I am trying to filter a list of (t) by multiple criteria. here is what i have:
[Code]....
I now want to filter this list by myObject's various properties. Heres the problem:
1. A user should be able to either filter on one specific custName or remove the filter for this property AND
2. A user should be able to either filter on one specific notificationDate or remove the filter for this propertyl AND
3. A user should be able to either filter on one specific materialType or remove the filter for this property
I know I can just write a lot of if..then but i'm looking for a more elegant solution.
I have a code to search through a listbox with mutiple search criteria. Here is the code:[code]When I search for something, how do I make sure I do not obtain 2 of the same results, If both criteria are found, or if all three are found?
View 4 RepliesOn my view there is a datatable holding a collection of ServerRow and 4 textboxes (Hostname, OS, Location, Zone). When the user types into any of the 4 boxes I want to immediately filter this list. I have this code setup and ready to go that on the set method of each textbox property I call the filter method.
Now onto the problem: if I have 4 criteria that means I have 2 to the power of 4 different scenarios. What I would like to do is write a linq statement with all of these scenarios dealt with such that if any of the properties are NullOrEmpty they will not be used in the Where clause and on the flip side if there is a value the corresponding field will be searched with a Contains.
Example
AvailableCis = New ObservableCollection(Of ServerRow)
(_CiData.Where(Function(ci) ci.OS.ToUpper
.Equals(_selectedOS.ToUpper) AndAlso
ci.HostName.ToUpper.Contains(_ciNameFilterText.ToUpper))
.OrderBy(Function(a) a.CiName))
This example shows how it works with 2 criteria and both of those criteria are set.
Currently I am searching through my list to find Customers that match on Address.
I need to match on both address and city. How do I rewrite my lambda Expression to match both criteria?
CustomerList.FindAll(Function(c) c.Address = addressToMatch)
[code]the main piece deals with the binding source filter. I've tried or/and. i tried to include that both codes in the string. i don't know what to do again i know you would recommend SQL but i don't know how to use that yet, so could you please recommend some bindingsourcefilter code to assist please. Its for a School project the search window looks like the attached picture
View 13 RepliesI am working on a utility to reformat a text file. Working on language to remove duplicate record entries. However there are desirable ("keeper") duplicates and then those I want to remove. I handled the problem by temporarily assigning a unique number to each @D line, then stripping them off after I've removed duplicates. So far so good, except in removing unwanted duplicates I have an extra of the "keeper" duplicates left that doesn't get removed. See below. I am wondering if there is a way to search for a line in a textbox starting with a certain character, but is also proceeded by 2 blank lines and followed by 1 blank line. CODE IM USING TO REMOVE DUPS yet keep formatting with blank line separators, etc.:
[Code]...
I need to create a function named isValid to validate some criteria, text length character content. have validated length but i need to validate at least one Uppercase letter and one number is used(minimum) i was thinking of using a loop to check each character individually. thats probablly where i go wrong i, i often convolute the simple and keep heading of track.
View 3 RepliesI would like to query an Employee by matching First and Last name. Ideally, I'd like to be able to specify that in one EmployeeQueryRq QBFC object.
I think I have a start:
Dim EmployeeQueryRq As IEmployeeQuery
EmployeeQueryRq = requestMsgSet.AppendEmployeeQueryRq()
EmployeeQueryRq.ORListQuery.ListFilter.ORNameFilter.NameFilter.MatchCriterion.SetValue(ENMatchCriterion.mcContains)
EmployeeQueryRq.ORListQuery.ListFilter.ORNameFilter.NameFilter.Name.SetValue(LastName)
Is there any way I can add an additional NameFilter to the same request? Or am I stuck walking a response list for the other criteria (albeit a smaller one limited to containing at least one value)?
Ok so basically heres what i need to do: Extract text from the webpage that meets a certain criteria. There will be a ton of these on 1 page and i would like to add them to a rich textbox on sperate lines.
I know that it needs to be in a loop and its needs to Parse the wepage(Dim web1 As String = Me.WebBrowser1.Document.Body.InnerText)
The criteria is: Starts with 1 to 4(random) integers, Followed by "my" then 13(random) numbers and letters. Or if it starts with "167my" + 6(random) number and letters.
Edit: Also im going to try to make it loop through a list of webpages to do this.
(1) how exactly to format the textbox value in to datetime format like dd/mm/yy HH:mm irrespective of system regional settings
(2) is it necessary to pass the dtavalue as parameter to a access database
in format "MM/dd/yy HH:mm"
I have a datatable as shown in the figure. Let me explain my required based on this image. I have 7 rows of data. The rows 1 and 2 contains columns till UnitSqcNo same. I want only row 3 among the two. In general I want select all the rows with distinct model, unittype, unit and rest with greater CompId. ie the table should look like
View 1 RepliesIn c programming language,
I can do
printf("%d
", value);
But in c#, how can I do it? For example string is "Good %s everybody"
I want to replace %s with the variable. Are there any solution except str.Replace("%s","good morning");
Their is a alfanumeric value of any lenght (string) and i want to replace its all characters with 'X' except right four characters.[code]I have created a function but got stuck:[code]please tell me a better fuction to perform such a operation
View 4 RepliesI have a text file like this
4.5 28 Red (T1 ) [1 12.86 53.8] 229111 -28275 198452 -1309 | 11.0 28 Red (2 13.10 04.0) [T1 ] 130611 2948 229111 28275
1.5 28 Blue (T2 ) [1 07.06 59.1] 191611 51225 190456 39339 |
[code].....
It works for the First Replace but not for the Earnings Replace, I want to check a label and if its have a First Character E I need to be replace with
[Code]...
I am a long time VB6 programmer and am just starting VB 2008.I am learning VB 2008 by converting an existing VB6 program.I have a section of code: [code]frmInstall has an operator input.When the input is complete, gbolWait4Install is changed to Fales.I don't want the program to move on until the operator input is complete.What is a clean way of doing this in VB 2008?
View 1 RepliesI have a replace function in text files where it replaces all the vbTab with ';' betweens the columns. Sometimes it may be that some fields have more vbTabs and then there is lot of empty fields.How do I via a smart and simple way to replace all vbTab with ';'. That is, the field has more than one vbTab will they just be replaced by a
vb.net
Dim Fs As FileStream = New FileStream(my_filename, FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.ReadWrite)
[code].....
i created a DatagridViewNumericUpDownColumn but i got error message Cannot access a disposed object. Object name: 'NumericUpDown'when i closed and reopen the form. It shown You are not authorized to perform this action.how can i get access to view this thread?
View 4 RepliesI am making a program i.e. a script converter. I tried the Replace Command TextBox1.Text.Replace("Hi", "Hello").Replace("Hello", "HI")But this doesn't work. It doesn't replace the second time correctly.
View 2 RepliesI have a VB .NET String. How can I search that string for a character string and replace it with another string?
For example:
Dim rValue As
String = sproc.ExecuteScalar()
' rValue now has the XML string <indracio fire height=23, width - 6>
/* This is the string that I want to search. Replace the words "indracio fire" with the word "lucion time"
How can I search this string for the words "indracio fire" , and replace with the word "lucion time" ?
I'm using a recommended character replace regex I got from this forum, however it is not fully working in deleting unspecified characters
Original String:acAc10[]() _~!#$%^'&*()+-[]`"
Actual Result:acAc10()_#$%'&*()+-"
Desired Result:acAc10() _!'-"
[Code].....
I don't use VB.Net very much, still mostly do VB6, but I am doing this project in .Net. I have a huge string of data, 168 Mb that I stream in from a file to a string variable. Then I have to perform a number of replacements on it before using the data to compile statistics. Because of the nature of the data, I can't break this up into smaller strings.
The problem is that I get a system out of memory error after a few replacements.
I've used both Replace(x,y,z) and X.Replace(y,z). The second one gets a little farther in the code before it crashes, but they both crash.
When I run it in the IDE, the IDE is using about 130 Mb of RAM, the Exe of the app is running about 350 Mb, and one svchost.exe runs about 300 Mb
Other than that there are no major RAM uses going on. The PC has an i7 980x cpu with 12 GB of RAM.
I am creating an text encryption/decryption for my friend and I to use on facebook, because his parents read his messages. I made everything correctly, but when I hit the buttons they don't do anything.
VB
Dim strString As String
Dim strString2 As String
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim strString As String
[code]....
vb.net
'strSearch = textBox.Text, columns 2 to 10 are the optional columns you want to search to. Function WhereQuery(ByVal strSearch As String, ByVal column1 As String, Optional ByVal column2 As String = "", Optional ByVal column3 As String = "", Optional ByVal column4 As String = "", Optional ByVal column5 As String = "", Optional ByVal column6 As String = "", Optional ByVal column7 As String = "",[code]..
sample output:
im also thinking on using stringbuilder to replace my strings.
I am trying to perform calculations on Regex substrings. I would like to do something like (see $2)
lblResult.Text = reg_exp.Replace(txtInput.Text, "$1" & "$2" * 0.039 & "$3" & "$4" & "$5")
I can only do this like:
For Each RxMatch In reg_exp.Matches(Me.txtInput.Text)
Me.lblResult.Text = Me.lblResult.Text & _
RxMatch.Groups.Item(1).ToString & _
Math.Round(CDbl(RxMatch.Groups.Item(2).ToString) * 0.03937, 4) & _
[code]....
