defining an expression to capture the four numerics per line that define the lines on a map.
59.684 -4.251 59.575 -5.576
59.575 -5.576 59.437 -6.899
59.437 -6.899 59.27 -8.218
[Code]....
I used to do a bit of coding in early versions of VB years ago but moved on to things like RPG400, CL and SQL on an AS/400 box. As I am no longer in this career, I havent touched an AS/400 for a while either.
I am currently working on a visual basic console application in Visual Studio 2005 which takes various csv files from an osCommerce web shop, processes them and writes the data to TAS Books accounts software with the aid of the Infoplex COM module.
I have 2 functions, one reads each line of a csv file into an array, and the second function uses Regex to split the lines array into the various fields before they are added to a structure.
There are something like 5000 records (lines) in the csv file, one example is as follows;
[Code]...
My problem is that due to the formatting of the product description in the example csv line above, it fails the Regex match and therefore fails to read.
I know this is because my pattern is wrong, but I'm not sure how to solve it, I think all I really need is for Regex to split the line by the "," between each element, this might be a little difficult because some of the descriptions contain both , and " but never one after the other.
Say I have this list (with unknown delimiters):
ABC-12345, DEF-34567; WER-12312
ERT-23423
I know the regex to mach what I need is: [A-ZÆØÅ]{3}-d{5}. But how do I use the Group or Capture of the .net Match class?
This is my first attempt:
Public Function ParseSites(ByVal txt As String) As List(Of String)
Const SiteIdRegEx = "([A-ZÆØÅ]{3}-d{5})"
Dim list As New List(Of String)
[Code].....
This may take some explaining but the concept is pretty simple. A user will select a file which contains data that they wish to extract from, so keeping it simple they pick a file like so:
[Code]....
So, I need to show the user the file, allow them to select a line to match and/or extract from. So they select the first line ready for a match, they then select a word/s to mark as a constant for matching, so in this case it would be: MyGroup A simple version for text match would be like "MyGroup *" Now, I need to convert this to regex dynamically (I assume its the best method), its not a one off, the data that is selected is all open and up to user selection. There could be multiple selections and multiple extractions on the same line!
[Code]....
I'm trying to find the right RegEx to capture some (potentially) repeating data. I don't know how many times it will repeat. If I give an exanple of the data and what I want to capture can anyone point me in the right direction? It's the .Net regex engine (Visual Basic)
[Code]...
I'm trying to find a way where i can make it loop through the results of my capture group regex query.
For instance if i have this:
VB.NET
Dim matches = Regex.Matches("<h1><span>test</span></h1>", "(?<=<h1>(<span>)?)(?<data>.+)(?=(</span>)?</h1>)")For Each item In matches.OfType(Of Match)()Console.WriteLine(item.Value)Next
And i'm trying to get the contents of <data>, how do i do it without it printing out the junk before it and after it?
quantifier isn't working, its supposed to make the <span> tag optional in the query, but it isn't.
Im trying to combine "contains" with a "Regex" and I just cannot get the right syntax down.
[Code].....
how can i capture the value of left in the line below using string function:
left position is left:215px
i must capture the value 215.
Can I use Visual Basic 2008 Express Edition to make a program that can take audio directly from the microphone line and decode it to from data? ( I'm building wireless transmition software for ameteur radio )
View 1 RepliesA string contains the following lines:
:61: C123456,1235AC
:81: hekljkjkjskdjfjafja;f
Bet. kenmerk 123456
I have code for regex.replace which is working.
The problem is that I only want to change the line: Bet. kenmerk 123456.
Not the lines which starts with :61: and :81:.
How can I replace all types of line breaks (CR, LF and CrLf) using Regex?
I´ve tried different combinations of "
" and "
" but none finds them all.
formatedString = System.Text.RegularExpressions.Regex.Replace(text, "
", "[Exp 1]")
The following code does the job but it bugs my that I can´t seem to replace the Line Feed using Regexp.
[Code]....
sTitle = Regex.Replace(sTitle, @"&w+;", "")
View 1 RepliesI have a vb.net class that cleans some html before emailing the results.
Here is a sample of some html I need to remove:
<div class="RemoveThis">
Blah blah blah<br />
Blah blah blah<br />
[Code]...
I am already using RegEx to do most of my work now. What would the RegEx expression look like to replace the block above with nothing?
I tried the following, but something is wrong:
'html has all of my text
html = Regex.Replace(html, "<div.*?class=""RemoveThis"">.*?</div>", "", RegexOptions.IgnoreCase)
give me a working regex expression (C#/VB.NET) that can remove single line comments from a SQL statement ?I mean these comments:
-- This is a comment
not those
/* this is a comment */
because I already can handle the star comments.I have a made a little parser that removes those comments when they are at the start of the line, but they can also be somewhere after code or worse, in a SQL-string 'hello --Test -- World' Those comments should also be removed (except those in a SQL string of course - if possible).Surprisingly I didn't got the regex working. I would have assumed the star comments to be more difficult, but actually, they aren't.
As per request, here my code to remove /**/-style comments (In order to have it ignore SQL-Style strings, you have to subsitute strings with a uniqueidentifier (i used 4 concated), then apply the comment-removal, then apply string-backsubstitution.
static string RemoveCstyleComments(string strInput)
{
string strPattern = @"/[*][wds]+[*]/";
//strPattern = @"/*.*?*/"; // Doesn't work
[code]....
Yes, I've googled. But I must defer to the experts as time to study Regex is not available.
[Code]...
Can these 3 lines be condensed into one line? If so, how? The purpose is to remove all spaces before and after all occurrences of & in a string.
I'm having a slight issue and I've been Googling for ~3 hours now but to no avail like my other 2 questions of which the answer was obvious.t will probably be obvious again.Anyway, I want to colour everything after the String 'text2' in RichTextBox1 until the end of the line.'ve been playing around with it a bit but I couldn't get it to work.
Sub:
Private Sub ChangeColourOfWord(ByVal wordRE As String, ByVal Colour As Color, ByVal wordRE2 As String, ByVal Colour2 As Color)
[code]......
what i need to do is open a txt file, read line by line, decode each line into an array and display. Now all works ok apart from one line.
sTextLine = objReader.ReadLine() <-- Value of string cannot be converted.
full code here
-------------
Dim objReader As New System.IO.StreamReader(sOpenFile.Text)
Dim sTextLine As New ArrayList()
Dim sText As String = ""
Dim i As Integer = 0
[code]....
Still getting to grips with regex and have seen a few samples about that give me most of what I need so asking for opinion on this. I need to extract x words from a single line, so the regex could use w+ to get characters, however my line may contain anything inside the word like:
[Code]...
How would i go about reading a file Line by Line that within that line The values are delimited by " Example of the data:
"bob" "cat" "1243"
"steve" dog" "6789"
I've started this with this code but not sure how to go about the next stage:
Using MyReader As New _
Microsoft.VisualBasic.FileIO.TextFieldParser(My.Application.Info.DirectoryPath & "Records28112011.jd")
MyReader.TextFieldType = FileIO.FieldType.Delimited
[code]....
I'm reading a text file with StreamReader, line by line. If a condition is met, then I do an operation and then start reading the file again from the first line. I realize I could close and then re-open the file, but surely this would be very slow.
I could do this easily in VB6, but pulling my hair out trying to do this in vB.net. It seems that 'Seek' is the function to use, but it doesn't work.
I've seen other examples, where it works, but you must open it a different way -- with a file number.
Imports System.IO
Dim I as Integer
Dim LineText as String
[Code].....
I'm trying to read a file line by line into an array but It skips the item at index:3 I have it msgboxing just to make sure and it wont even touch it.
Dim Btn As Button = DirectCast(sender, Button)
Dim path As String = Application.StartupPath & "Libraries" & Btn.Text.Replace(" ", "_") & ".ipt"
Dim i As Integer = 0
Dim lines As String() = IO.File.ReadAllLines(path)
[code]....
I'm having trouble with reading a .txt file line by line, converting it into a string, then putting it into a listbox. When I execute I get an error saying "IndexOutOfRangeException was unhandled" Here is my
[Code]...
i would like to store contents from a text file line by line to arrays before copying them to another text file. what i have is currently like this:
[Code]...
Currently I'm only able to store the whole content into one variable, would like to store the content line by line in arrays.
show me a simple code for downloading a file from internet with a URL,Line by Line with streamreader?
View 6 Repliesthis code takes about 30 mins and high cpu usage, what is the problem
Do
strLine = objReader.ReadLine()
If strLine Is Nothing Then
[code].....
I'm trying to read an .rtf file one line at a time but I'm clearly missing something!The file contains 3 lines and I want each line to end-up in a different RichTextBox, so:
Open File
RichTextBox1 = 1st Line in File
RichTextBox2 = 2nd Line in File
RichTextBox3 = 3rd Line in File
Close File
What am I not understanding? I've tried using LoadFile to load the whole file into another RichTextBox first as I got the impression that RichTextBoxes are indexed - but what I got was strings not .rtf format. I've also looked to see if there's an equivalent of the text-centric ".ReadLine" and nothing seems to fit the bill.
I my old vb6 i use the tipical Open "c:somefile.vbw" For Output As #1 ecc...and loop into txt file line by line....Now i'am new in vb2010i need a little project in vb2010
View 1 RepliesI have to create a new program that reads to Text files. These text files are in the form of a report (with column headings). The purpose is to compare each record line by line to see if their have been any changes made. The record is based on an Account#. Over time these files will be considerably large. What is the best way to do compare records from each file. I'm thinking loading each file into an array and processing them that way.
View 7 RepliesI'm making a program which has 7 textboxes. I intend the program to be used for classes in school, so the text would be like 2D Art, Geology etc... whatever your classes are. I have figured out how to use the streamwriter to take the text in the textboxes and write them to a .txt file however, my issue is with loading the text from the .txt file back into the textboxes. I did figure out how to write it so that all the text in the .txt file is loaded back into textbox1 but I have 7 textboxes... Here's the coding for the Load button:
Private Sub Button46_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button46.Click
Dim MainWindowLog As String = "V:Users(O.o)~(--_--)~(o.O)DocumentsVisual Studio
[Code].....
the best method to read a huge file? I'm guessing its with "stream"?It's like a 200mb file.I need to read each line and do something if the line contains a search string.
Code:Imports System.IO
Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim strFile As String = "c:
[code].....