I'm attempting to parse a text file containing several Windows paths; I'd like to use regular expressions if possible, and I'm using VB.NET.The file is formatted somewhat like so:
M - Network Mode
C:ClientSystem - System Path
C:ClientProducts - Product Path
[code].....
I have a string which i need to parse using Regex class of System.Text.RegularExpressions. I need to find if the first 2 characters of the string are either "00" or "07" or "16" or "23".
View 1 RepliesI'm messing around with regular expressions and I can't seem to figure out how to parse this file.It's basically a lua file containing a table like:
TableName = {
["QuotedString"] = {
["QuotedString"] = {
[code]....
Some things with the file are standard, like the "TableName" (Never in quotes) starts the table. Variables always have [" "] around them and then equal something like ["Test"] = 0. However, the variable could have multiple variables within it. split up the file within each {} and then try to parse each ["QuotedString-Key"] = 0?
I've used regular expressions in the past. I have an app that parses a .csv file and replaces certain characters (commas). Here's an example..
item1, item2, item3, fruits are apples, oranges, grapes. Squash is a vegetable, not a fruit.
What my app does is search each line between character1 and character18 and replace all "," with "~". How this is done through regular expressions?
What I'm trying to do is parse out some links via a google search and fill a text box with said results. This is the code I have in a module which I call upon inside of a command button.
Imports System.Text
Imports System.Text.RegularExpressions
Module Module1
[CODE]...
I have file paths such as:
' Any number of folders before and after the Project name
C:acdProject1efgsomefile.someextension'
[code].....
I am trying to load a text file into a list box in order to be able to play the files see code below I have an error on this line Which states Error 1 Value of type 'String' cannot be converted to '1-dimensional array of String'.
Dim Open As New OpenFileDialog
Dim myStreamReader As System.IO.StreamReader
Open.Filter = "Text [*.txt*]|*.txt|All Files [*.*]|*.*"
[code]....
I am trying to parse the digits to store in a variable from a string in VB.NET (would like to also include the decimal point).
Here is an example string: Refund issued for $27.74
I am trying to remove the tables within an HTML file, specifically, for the following document, I'd like to remove anything within the tags <TABLE....> and </TABLE>. The document contains multiple tables with texts in between.
The expression that I came up with, <TABLE.*>s*[s|S]*</TABLE>s*, however would remove the text in between the tables. In fact it would remove everything between the first <TABLE> and the last </TABLE> tags. I would like to keep the texts in between and only remove the tables.
[Code]....
I'm writing a little web service which generates SO/SF/SU/MSO user flair in the form of an image with various "themes". I find this preferable to using the HTML/JS solutions offered by SO as it's more flexible and also works better in forum signatures.
I'm retrieving the data using the apparently unofficial API (More info here). I can have the data in HTML or JSON. I assumed the JSON would be easier to parse.
Unfortunately, I'm not great at regexes. and the best I can come up with is some very hacky sub-stringing. I believe a regex should be the most elegant solution
regex that matches ID, GravatarURL, ProfileURL, DisplayName, Reputation and Badge Counts (Bronze/Silver/Gold).
FWIW This is to be used in a VB.Net project (in case that affects the syntax at all)
[Code].....
In case any of you are interested, some screenshots of the flair as a work in progress are available here: Me, Jeff Atwood, Joel Spolsky
I need to parse some text to extract the name/path of an image file inside an X file. The part of the file looks something like this:
TextureFilename {
"C:\\Users\\USER\\Documents\\Map\\Textures\\Grass01.dds";
}
[code].....
I occasionally have to search a very large text file as a troubleshooting step. The file is continuous text (with spaces between much of the text) but almost everything is date/time stamped. The text is actually messages between two machines so I'd like to insert a line break after every message so that I can follow the protocol exchange. Thre are also a few key words that I'd like to again, separate with a line break.
View 1 RepliesI occasionally have to search a very large text file as a troubleshooting step. The file is continuous text (with spaces between much of the text) but almost everything is date/time stamped. The text is actually messages between two machines so I'd like to insert a line break after every message so that I can follow the protocol exchange. Thre are also a few key words that I'd like to again, separate with a line break
View 2 RepliesI am trying to pull out a row of comma seperated fields from a text file. I have a combo box which pulls a product number, and what I want it to do it after you select the item in the combo box it will search through the text file and pull everything in that row?
View 1 RepliesI am using VB.NET 2005 (if that matters).I need to parse a text (log) file in which to process lines like:
Program Up at: Tue Jun 24 11:32:53.656 2008 - TerrificProgram.exe
<some lines here which I ignore>
0.00:24:16 - Emergency Stop!
<more lines to ignore>
Program Down at: Thu May 29 22:22:56.000 2008
where the 0.0:24:16 is the offset in TimeSpan format (d.hh:mm:ss) relative to the 'Program Up at" datetime.The 'Program Up at: <date/time>' line I successfully detect (in another function which works) and as a result a set a Boolean flag that I am in a valid <Up> - <Down> sequence and I also set a Start-up DateTime var to which to add the offsets later.
The task is to convert the TimeSpan at the beginning of the 'Emergency stop' line to a regular DateTime expression and to write the converted line to another log-file.Simple, isn't it?The function I use for the above purpose is:
Private Function IsTimeSpan(ByRef InputLine As String, ByVal ProgStart As Boolean, ByVal DTofProgStart As DateTime, ByRef NewDateTime As DateTime)
Dim iLine As String = InputLine
Dim Index As Integer = iLine.IndexOf(" ")
[code]....
What I am doing is I pass each line ('InputLine' parameter) from the original log-file to the function together with the 'in <up>-<down>' flag ('ProgStart' parameter'), the start ot program DateTime (in the 'DTofProgStart') and I want the NewDate to hold the real datetime of Emergency event occurence (not its offset).
What happens is that I successfully detect the lines of interest but the NewDateTime is not updated (though 'ts' is in the correct format and the assignment 'NewDateTime = DTofProgStart' correctly assigns the passed value).Another curious thing is that the line
InputLine.Replace(testStr, NewDateTime.ToString("MMM dd HH':'mm':'ss yyyy"))
does not change the original TimeSpan beginning of 'InputLine' with the regular DateTime (though not updated) in 'NewDateTime'.Why?
Example Data Link - Sorry, wouldnt format correctly when pasted.
1.
Dec 01, 2011
06:00:00 AM
Dec 01, 2011
[code].....
Output something like
12/1/2011 6:00:00 AM 12/1/2011 7:05:00 AM 65 65 2.11
# TAG NAME = is saved to a file using the code below but when I load that same file back into a RichTextbox Control using additional code below, I get inconsistent results as I try to parse the text. Has anyone else had this problem?'Save the contents of the RichTextBox into the file.richTextBox.SaveFile(saveFile1.FileName, RichTextBoxStreamType.RichText);'Retrieve contents of File into RichTextBox control Dim logData As String
logData = System.IO.File.ReadAllText(path + "\" + filenname);
How can I parse a text file and extract the data to excel file. The text file is in the following format
CustomerInformation
Tim Alen
596 George Town
[Code].....
Problem: Current regex pattern does not filter all lines. Adding ^ to the beginning and $ to the ending of the pattern seems to break it as well. If I try it ont gives partial results using options(multiline & case insensitive). Using it in the application returns nothing at all.
View 1 RepliesI have to parse through a text file that is growing and currently is about 30MB, but it takes a long time for the stream reader to load it before It can loop through the lines. Is there a faster method other than the streamreader?
View 2 RepliesI'm running into a problem whenever I try to parse a text file by each line. I know I could use stream reader to read line by line but it is a lot easier to simply use split() and I would also like to know the reason why split() doesn't work.
For example, I created a file "test.txt" and filled it with the following text.
text1
text2
text3
then put the following code in the load event of the form (a button click would work the same).
[Code]...
I'm trying to use VB.NET to parse a very large plain text file (2 GB). It is a database and has a field delimiter of SOH and a record delimiter of STX. I want to separate the fields and records of the file.
I would normally read each line of a text file and then use the split function to separate out the fields. I can't use this approach as there isn't always a delimiter on every line.
Is there any way to read a file until STX is found (rather than one line at a time)?
I am a completeBrenner of vb.net using the below code for download stock price from yahoo finance
but it is difficult to add stock symbol always in code,so I want to use a text file and add stock symbol, A Program will read the text file and [code]...
Part of my project is to retrieve a string variable from an external source (google docs) and parse it. This string represents width and height. I have no problem retrieving, I just need to parse it in to two strings. The string has 4 variations.
Here are examples:
3"x4"
3"hx4"w
3hx4w
3x4
The width is always the first number and the height is always the second. Sometimes, the width and height have decimal points. Any way to parse this into two strings of the numeric values only?
I have written code to pull some data into a data table and do some data re-formatting. I need some help splitting some text into appropriate columns.
CASE 1
I have data formated like this that I need to split into 2 columns.
[Code]...
column is the first 11 characters That is easy.column 2 should contain all the text after the first 11 characters up to but not including the first number.The last column is all the text after column 2
here is a snippet of the file,
Year 1
mandatory
COM137,Mathematics for Computing,20,2
COM140,Computer Technologies,1-2,20
COM147,Introduction to databases,1-2,20
Year 2
[Code]...
in here is where i am having the problem i don't know how to get all the information i need into one specific array element within an array.. i want to get the year and the module status added to the end of an array element
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim StrInput As String = Display.Text
Dim firstInteger, secondInteger As Integer
firstInteger = StrInput.IndexOf("ad_list_link", 0)
secondInteger = StrInput.IndexOf("ad_list_link", firstInteger)
[Code]...
I need to string z from a webpage source file but having trouble cutting the code around it away.
Can I get some assistance please on converting a basic text file into a excell spreedsheet (comma delimited).
I need to take this file that contains[code]...
I want to catch the text from an html page.. you know that when you open any html page in the browser, you will see a text but with formatting.. because it's an html code having a lot of tags...
how to get the text from an html page and ignore all formatting and html code?
[Code]...
My application is supposed to parse a text file (relatively easy) and create an excel spreadsheet report. Should I write a stand alone VB.NET application that saves the excel file, or should I use VSTO? I am unsure if there are any differences in terms of ease of development, usability issues, API functions available, etc.Are there any other programming languages/interfaces/libraries that will allow me to rapidly develop an involved excel spreadsheet? I am talking about things like functions, graphs, etc.
View 3 Replies