Ok i have a weird issue. I cant figure out what to use... CSV has two colums :-Name, MobileJohn Doe,60002000Jane Doe,Now i would like to delete the whole line if mobile number is empty.. i cant figure out what to use. Mobile number are 8 digits long.
View 11 Replies
I am using TextFieldParser to Read a Tab Delimited Text DataFile. The problem I have is that some times the data file (3rd party provided) contains an extra Tab which therefore creates an extra column. I need to remove this unnecessary column. Some columns will have rows that are empty so I cant just delete the column if it has a blank row, So I think I need to loop through each column and if if every row is blacnk then delete that column.
Here is the code that reads the file, I was going to remove the column from the table called table before I populate the table called dtAll , which is what my program uses
Dim safeFileName As String = IO.Path.GetFileName(Me.OpenFileDialog1.FileName)
Using myReader As New Microsoft.VisualBasic.FileIO.TextFieldParser(safeFileName)
myReader.SetDelimiters(vbTab)
Dim currentRow As String()
[Code] .....
I have a comma delimited text file, like this;
[URL]
my program can add new lines and select url's but I can't get the remove button working, I read that (maybe) I have to read all lines and write a new file.
If removename = currentfield Then
Dim removedata As New System.IO.StreamWriter("z:station.list.txt")
removedata.Write(""(currentfield))
removedata.Close()
End If
I remove a line from a textfile with the following code. It works fine, but when I remove the first line, a blank line has been left. How can I fix this?
Public Sub DelLineFromFile(ByVal filename As String, ByVal line As Integer)
Try
Dim lines As String() = My.Computer.FileSystem.ReadAllText( _
[code].....
I currently have a bunch of text files I need to edit in a folder, I need to edit each file and remove the same line but not all files have this line, so I need to create a script that needs to check if the line exists then remove it.I have 1000s of files, that's why I need help to be able to create a script that does it for me instead of me editing each one manually.I am not sure on how to do this, but I am sure it is not difficult for people that have good experience with VB.net.
View 8 RepliesI created a windows form which contains a datagridview. I named one of the columns in the grid 'location' which appears to have generated an error. The problem is I cannot load the form to remove the column as an error is generated and when I load the designer code it says do not modify with the code editor but use the windows form designer.
[Code]...
How do I find Line 40 and column 89 in my code. I get the following error message.Error 1 Handles clause requires a WithEvents variable defined in the containing type or one of its base types. Line 40 column 89.
View 1 RepliesHow do I find Line 40 and column 89 in my code. I get the following error message. Error 1 Handles clause requires a WithEvents variable defined in the containing type or one of its base types. Line 40 column 89.
View 2 RepliesI have lines like this in my text file
SP-J1-B 203101 Black 99.0 28 0 0
SP-J2-B 203102 Black 99.0 28 0 0
SP-J3-B 20303 Black 99.0 28 0 0
SP-J4-B 20377 Black 99.0 28 0 0
SP-J5-B 203104 Black 99.0 28 0 0
i want to change the value of column two with my own value so i split the string like this
Dim FileContents() As String = IO.File.ReadAllLines("C:\switchoutputA.txt")
For Y As Integer = 0 To FileContents.GetUpperBound(0)
Dim blah() As String = FileContents(Y).Split(New String() {" "},
[Code]....
but some times it dont want to remove empty entries and i get blah(1)="" without any value. how to remove the empty entries?
I don't want the last empty row appear in my DataGridView1. How to get rid of it? Please advise. I am adding data through textboxes. The DataGridview is only to see the data.
View 2 RepliesI am trying to split at every space " ", but it will not let me remove empty entries and then find the length, but it is treated as a syntax error.
My code:
TextBox1.Text.Split(" ", StringSplitOptions.RemoveEmptyEntries).Length
I am developing an app which has a TabControl and Several TabPages. However when I switch the taps to be dislayed on the side I am left with a large amount of empty space. I am unable to move the TabPage to remove the empty space.
View 1 RepliesRemove empty elements from char arrayI have this [code]...
View 6 RepliesI'm trying to remove empty paragraphs from a .docx file before parsing the content into xml. How would I achieve this?
[Code]...
I try to remove empty space from a large string, using replace(), and using regex.
the replace method:
replace
Do While (stripped.IndexOf(Space(2)) >= 0)
stripped = stripped.Replace(Space(2), " ")
Loop
and with regex using its replace with : "/ss+/" - regular expression.
but I am still stuck with empty strings such as :
temp ""String
these string have lengths ranging between 3 and 8, so I have tried to adapt the replace function with something like this:
replace 2
Do While (stripped.IndexOf(Space(4)) >= 0)
stripped = stripped.Replace(Space(4), Space(1))
Loop
I am trying to use xml documents to store data for a movie database, but am having an issue
here is the code I am using
Imports <"...movies.xml">
Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click
[Code]....
Why do I get that xmlns = "" in the movie parent node?
Of I remove the parent node from the movieAdd variable it puts xlmns = in all the nodes
File I/O and Registry :: Remove empty folders from a TreeView
View 6 RepliesHow can I open a tab delimited text file and remove the columns that are empty and the save it? Empty columns are those that have no value in the first row.
View 7 RepliesI have a list of files to read and have to append them all to one unique file. the problem is that when i open the first file to read. I read the first line and discard it. when i read the second line, its empty, but it is not in the original file. what im doing wrong? [Code]
View 13 Repliesi want to check the table column null or empty......in vb.net iam using ms access in backend.....
View 2 Repliesis there a way to show in datagrid only those row that has column that is empty, im using this code
Me.DataGridView1.DataSource = ds.Tables("0").Copy() but it shows all the data from my table.
What is the best datagridview event to use these codes I want to check column 0 is empty or has some value
If e.ColumnIndex = 0 Then
If DataGridView1.CurrentCell.Value = "" Then
MsgBox("Empty Value")
[code]....
Hi, Is there any way to check which row of the value(any of the Column) is empty and get the row number??
View 4 RepliesI've got a Program and a text file, this text file gets load into the list box but that's not the problem. The problem is that when I make the text file it makes a open line and this line gets loaded into the list box and I don't want empty items.
So here's code that I use to make text file
Public MySettingfile As String = My.Application.Info.DirectoryPath & "Process History.MemFreo" Dim myCoolWriter As New IO.StreamWriter(MySettingfile, True, System.Text.Encoding.Default)
myCoolWriter.WriteLine()
myCoolWriter.Close()
I am trying to save details from my program into a sort of mini database using excel, my program isnt having a problem opening the excel file, it is having trouble inputting the data. The first problem i would like help with is maybe a loop of some sort to get my program to look through each line on my excel spreadsheet and find the next empty line so it can input the data.
I was having some help from another person who gave me some code which go's to the very bottom cell and goes up until it finds text and then off sets by 1. However this was in the form of a macro, and I need a way to do it from my program.
[Code]....
new with Linq and very excited with this feature. However, I want to see if I can do the following with LINQ:
[code]...
Notice that I have a break in my foreach loop, meaning that I just need to reset the first match row's column value to empty string.
I am trying to get this to iterate and append the items in my listbox, which are single column excel files into a single sheet. However, for some reason its placing my second data set out in the bottom of the sheet. I feel like I'm probably missing something very basic here and I've been looking at for to long this afternoon. I used to create this worked splendidly in some other applications I've been developing.
vb version is 2008 VB express excel version is 10.0
Code:
For Each filename In ListBox3.Items
If System.IO.File.Exists(filename) = True Then
xlBook = CType(xlApp.Workbooks.Open(filename), Excel.Workbook)
[Code].....
I have a richtextbox which has CSV values in each line. Whenever a line is inserted, after pressing a command button the program lets the user know how many categories each line has.
Example:
Line1: a,b,c,d,e
Line2: x,y,z
Pressing the command button would say: Line1: 6 categories, Line2: 3 categories. This works fine, except from when I want a line to NOT contain any categories.
[Code]...
I understand that VB recognizes the vbCrlf on Line2 as a char, hence a 'category', hence the line is not empty. But what happens when I want to consider a line as empty (ie Line2:0 categories)? Should I go with something like if txt.line(i).text = vbcrlf then...? This solution seems kind of like bypassing the problem instead of actually solving it.. Or maybe it's just me?
My requirement is to read all rows of an excel-sheet in first column that are not empty, are numeric and have a length between 15 and 20.
For example:
358218033354974
359473035499561
358218036156129
354022038366247
358218032490035
359473030516492
353210040325399
This column might have a header that is not numeric and there might be empty rows. This would cause an exception when importing them via SqlBulkCopy. So i want to prefilter the correct rows via OleDbCommand.
What I have tried so far is following(C# is also appreciated):
Using connection As New OleDbConnection(sExcelConnectionString)
connection.Open()
Dim schemaTable As DataTable = _
connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, _
New Object() {Nothing, Nothing, Nothing, "TABLE"})
[Code] .....
But this throws an exception if there are empty rows or the format of the value is incorrect. So my question is: How to restrict the rows of OleDbCommand to:
Get only first column of every worksheet
All values that are numeric
Skip empty values
Ideally only the values with a length between 15 and 20
Any way how to skip the empty rows, Or do I have to to select the whole datatable? I hoped it would be possible to do that only with one query because of performance reasons.
I try to hide the radio button if the cell is blank but the radio button still show even the cells is blank. why the radio button will not hide?
Dim temp As String = questionDetails.Rows(3).Cells(1).Text
If temp = "" Then
Option3.Visible = False
[Code].....
