I'm populating a datagridview from a database where all the data has had apostrophes and quotation marks stripped out and replaced with ASCII values; now I want to replace them back. Since the user can perform a variety of queries that are all displayed in the same table, any column might contain text fields.
View 9 Replies
I have an string in a textfile that looks like this:or something similar. The T's represent true and the F's represent false. I wrote each letter to an array, like so:
[Code]...
First it might sound like an ordinary task but keep reading it isn't. I can't figure out how to find a phrase in a text file, and replace it with something else. Tried lots of things but always ending up with empty hands.
Suppose there's a text file in this order:
valueabc=6000.0000
valuettt=200.0000
valuexyz=7000.0000
I want to;
1) Find the phrase (e.g. valueabc) by scanning the whole text,
2) Replace the number that starts after "=" and ends before ".", namely "6000" in the middle with any number value i want.
I don't need the parts before "=" and after ".", only the number in the middle.
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 need to find several hrefs in html like this:
<table>
<tr><td><a href="url1">link1</a></td>
<td><a href="url2"><img src="image.jpg" /></a></td>
</tr>
</table>
Once found I need to add (replace) to each href something like this:
?ID=1
therefore the html should turn out like this:
<table>
<tr><td><a href="url1?ID=1">link1</a></td>
<td><a href="url2?ID=1"><img src="image.jpg" /></a></td>
</tr>
</table>
I'm creating a method to replace variables in strings, I'm going to share an example of how I'm replacing values and can see short falls in how what I'm doing. Here's a stripped down example of what I'm doing. It replaces a variable with the date specified, so %today(-1) would give me yesterday, %today(2) would give me two days from now.
[Code]...
So I have software to replace string with string, it's cool but I need code which would replace any given character (for example a) with all strings from textbox.
Here is example:
Character to change: a-> X
List of words which should not be touched: "car"
[Code]...
The code below replaces if it finds a given string from the list of contractions with its equivelant from the list of word-contractions. E.g., if it finds 'll it will replace it with Will. The code words but whtn it comes to let's it will replace it with let is.
'remove panctuation and contractions first
Dim contractions As List(Of String) = New List(Of String)(New String() _
{"'ll", "'re", "'ve", "'m", "'d", "'s", "n't", "won't", "lets", "let's", "ikon of elkomenos", "ikon of crucifixion", "ikon of crist elkomenos", "Part A", "Part B", "renaissance style", "hagios nikolaos", "full wall fortification"})
[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 have a DataGridView that has some columns with dates. It binds to an in-memory Datatable which gets loaded from an string array of data passed back from the backend Some of the rows returned have nulls for the date columns. Solution 1: If I define the Date column in the DataTable as "string" I can easily convert those nulls to empty strings and display it in the grid as empty strings (desired results). However, if the user clicks on the date column header to sort by date, it doesn't order the rows as you want. You get a purely string sort order. Not acceptable
[Code]...
Is there an easy way to find a certain string within a string and then return the strings that you find as an array?I have written this:
Public Function FindStrings(ByVal strSourceString As String, ByVal strStartString As String, ByVal strEndString As String) As String()
Dim StringStartposition As Integer
Dim StringEndPosition As Integer
Dim Currentposition As Integer = 1
[Code]...
I have this string called time. It's value is in this format: HH:MM:SS The numbers change, but the format stays the same. I want to separtate the code into 3 strings Hour, Minutes, Seconds.
View 2 RepliesSay I have a List(Of Tag) with Tag being an object. One member of Tag, Tag.Description, is a string, and I want to make a comma-separated concatenation of the Description members.Is there an easier way to do this than to read the Description members into a List(Of String) and then use the Join function?
View 2 RepliesHow can I change the value of one data grid view's cell? I am trying to change the displayed value of an integer (0-5) into one of my enumeration value.
i.e. the current cell displays 3 and I want to change the displayed 3 into the fourth value in my enumeration.
When I add the first item in the datagridview its ok but when i add the second one it replace the last item being added.
here's my code
Private Sub add()
Dim i As Integer
For i = 0 To DataGridView1.Rows.Count - 1
[Code].....
I have a program in which I am doing a sql select on two tables with an outer join. In one option of my search I need to show all items in both tables so some items in the row will come back with a null value. I am familiar with using the DefaultCellStyle.NullValue = which works great when replacing Null values with the same value.
I am in need of replacing the null value in column 0 with the value in column 10. I think I am close but have not had any luck researching this on my own. Here is what I have.
dgvInventory.Columns(0).DefaultCellStyle.NullValue = CStr(dgvInventory.Item(10, ???).Value) if I replace the ??? with any value I get that rows data but all null values become the same, what can I do to tell it to replace the current rows column 0 with the current rows column 10 if column 0 is null.
I am trying to find or search record from a datagridview so I could replace it with a new data from a textbox. I used the datasource.find() method the only problem is...If the my Table consist only of one Row, the find method replaces that one row everytime i insert a data. I just couldn't figure out how to datagridview works with if else statment.
View 2 RepliesThe strings did not filled the items on my datagridview using with system.data.table. When I click the button, nothing are going to fill on my datagridview table.[code]...
View 1 RepliesI have the problem that the DataGridView has obviously a shortcut key for SHIFT + SPACE which seems to select the row.What I would like to have is that pressing SHIFT + SPACE simply adds a space character to the current cursor position within the current cell (like for example in notepad)
View 1 Repliesi want to replace the value of a cell that it have a mask of time like this "##:##" i want to type the numbers and the text inside this cell be replaced for the new char for example:
value of the cell = "15:05"
so i press "2" and
new value of the cell should be like this = "25:05"
[code].....
I am trying to load a DataGridView with a XML file. I got that part pretty easily. But I am having an issue with changing a column to an image column and then converting the text string to the image. This is how my xml is laid out.
[Code]...
But I cannot figure out how to change the 2nd column to in image column. I need to change the {3}{G}{G} to images. Each number and letter would be a different image.
How can i replace selected cells in a datagridview by using copy and paste or some other method. I want to highlight a Row or Column and then replace all the highlighted cells with one value
View 3 RepliesI am using an oleDb connection to connect to an excel spreadsheet (.xlsx) file and load the information into a datagridview. From there I hope to have it edited by a person and programmatically at runtime. However, I noticed that when I import a file that has integers in a column, it will not import any of the string values in that column. Also, It will not allow me to manually enter strings into that column at runtime - it results in an error stating: [Code]
View 16 RepliesThe VB format(object,formatString) command fails when placed in the handler routines of a DataGridView.In the following procedure the newCellValue returns the Format string value instead of a formatted cell value.This pproblem occurs in both the dgv_CellFormatting and the dgv_CellClick routines.The same commands work properly when placed in a procedure on the form.
Private Sub dgv_CellFormatting(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellFormattingEventArgs) Handles dgv.CellFormatting
If e.FormattingApplied = False And Not e.CellStyle.Format = Nothing Then[code]...........
Since XmlDataDocument will be excluded from future versions of visual basic I was wondering how to replace the code below.
Public Sub ReadXML()
Try
Dim xmldoc As New XmlDataDocument()
Dim xmlnode As XmlNodeList
[CODE]...
How can I replace strings in a particular file?
View 2 RepliesDim ab As String = "aaaextBox1.Text = Regex.Replace(TextBox1.Text, "Dim " + ab + " As String", "aab")That is the code I am using now. Problem is that it's output is only "aab".Is there any way to keep the structure, so it would be "Dim aab As String" instead of only "aab"?
View 2 RepliesI tried anything like in if statement but I dont know what should i type in order to replace NaN with a zero or a message like "empty"
Private Sub btnCompute_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCompute.Click
If txtA.Text = Nothing Then
MessageBox.Show("textbox A value is Missing! please input a value", Me.Text, MessageBoxButtons.OK, MessageBoxIcon.Error)
txtA.Focus()
[code]....
Is there a way to use strings in Enums like the example below:
Enum myEnum
val1 = "some string 1"
val2 = "some string 2"
val3 = "some string etc"
End Enum
It seems like you can only use integers for the underlying values.
I guess my question has two parts:
1. My program has to read text out of a text file. I use some HTML tags to preserve the formatting. For example, I might have the line "this is a <b> line </b> of <b> text </b>" where "line" and "text" are bold. How do I make it so the string prints to a RichtextBox, but only "line" and "text" are bold? I would use a RichTextbox.SaveFile method, but the program works by reading a group of richtextboxes in a flowlayoutpanel and appending them to a single text file.
2. How would I extract the text from between two strings? For instance, I have created special tags for use in my program. These tags tell the program where to add controls. Say my string was:
"[IMG= "dog.jpg" /] this is a picture of a dog. [IMG= "cat.jpg"] this is a picture of a cat."
For each occurrence of the string "[IMG=", I would need it to find the corresponding "/]" and extract the text between the two. I could maybe do something with a substring function. I don't know.
