Extract Text From .doc File
Here is the first draft of my procedure to retreive but text from a .doc file, but it seems that embeded objets are a real hassle to remove from the text as I have not yet found then starting and ending quotes or chars delimiting the embeded object. I would appreciate a hand on the subject
Code: Private Sub Command1_Click() Dim fichier$, numfile%, textfromfile$, lastpos%, i% Dim Remplacements$, Suppressions$ Dim TabSupp As Variant Dim TabRemp
CommonDialog1.ShowOpen
If LCase(Right(CommonDialog1.FileName, 4)) <> ".doc" Then MsgBox "Ce n'est pas un fichier .doc" Exit Sub Else fichier = CommonDialog1.FileName numfile = FreeFile Open fichier For Binary Access Read As numfile textfromfile = Space$(LOF(numfile)) Get #numfile, , textfromfile Close #numfile
textfromfile = Right(textfromfile, Len(textfromfile) - 1536) 'and here I end up with text and embeded objects, I need to know where an embeded object starts and where it ends to be able to remove it from text 'verification des embed Dim StartPos&, EndPos&, StartCount&, EndCount&, StartChar$, EndChar$
StartPos = 1 EndPos = 1 StartChar = Chr(19) ' EndChar = Chr(20) & Chr(1) & Chr(21)
'suppressions totale Suppressions = "1,2,3,4,5,6,19,20" TabSupp = Split(Suppressions, ",") 'remplacement espaces Remplacements = "7,8,9,10,11,12,13,149" TabRemp = Split(Remplacements, ",")
For i = 0 To UBound(TabSupp) - 1 textfromfile = Replace(textfromfile, Chr(TabSupp(i)), vbNullChar) Next
For i = 0 To UBound(TabRemp) - 1 textfromfile = Replace(textfromfile, Chr(TabRemp(i)), Chr(32)) Next
Text1.Text = Trim(textfromfile) End If
End Sub
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Extract Text From File
[file.1.2.3]: Found: jason/lpz !!!
how do i get:
file.1.2.3 = string1
jason = string2
lpz = string3
How Do I Extract Certain Fields From A Text File?
Guys
Please excuse me for this question, I know there is a real easy answer to this (I hope), but I have spent all day and none the wiser. I also read the I/O Tutorial by Gavin.
I have written a procedure which creates a text file with fixed width records. The data within the file is not delimited and always at a specific location in the file, i.e;
Record1 - "John Smith 10 Alphabet Street Somewhere ACity"
Record2 - "Paul Wilks 4 Forrest Road Anotherplace BCity"
Now I need to read the file, and actually be able to extract the individual parts of the file (like the First Name, Surname etc...) into variables/strings so that when I re-output the file I can re-order it, add/amend data and add delimiters as I see fit.
Im quite new to VB6, and from the Old School of Cobol where something like this is straight forward.
Thanks
Nad
How To Extract Data From A Text File??
Hi. Im relatively new at VB, so still learning. Im trying to build a program that will extract a number from a text file. The file gets populated automatically, with data in the following format.
09:47:18 Order 17000 boxes @ 15.30 for A15 order number 5182348 in regular market.
09:47:18 Trade 13228506 sold 3000 boxes @ 15.30 for A15 order 5182348 remaining 14000 Regular market.
09:47:18 Trade 13228507 sold 5000 boxes @ 15.30 for A15 order 5182348 remaining 9000 Regular market.
09:47:18 Trade 13228508 sold 2000 boxes @ 15.30 for A15 order 5182348 remaining 7000 Regular market.
09:47:18 Cancelled, Sell 7000 PCCL @ 15.30 for A15 order 5182348 in Regular market.
The first line always contains the order details.
The second line onwards contains details of each trade individually.
The last line contains details of any possible cancelled order.
What I need to extract is the total quantity of boxes sold. So from the second line, i need 3000, third line, 5000 and fourth line 2000. So i just need the total, which is 10,000 in this case.
Can anyone give me pointers on how to calculate this value accurately? Thanks a lot.
Extract Variable From Text File
I have an interesting question. I havea text file(.txt) and about halfway through it there a a variable (vr=XXXX). This file is the output of another program and I need to read that variable and assign it a new name.
Any Ideas?
Extract Data From Text File
i want extract data from "sample.txt" and save the data which have been extract to a new text file.
when have "START 129, S",then get the data below it & before the "stop"
for example:
START 129, S, 125=1;156=1;133=300000
100.05062000 3.69064000;49
STOP
START 129, S, 125=1;156=1;133=250000;93=1
100.22346000 2.88787000;43
100.18942000 2.91320000;39
STOP
data after extract is like below:
100.05062000 3.69064000;49
100.22346000 2.88787000;43
100.18942000 2.91320000;39
how to write the code?
Extract Text, Sent To Excel File
I am a bondsman, and I have a text file that is sent to me, sometimes daily. It is in the format of a text file. The problem for me is that each record is 3 or 4 lines deep. I would like to export the data from this text file into an Excel worksheet.
The way the report comes to me currently isn't user friendly the way that it is.
I am expecially interested in the following items.
from the 1st record:
File Number: 06CR 052172
Defendant Name: Xxxxx,Xxxxxx,Xxxxxx
Bond: $2,000 Sec
There may be as many as 300 records to pull this data from.
It is always laid out in this manner. I can not change this.
Thanks for your help.
titans25
I have attached a small sample of the file as I receive it.
How Do I Extract Only Certain Data From A Text File?
At the suggestion of Martin Liss, I've started a new thread for this question.
I have a text file that contains a lot of verbiage, followed by data that is arranged in rows and columns (ala Excel), which is then followed by verbiage and then rows and columns of data and so on. The verbiage can be any length, as can the rows and columns of data also be of any length.
What I want to do is to, when a group of data in rows and columns is detected, take that data and put it into an Excel file, and when the next group of data is detected, place that data into a new Excel file, and keep on doing this until the txt file EOF is encountered.
One issue is that the row and column data can span multiple pages, which means that page headers and footers can be interspersed throughout the data I want to extract.
If I have a group of data that spills from one page to another page to another page and so on, how might I keep all of the data in one file while records are being processed?
I've attached a small sample file for review.
If anyone can help with this overall question, I sure would be happy to hear what you all have to say. Thanks so much in advance!! Looking forward to it.
Extract A Piece Of Text Into A *.txt File.
Hello everybody
I don't know if I need API :
How can I get a piece of text into a *.txt file ?
For example : "The sky is blue, the sun is shine. We are in summer !" give "the sun is shine", for example.
Thank you very much for your answer if you can.
Extract Text From A Binary File
I have a file with a .bsp extension (a Quake 2 map). I know that there is some text I would like to extract from the file, because I looked at it with a hex editor. Before the text in everyone of these files is the word "message" then a space then "<the text i want to extract.>" The maximum length of text that can fit in there is 50 characters, including the quotes. How can I search the binary file, then extract the text and put it in a text box? The text that would be extracted is the title of the map so I want it to be pretty quick. Thanks.
Unzip And Extract A Text File In VB For Excel??
I am trying to unzip a password protected zip file (I know the password and do not have to ask the user) in VB for Excel and from that zip file I want to extract a single txt file which I want to open in a sheet in excel. I am new to VB programming so a very simple tutorial would be great. If anyone has any ideas on how to do this, that would be great.
I have looked at a few other threads on this site that have discussed things like this but the answers seem just to be links to other sites that have complicated solutions. I just want to extract a simple txt file from a password protected zip file (that I know the password to and open it up in a spreadsheet). I would like to do this via a VB macro. Thanks to anyone that can help.
Data Extract From Text File Report
Hi All,
I have a very interesting task. I have a report that gets sent to us every month from the main office in text fromat and it looks something like the attached file and what I need to do is to create something to extract the data and place it in a table which would have the subscriber number, house number, serial or serials (one next to the other) and address.
I have searched everywhere for a data extract application or help but I haven't had any luck. I am hoping that you may have the solution to my very pressing problem.
Thanks a million for any help you might provide.
Manny
http://www.webmanny.com
Code To Extract Data From Text File
can someone supply me with some code to extract data from a text file from its header to the next blank line which would be the end of the section
plz
Extract Text File And Import To Excel In VB6
Hi All,
I have a text file with name, address, phone and some of unuseful line
of text. I would like to extract only name, address, and phone and put them into 3 column in excel.
My general approach is
1-Open text file and read start a loop to read in one line at a time.
[syntax??]
2-Search for key words(Name, Address, Phone) the imply the desired
string to extract [how do I "if line contains "Name" then...??
Put them into a variable string or array [syntax??] Leading blank space
may cause the error. [syntax?]
3-When all desired data is collected, write them in an excel column.
As you can tell I'm new to VB. Any and all help appreciated.
How Extract Data From Text File And Write It To Db?
Hi all .i got the following data inside text file:
[code]
<?xml version="1.0" encoding="UTF-8" ?>
<player showDisplay="yes" showPlaylist="yes" autoStart="yes">
<song path="http://www.mysite.com/TtdlI3l1lIl0OOO0a/singer1/album1/song1.mp3" title="song title" />
<song path="http://www.mysite.com/TtdlI3l1lIl0OOO0a/singer1/album1/songname2.mp3" title="song title 2" />
</player>
<?xml version="1.0" encoding="UTF-8" ?>
<player showDisplay="yes" showPlaylist="yes" autoStart="yes">
<song path="http://www.mysite.com/TtdlI3l1lIl0OOO0a/singer1/album3/song3.mp3" title="song title" />
<song path="http://www.mysite.com/TtdlI3l1lIl0OOO0a/singer1/album4/songname4.mp3" title="song title 2" />
</player>
.....
.....
[/CODE
. I am looking for a way to ripp the song path and title from it and use them and insert them to mysql datbase. But i do not know how to ripp those part .i be happy that an expert tell me how i can do it using vb6. The number of player info blocks are not know in before and the parts
that i want to write to mysql are shown in bold.Thanks
How To Extract Specific Text From A BLOB File
Hi folks
I have several large BLOB files from a Uniface application which contain text and junk characters. I need to extract certain pieces of text from the BLOB file. Is this possible using VBA using either Excel or Access (versions 2003)?
Here is a small portion of one BLOB file:
ENTRY_LINES=SECTION1=N026F005_SECTION=1N026F015_WEEK_NO
=N026F020_TIME_TYPE=WORKN026F022_ALLOW_TYPE=N02
6F025_DATE=20051229N026F030_TIME_FROM=0000000005300000
N026F035_BREAK_FROM=0000000010300000N026F040_BREAK_T
O=0000000011000000N026F045_BREAK_HOURS=N026F050_TIM
E_TO=0000000016000000
In the above example the text "N026F025_DATE=" occurs many times. I need to extract each instance of that text and the characters after the equals sign (which in most cases are different).
Any hints would be greatly appreciated.
Regards. Doogster
It Is Posible To Extract Formatted Text From A PDF File?
does anyone know how i can extract text from a PDF file (actually a report converted to PDF)?
i got many PDF files (reports) with 132 characters lenght per line
if it posible can i create a TXT file reading and writing line per line and preserving its format, even the spaces?
i need to read the reports to fill a data base file and use the data from the differents fields to get some statistics
help please
Text File W/ No CSV - Need To Extract Data And Create Excel Spreadsheet
I have several text files in different formats from which I need to pull specific data out of and export that data into an Excel spreadsheet. Please HELP! Below is an example of one of the files:
-----------------------------------------------------------------------------------------------
1 INVESTOR INVESTOR DUE BAL/ PRINCIPAL P&I
OUR LN NUMBER BANK CAT LOAN NO DATE PAID TO BALANCE CONSTANT
1 ANN INT S F RATE
--------------------------------------------------------------------------------------------------------
1234567890 J48 099 345678901 11-01-06 40.40 234,456.78 2,148.48
.0575000 .00375000
2345678901 K49 079 456789012 12-01-02 45.67 345,678.90 3,456.78
.0475000
Better yet, take a look at the attached sample txt file.
Edited by - notesbiz on 2/22/2004 2:06:24 PM
How To Extract Text Or Group Of Text From A Source
for example I have the following data in my variable....
a = "This is a Test text to extract by the program"
then I want to get the character from Test to by is there a faster way with out using the len, mid, left function of vb.
Like php regular expresions...
Extract Text
A single cell contains city and date. vb: etten-Leur, 29 januari 2004
I want to extract/delete the city name (etten-leur), i want to keep the date as a string.
thnx in advance.
Werner
Extract Text From Txt
Hello,
I am tryng to extract lines from a text file to a buffer, where the text lines should be analysed to look for server names inside the text.
I try to make a Loop extracting the line, looking for these contents and so on, but I haven,t yet accesed the file.
Could you help me?
Thank you!
the code:
Code:
Dim strFileName As String 'String of file to open
Dim strText As String 'Contents of file
Dim strFilter As String 'Common Dialog filter string
Dim strBuffer As String 'String buffer variable
Dim FileHandle% 'Variable to hold file handle
strFileName = "login_History.txt"
'Get a free file handle and assign it to the file handle variable
FileHandle% = FreeFile
'Open the file
Open strFileName For Input As #FileHandle%
Seek #FileHandle%, 2 ' Position festlegen.
'Make the mouse cursor an hourglass
MousePointer = vbHourglass
'Traverse the lines of the file
Do While Not EOF(FileHandle%) ' Check for end of file.
'Read a line of the file
Line Input #FileHandle%, strBuffer ' Read line of data.
strText = strBuffer ' Write the variable to analyze
' HEre must the code to seek for this server names
Loop
'Change the mousepointer back to the arrow
MousePointer = vbDefault
'Close the file once you have had your way with it
Close #FileHandle%
'Put the file name in the form caption
End Sub
Opening A File, Extract Data And Send A File Via Infrared
Dear Friends,
I am new to this forum and also new to Visual Studio. I need to produce a program which does the following...
1.Use System File Watcher to know that a file has been received in a particualr directory from a mobile phone.
2.Open that file with notepad (the file is not opened by notepad by default), Find the word 'Body:' and save the string found after it.
3.Send via infrared, a file '.jpg' loacated in a particular directory with the same string name as the one stored.
Can you kindly suggest to me some coding?
or at least some website where I can get some tips, tutorials, help.... Cause I don't have the MSDN help installed!
The coding I require is on how to open the file (which is arrived and systemfile watcher noted) with notepad..and how to extract data from it.
Thanks,
Franklin
Extract Text From Textbox
text box 1 = "random data here (30%)"
i need to extract the data inside the ( ). so remove all the data apart from the number.
cant be done with replace as the data will change all the time
To Extract Screen Text....Need Help
I have basic knowledge of VB and and I need help to do something complicated here:
My company had ported a legacy dos application into a full win32 program while retaining the same look and feel (80 by 25).
I am trying to develop some VB programs that could extract the text from this app (there is no copy function available at all) for other use. How could I go about doing it to intercept the text that are being displayed on screen? I read something about subclassing or window message, but have no clue on how to proceed.
Any pointer is highly appreciated
Extract Text From String?
How qoudl i extract the text between the <> and between ><
Example..
this is my string of text..
<Initialize>Text1</Initialize>
I want to get the text from between <Initialize>
&
Then i want to get the text from between >Text1<
and have them as two seperate variables?
How To Extract Text From A String?
hello once again,
just wondering how can i go about doing this?
i have a common dialog popup whenever someone clicks "cmdBrowse"
once a file has been selected, it is displayed in a text box (txtFileName) and also it is stored in a string called "strFilename"
so for example, i click "cmdBrowse" and select a file called "MyPage.html"
the text box (txtFileName) and strFilename now contails "C:LocalDirectoryFile nameMy Personal FolderFor UploadsMyPage.html"
how can i (either from the string strFilename or the textbox txtFileName) get just the "MyPage.html" part?
thanks for the help,
-BC
Extract Part Of Text
I need to regularly extract parts of a filename.
An example is: abdfg.uniEmail.123456345.smi98765file.zip
The bits i need to extract are the 123456345 andsmi98765 which are then dropped elsewhere.
The actual text is unique each time and i cant use (mid) or (left) etc because the length of the filename varies.
Grateful for some help.
How Do I Extract A Piece Of Text From A Text Box
Hi, I am trying to write a part of my program that displays text in a box. From the text box I want to extract the 4-8 characters of the first line. This data will then be output to a message box. Any idea's?
Or, I am reading a text file into the text box, could i just read the fist 8 characters of the file and just ingnore the first for and outout these to a message box?
Extract Text From Table In Word
Hi,
I've been skimming through the threads and couldn't find QUITE this question.
I have a word document, with text and tables here and there (I don't know where they are in the document - they're spread throughout it).
I want to know:
1) How can I find the first table, then the next then the next etc...
2) Can I just collect ALL of the tables in the word documents into one object?
3) Once I find a table, how can I extract text from a specific cell in it.
Maybe go over ALL the rows then ALL the cells and look for the text.
How can I do that?
Thanks a lot people!
You're great!
- M00gl3
Extract Numbers From A Text String
Hello,
I have a text string in a cell of Excel like this:
peter jones 25, john irving junior 33, frank zappa 28
I want to extract the numbers of this string and put them in separate cells like this:
Cell A1 25
Cell A2 33
Cell A3 28
I tried to use the function ExtractElement (from J. Walkenbach), but the problem is that there is not a unique separator in this string. Sometimes two spaces like in john irving junior and not always a comma like in frank zappa.
Does someone know how to identify numbers from text in a string so I don't need to use a unique seperator?
Thanks a lot!
regards,
Marcel
Extract From Text - Loop - Shortcut?
I'm using the internet transfer control to bring a url's text content into a variable m_strHttpResponse This variable contains plenty of extraneous data and some parameters that I need.
variablem_strHttpResponse contains [1.5 k of data not required, then...]
><OPTION VALUE='296341' SELECTED='y'>Mcgruders Cross<OPTION VALUE='260220'>Move Yourself<OPTION VALUE='239175'>Like A Bee<OPTION VALUE='326992'>Native Prague<OPTION VALUE='326993'>Loulou Nivernais<OPTION VALUE='53390'>Lord Mandari</SELECT>[the 0.5K of data not required]
I'd like an array that contains:
Col1 Col2
row 1 296341 Mcgruders Cross
row 2 260220 Move Yourself
row 3 239175 Like A Bee
row 4 326992 Native Prague
row 5 326993 Loulou Nivernais
row 6 53390 Lord Mandari
Is there a shortcut anyone knows of to acheive this please?
Extract And Save Desired Text ?
Hello,
Please check info.txt
I need to extract only some part from loaded text and save to another text...
sample:
I: { www.yahoo.com { xxxx xxxx { forwarded { M0 M0 }}}}
I: { www.google-split.org { xxxx xxxx { forwarded { M0 M0 }}}}
I: { eddie.murphy.com { xxxx xxxx { forwarded { M0 M0 }}}}
I: { users-online.org { xxxx xxxx { forwarded { M0 M0 }}}}
OK, I have download from server txt like this above, and now
I need to save it to other file and extract only this:
###################
www.yahoo.com
www.google-split.org
eddie.murphy.com
users-online.org
###################
Extract Text From DHTML Editor
I want to extract the text selected from a DHTML editor control, inserted in a form. This text must be contained in a variable one of type string. it is possible to make it?
(ex: SelText)
Help me please
Extract Text From Word Document
Hello all, I was wondering if anyone knows how to extract the text from a word document. The format is not important but I wish to reatin the whitespace, (tabs, spaces, newlines).
I've found lots of examples on how to save and create a word document but nothing on extracting text. Thanks for your help.
Can You Extract Highlighted Text Using An API Call
I need to determine what text has been selected in a document, either by clicking and dragging the mouse or by using the keyboard. Is there an API that returns this information? If so, can I retrieve line numbers or character counts as well?
Thanks for any help and/or suggestions.
Have a great day!
j2consulting@yahoo.com
Extract Text From Word Document.
Hi,
I would like to write a class in VB 6.0, to extract text content from MSWord documents. Can anyone give me inputs on how to do this ?
Thanks!
Extract Html Text Under Mouse Pointer
Hi,
I need to get the word/paragraph under the mouse pointer in a web page displayed by Internet Explorer.
I managed getting the handle of the IE window and the mouse pointer location.
I also have the className and handle of the main display area of the internet explorer window ("Internet Explorer_Server") but from that point - how do I access the html content and its position?
Thank you very much
How Can I Extract Text From A Word Document TextBox
i have been working on word Document files.
each document has same text format.
i m using the code below to extract text from it,
Code:
Dim sFileName As String 'Name of files within the folder will be stored
Dim i As Integer 'This will count the files read***
Dim wrd As Word.Application
Dim wrdCount As Long 'Number of characters within the file
'Get the first file with extension "DOC" ***
sFileName = Dir$("C:Virology*.DOC") '***
Do While sFileName <> "" '***
Set wrd = New Word.Application 'Create obj of word application
wrd.Visible = False
wrd.Documents.Open "C:Virology" & sFileName
wrdCount = wrd.Documents(1).Characters.Count
Text1.Text = Text1.Text & vbCrLf & i & wrd.Documents(1).Range(0, wrdCount).Text
wrd.Documents(1).Close
Set wrd = Nothing
sFileName = Dir$ '***
i = i + 1
Loop
This works good for all the characters in the document but the problem rises when word textbox appears in the document.
Extract Unicode Values From Rich Text Box
Internationalization and the display of Japanese characters seems to crop up from time to time on this forum but I have yet to find a solution that does not use the Forms2 object library (which you are not allowed to distribute).
Well, I am close, very close, and when completed I will post the complete solution for others to share.
In order to make the final step, I need an answer to the following :
I have a rich text box containing Japanese characters.
These are displayed correctly in the rich text box.
I need to get hold of the Unicode values for each of the characters in the rich text box.
Any help greatly appreciated.
Extract Text From Edit Control Of External App
There are two possibilities here that i know about:
One, somehow SendKeys Ctrl-C to copy a pre-selected area (I have gotten as far as Selecting wanted text)
Two, somehow SendMessage something to grab the text.
The original program is not mine, was built with C++ 6, and I already have the hWnd of the control, as far as i can test. Also, ResHacker reports that the Control is of class EDIT.
Any Ideas?
Programittically Download A Zip File And Extract The Csv File Into A Bcp
This is a pretty tough one. There is a website PJM.com that contains energy pricing data in csv format. The file names are by date, ex. 20001129-da.csv The da is for Day Ahead pricing. the way the program is designed, based on the date, it creates a file with the same as the one the web site that is going to be downloaded into. The pprogram then takes the data from the website and inputs it into the file that the program creates with the same name using msinet.ocx and inet1. THIS WORKS JUST PEACHY.
The problem I am having is that past data is zipped up into a directory that contains 4 subdirectories and finally the last one contains the file. I am not sure how write a program that will extract the data from that zip so that it will be stored in the root directory where all of the other csv files are contained. I need some serious help on this one. Thanks in advnace.
Mike Reese
Web App Developer
Sunoco, Inc
Extract Data From Text Files Based On Batch ID
have several text files found on the folder C:My Reports. I need to extract all datasets (from <BATCH> field up to the <XPNO> field containing a specified batch ID number. For example, I need all datasets bearing the Batch ID 3413. A new text file (filenamed 3413.txt) is created containing all datasets containing the batch field with a value of 3413. One text file could have more than one dataset such as in the example below.
<BATCH> 3413
<PNO> US2004123343-A1
<TI1> Title of the Invention (up to 240 characters)
<NOV> Novelty of the invention (up to 450 characters)
<OTH> Other Contents (variable)
<USE> Uses of the Invention (variable)
<XPNO> US2004123343-A1 (same value as the PNO field)
<BATCH> 3413
<PNO> US2004123350-A1
<TI1> Title of the Invention (up to 240 characters)
<NOV> Novelty of the invention (up to 450 characters)
<OTH> Other Contents (variable)
<USE> Uses of the Invention (variable)
<XPNO> US2004123350-A1 (same value as the PNO field)
<BATCH> 3427
<PNO> US2004124110-A1
<TI1> Title of the Invention (up to 240 characters)
<NOV> Novelty of the invention (up to 450 characters)
<OTH> Other Contents (variable)
<USE> Uses of the Invention (variable)
<XPNO> US2004124110-A1 (same value as the PNO field)
Can anyone help me get started here? Or do you have an idea how to set this up?
Thanks
How Can I Extract A .RAR File Using VB6??
Hi every1..
It's really nice to be here.. well i'm a new mmbr in here, n i got a little question..
How can i extract what's in a .RAR file using VB6??
could any 1 plz help??
thanks..
Extract From File
ok I'm trying to extract information from a text file which i do not know the length of. the first line reads
" Todays highest temperature is 23 C 24/01/2004" (there could be numerous lines ) each with different temperatures and also the dates will be different 'cos you input the temperature everyday.
this code does some of it can i use a loop do extract the data i need,
also not quite sure how to fill the temperatures and the date into arrays?
here is my code:
VB Code:
Dim String1 As String ' textfileDim sNum() As Integer ' array to store the temperaturesDim sDate() As Integer ' array to store the datesDim Num As IntegerDim sString As String ' temp temperature store String1 = Text1.TextString1 = Replace(String1, " Todays highest temperature is ", "") ' remove this sentenceString1 = Replace(String1, "C", "") ' remove CelciussString = Mid$(String1, 2, 2) ' extract first number which is the temperatureNum = CInt(sString) ' convert string to integer String1 = Replace(String1, Date, "") 'remove dateDebug.Print NumDebug.Print Date frmChart.Text2.Text = String1 frmChart.ShowEnd Sub
Extract From WP 5.1 File
Hi All,
I want to extract some lines from WP 5.1 documents and write the extracted lines to a CSV file for future import in a database or Excel file. All WP documents is build of several pages – and each page contains one (1) table with different structures. The lines I want to extract from, are all the rows that include 7 columns and where the first columns first character are a digit. Each row must be written as a line where the contests of each column are separated by semicolon. I don’t want to run or open any other programs then my own VB-app. If anyone know how to do this I would really appreciate the help! Thanks in advance!
Marci Sarwan (marci_sarwan@yahoo.com)
P.S. If it's not too much trouble can you please provide some sample code with the solution. Thanks a million!
Extract Zip File
Hi,
Is it possible to extract a zip file from visual basic application ?
thanx,
pokpoki.
Extract Image From File?
I'm looking into using DirectDraw for a skinnable program (yes, it's probably overkill, but it works so well) but I want the skin to be a single file and let it contain multiple images (so I only load in memory the ones I need) and also values for colors, text, and other information. I'm new with DirectX and I've used the CreateSurfaceFromFile to create a surface, but I really don't want to extract the image, save it to a temporary file, and load it in. I'd rather load it from a binary red directly. Is there a way I can get DirectX to see information in that sense as an image?
|