I am trying to extract a number from a specific line and finding it an arduous task.
-#comments">18 comentarios</a></span>
I need the number before the word commentaries. This is a common phrase to search for and extract. the start of the line varies.
My text file look like this[code]...
I want to extract those lines according to value in ( ).
I am trying to figure out how to replace text in a text file on a specific line number. (for testing, line number 4).
View 6 Repliesi am a beginner in vb8 i have a text file named alarm.txt,sample alarm.txt file is shown below
can someone help me to read the alarm.txt file and extract data.for eg
[Code]...
i have a log file which contains hundreds/thousands of seperate XML messages and need to find a way to extract a complete xml message depending on the parameters given (values of nodes).My biggest problem is that even though i program a fair amount i have had very little contact with XML or the XML libraries of the languages i use and didnt think that a simple text parsing would be an elegant solution!I am going to attempt this in C# or VB.net
View 3 RepliesI am trying to extract a specific bit of text from a xml file. The file is located in C:Testspac emp1.xml and the specific text is between <space></space>How do I go about getting this text and displaying it in a textbox.
View 2 RepliesI know how to extract an entire page source into VB.NET, but once I do that how do I make VB.NET search the text and return a specific vlaue that is not constant? Take this line from the page source for example:
[Code]...
GND P3559 9812, 7993 p9910.26;
GND P3559 9812, 7993 p9910.26;
46N93 P594 40898, 35899 39MIL;
PHY2_P2_CONFIG0 P2767 34205, 33537 39MIL;
[code].....
i have write all this value in another text file by adding the title.in my original file's line i must check whether the line contain any MIL value if not, I must write first T1 the below T1 i must write all the line which not contain MIL value until i reach a line which Contain MIL value. If the line contain 39MIL the i must write first T5 then followed by all the line which contain 39MIL until it reach the line which contain another MIL value. Let say 50MIL. the i must write T7 then followed by all the line which contain 50MIL. I sort my original file alredy. so the original file will start from the line which dont have MIL to 39MIL,50MIL,75MIL and 100MIL. Mu output file will look like this
GND P3559 9812, 7993 p9910.26;
GND P3559 9812, 7993 p9910.26;
[code].....
I need to extract specific data from a database. With starting point in this data, I will collect information on the internet. After the information is collected I need to check if this information is already stored in the database, and if not, then add it. This action is being repeated about 500-50000 times each time the procedure is being executed. (not often)
The approach I'm taking seemes sleazy and ineffecient and I was hoping you could point out some places where I might be able to optimize it. I've two open connections at the same time. The first I use to extract data, and it stays open throughout the whole session. The second connection is being used first to check if an entry already exist and if not, to add the data.
The reason I am using two connections is due to the fact that I got a reader bound to the first one, so it is rendered unavailable.
I was thinking that maybe checking if the data existed, and adding it if not, maybe could be contracted into one command execution instead of two. I don't know if it would be possible to do this with one connection only as well, as it seemes more proper.
My problem is to extract some specific string from the web script by RegExp, e.g:
1. <TD title="ABC - SDC">Home Furniture</TD>
- I want to extract "Home Furniture" from here.
2. <TD><INPUT class=ID="( 8352623 ) Demark" value="( 8352623 ) Demark"></TD></TR><!-- <tr> -->
- I want to extract "8352623" from here, can be any of them.
How can I write a RegExp to match them?
And I am getting one solution but work out in C#, obviously it's not working in VB, so anyone does me a favor to translate them in VB structure...
string pattern1 = @"<([tT][dD])[^>]*>(?<between>.*)(?=</1>)";
string test1 = @"<TD title=""ABC - SDC"">Home Furniture</TD>";
if (Regex.IsMatch(test1, pattern1))
[Code]....
Imports System.Globalization
Imports System.IO
Public Class Form1
[Code]....
I have found the above code from the net and it works fine as I would expect. I know this because I have added a put the String StoreFile into a text box and it worked. From what I understand about the code above is that we are reading the file test.txt until we reach the end of the file and we are storing it into a string.
What I would like to do is either:
1. Search the String StoreFile until I find the text of my choice, and then extract the characters around it. See attached txt file.
For example, if I wanted to search for MNAUSD in the attached txt file, I want to grab the values on the line (highlighted in blue) and make them available to my program and ignore everything else.
"MNAUSD",UNITED STATES,US $,M,1.558850,1,1.369850,1.113500,L
I know these files are comma delimited, but I would rather use a regular expressions if possible as I have other files that are not comma delimited, so it would be ideal if I have a regular expressions to handle the search and extract
OR
2. Search the File test.txt LINE BY LINE, until I reach my search text MNAUSD and then extract the same values as above.
There have probablly be thousands of threads just like mine[code]...
View 1 RepliesI have a Word document that has font sizes of 14 and 18, and the document is of 1500 pages.
I have to make specific changes to the font 14 and font 18, and so after searching, I came across VBA for Word that would allow me to do this easily.[code]...
I know how to extract an entire page source into VB.NET, but once I do that how do I make VB.NET search the text and return a specific vlaue that is not constant?
Take this line from the page source for example:
<td id="actualPriceContent"><span id="actualPriceValue"><b class="priceLarge">$4.30</b></span>
the text is always constant but the price is not - how do I make VB.NET return the price?
how to parse and extract specific elements out of a JSON that I obtain from a web source. Using Visual Studio 2010 and VB. I can get the JSON but I haven't been able to find any examples or tutorials regarding parsing the data, locating specific elements and their associated data.
View 1 RepliesIs there a way to show the line number of the line of code that caused an exception within a Try...Catch block?
View 5 RepliesI got the following code from codeproject.com:
Dim objOL As Outlook.Application
Dim objNS As Outlook.NameSpace
Dim objFolder As Outlook.Folders
[Code].....
Now, I got as far as making the default folder the Inbox. What I would like to do is to extend the functionality by retrieving only a specific person's emails and extracting and saving whatever attachments he/she sends. Also, I get the following error when the code reaches the Dim Atmt as Outlook.Attachment part: Public member 'Attachment' on type 'Object' not found. I need this function to retrieve the attachments. I've tried different things, but nothing's worked.
I have a parse from Wikipedia saved in a text file in the following form: The town itself is situated to the south-east of the rock, and overlooks the Palaia Monemvasia bay. A small hamlet with about 10 houses lies to the northwest.The founding of the town and fortress of Monemvassia most probably occurred in the 6th century AD. The town was founded in 583 by people seeking refuge from the [[Slavic peoples|Slavic]] and the [[Eurasian Avars|Avaric]] invasion of Greece. From the 10th century AD, the town developed into an important trade and maritime centre. The fortress withstood the [[Arab]] and [[Normans|Norman]] invasions and conquests in 1147. Cornfields that fed up to 30 men were grown inside the fortress.What I need to do is to extract specific texts from the parse given the header names. For example, if I type in a textbot Geography I need ONLY the geography text returned.
View 8 RepliesDoes anyone knows how to export/extract/copy (or whatever is the right word) a file wich is added to the soulution, on the startup of a program, like somekind of installation?
View 5 RepliesHow do I limit the number of characters per each line of an RTB to 1 char per line? That is you type one character, after that the textbox should not accept further input on that specific line.-Knock knock -Who's there? -(looong pause..) Java
View 1 RepliesHow do i load a specific or a couple of line(not full file) to a RichTextBox by its line no...
For Example if i want load line 14...
Or sometime line 14-18...
Suppose I already know the line number such as row 100 in a text file. How can I directly get it without many codes?
Code:
.....
99 Dim s1 as String
100 s1 = "Test"
101 MsgBox("Test Ok")
[Code]....
I dont know my programing language, how do i find out?[code]...
View 1 RepliesI have a string in the following and want to extract each number from the string.
dim s as string="10,20,30,40"
dim a as integer
dim b as integer
[code].....
I have been trying to get a number out of a text with a number in brackets ending at the back.e.g. Cakes (20)Trying to get the number 20 which is in the bracket out with String.EndsWithI tried with the following code in a few different ways and still can't get it.[code]...
View 5 RepliesI have a string, specifically its "Ballpen $10 x 3pcs"i want to extract 10 and 3 then multiply it so i can get the total of 30$,i tried using regexp but im too noob with it
View 4 RepliesI am searching for a best practice for Incremental Line Number generation i.e in an Invoice application. I am using VS2005, Sql2005 as a development environment. I need to create autoincremental line numbers for an invoice. I dont want to solve it in Database.
[Code]...
I have this stored in Varible (History)
Date Open High Low Close/Last Volume
12:35 0.0004 0.0007 0.0004 0.0007 84,556,352*
01/21/2010 0.0005 0.0005 0.0004 0.0004 21,650,660
01/20/2010 0.0004 0.0005 0.0004 0.0005 8,030,977
01/19/2010 0.0005 0.0005 0.0004 0.0005 22,396,206
01/15/2010 0.0005 0.0005 0.0004 0.0005 15,749,998
How do I extract each line and store in Array (fhistory(6) ?
I want to fetch number from my string
[Code]...
I have a question about how to get a button to check for a textbox contents, and then compare that with data in my fairly simple database (It's meant as a login procedure).
Here's my database:
It has 2 values, 1 for the manager and 1 for the Admin
Here's my Login screen:
Now...
Everything works just fine, all the code is correct so all the buttons work. For the program i'm making, there's 3 types of users, 1 user who can only change how much money a customer owes the company, 1 user that can add new customers and other little things and one Admin who can change pin numbers and manage backups and stuff like that. For the last 2, i need pin-number/password protection obviously.
The user should enter the pin and then press ok, after which the ok button checks if the pin number the user entered, corresponds to either identifier 1 or 2 (5566 or 6655 for now) and if correct, show the user the next form.