Over 1 million tech questions and answers.

How 2 import text data into Excel from scanned text file ?

Q: How 2 import text data into Excel from scanned text file ?

Good morning / Good afternoon
As a newbie I am making the first posting on your forum and I hope it is not a silly question.

I received a hard print of an excel spreadsheet with data in 9 columns (2 date formatted and 6 number formatted) of figures from my by bank and I wish 2 use them for further calculation. As I didn't get an electronic file from the bank I scanned the data sheet on the HP Scanner into text files ( rich text, plain text etc) and attempted to import the text into Excel; but I was unsuccessful. Have I attempted the impossible or did I do something wrong ?

If it is possible to do so how should I proceed ?
With thanks, anothernub

RELEVANCY SCORE 200
Preferred Solution: How 2 import text data into Excel from scanned text file ?

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: How 2 import text data into Excel from scanned text file ?

Read other 12 answers
RELEVANCY SCORE 110.4

When I import a Text file into Excel (through Data > Import External Data and go through the Wizard) the data comes across correctly in the right columns etc. - I'm ok doing that.

The numbers and/or currency in my data do not seem to "work" properly as when I try to do calucations (such as a simple autosum) the answer always comes back as 0.

I've tried re-formatting the data as numbers/currency but this doesn't help.

I've also tried multpiplying the numbers by 1 (using Paste Special) to get them to re-format but this doesn't help either.

Any suggestions?

Thanks!
 

A:Import Text file to Excel - number format

Hi there, welcome to the board!

They could possibly have leading and/or trailing spaces. A couple of ways to handle that. Download/install a free add-in called ASAP Utilities, which you can access from (assuming Excel 2003, which is what it sounds like) ASAP Utilities menu, Text, Delete leading and trailing spaces. The range must be selected first. Another way would be to write your own macro to do it. If you don't have ASAP I'd highly recommend it, as it gives you additional tools and resources not native to Excel, making your life in Excel much easier.

An easy way to check would be to use a blank cell (generally adjacent column) and enter the formula =LEN(A1), where A1 references the cell in question with your numbers. No doubt they're numbers stored as text. If you've done the paste special then there's nothing to force to numerics. The other way to do that would be to select everything and to Text to Columns (from Data menu), and just click the Finish button (not going through the Wizard), which will also force (coerce) numerics stored as text to numerics.

HTH
 

Read other 1 answers
RELEVANCY SCORE 102

Hello Everyone, Its my first post here :-)

I have a text file with values printed like these;

BSSID: 001E4ABXXXX
Last seen: 14/12/2011 - 16:06:12
Vendor: Cisco Systems
Signal: -91 dBm
SSID: NXXXX
Enc: OPEN
Mode: Infrastructure
Channel: 1 (2412000 Hz)
Rates (Mbps): 11, 12, 18, 24, 36, 48, 54,
Packets: 25
Unique WEP IVs: 0

BSSID: C03F0E3XXXXX
Last seen: 14/12/2011 - 15:57:27
Vendor: NETGEAR
Signal: -96 dBm
SSID: Misuss
Enc: WEP
Mode: Infrastructure
Channel: 1 (2412000 Hz)
Rates (Mbps): 6, 9, 12, 48, 18, 24, 36, 54,
Packets: 7
Unique WEP IVs: 0

BSSID: 001E4ABXXXXX
Last seen: 14/12/2011 - 15:56:49
Vendor: Cisco Systems
Signal: -95 dBm
SSID: Mobile
Enc: WPA2-CCMP-MGT
Mode: Infrastructure
Channel: 1 (2412000 Hz)
Rates (Mbps): 11, 12, 18, 24, 36, 48, 54,
Packets: 2
Unique WEP IVs: 0



I want to export this all to an excel spreadsheet with columns representing BSSID, Last Seen, vendor, Signal, SSID, Enc, Mode etc., and all the values belonging for an BSSID in a single row. Does it look doable? If yes, please let me know how to achieve this, and I will be highly obliged.

Much thanks!

Sid

A:Please Help - Data in Text File to be arranged in Excel in a specific

First, two questions: how proficient are you with Word and Excel? Are you comfortable using the REPLACE function in both?

If reasonably proficient and comfortable (understand) with the REPLACE function, it isn't difficult and will take about 15 minutes to accomplish what you seek.

Open the text file in Word.

Turn on the SHOW ALL switch (the paragraph mark icon).

Your post example has MANUAL LINE BREAKS after each line - if the source file has them, replace all of them with PARAGRAPH MARK.


Add a PARAGRAPH MARK (Enter) at the very beginning of the document.


Replace DOUBLE PARAGRAPH MARKS with PARAGRAPH MARK, hash mark (#) - makes it easier to see what you are doing next - and PARAGRAPH MARK like this:

Find what: ^p^p
Replace with: ^p#^p

Now add the tilde (~) in front of each line:

Find what: ^pBSSID:
Replace with: ^p~BSSID:

Repeat for each line of a record (total of 11 times).


Delete all of the hash marks (#):

Find what: ^p#^p
Replace with: ^p


Now your records are:
> Separated by a carriage return (paragraph mark)
> Fields are separated by the tilde (~)
> The first imported column will be EMPTY

Save the txt file and close Word.

Open Excel.
Open file type: All Files (*.*)


Select your text file.

In the import steps:
Step 1: Delimited
Step 2: deselect Tab and select Other, set to ~

Click FINISH.

Insert a header row and label each column.

Select each colum one at a time and delete the corresponding record field leaders. Be... Read more

Read other 2 answers
RELEVANCY SCORE 102

I have an excel file with the current scenario:

A12 - this cell uses a CONCATENATE formula (from other cells) to create a directory structure and file name (example- C:\project\vendor\41576_info.txt). The directory structure already exists. The the *.txt file does not exist.

I would like to use a VB macro that will create the new text file in the specific directory and add any content in cells A13:A17 to the text file. Any suggestions on how to do this? Thanks in advance

PS - I did try to look through previous posts but the search function was retuning errors.
 

A:Solved: Saving Excel Data to a text file

Read other 6 answers
RELEVANCY SCORE 100.8

Oh boy here we go again! I have PAGES of documents that were scanned to pdf and I need to convert the data on those pages to text to put into an excel file. HELP!!!

Anything is appreciated. My hand is cramping up just thinking about typing it all in word by word.....

JJJ
 

A:Convert scanned pdf documents to text for excel

Read other 9 answers
RELEVANCY SCORE 100

This format is necessary for importing data files into HandiLedger systems.

Can anyone please give me a step-by-step explanation of how to achieve this.
 

A:how to convert excel data to ASCII comma delimited text file

you should be able to save as CSV - Comma Separated Value . which will produce a comma delimited file

ASCII is how a computer uses characters
so a letter
A in ASCII can be a number of different codes , depending on what the computer uses
I used to work on computers that uses octal numbers
The octal numeral system, or oct for short, is the base-8 number system, and uses the digits 0 to 7.Click to expand...

and an "A" was 101
I dont know if you are trying to change the letters and numbers into ASCII code
this maybe HEX base 16
The hexadecimal numbers are 0-9 and then use the letters A-F.Click to expand...

Here is a table of ASCII codes
http://www.asciitable.com/

if you had
cell A1 with
H and
A2 with 20

did you want to show
H,20
or
change the H and the 20 to an ASCII code
say HEX
48,4
 

Read other 1 answers
RELEVANCY SCORE 98.8

I need to convert Excel data into ASCII comma delimited text file format. I know that if I save as csv. that the data can be pasted into Wordpad with the comma delimiter, but how do I get the quotes around the data fields?

Any help would be appreciated.

Thanks
 

A:Converting Excel data to ASCII comma delimited text file format

Read other 9 answers
RELEVANCY SCORE 96.4

I was recently asked to enlarge some print of some poems that are very hard to read (tiny print and on colored paper)...I scanned them onto my machine - chose "Select All" - tried to use the "Text" tool to increase the size from 12pi to 24pi - I saved the file - reopened the saved file and the font size is still 12pi....it prints out as small as the original.

Not much experience in this field and am looking for some help...ie...links/advice on how to do this....thanks.
 

A:Gimp Q about enlarging text on a scanned file...

A regular scan is just a photo of the text. You can’t edit it.

Your scanner probably came with OCR software that converts a scan to text. The normal process would be to scan the text with the OCR and open it in Word. Edit it to make sure there aren’t any errors – you often get errors with small print on a colored background unless you use the advanced driver on the scanner and clean it up.

Once you get the text the way you want it, copy it to the clipboard. Make a background you like in Gimp and paste the text with the text tool in using any font and size you want.
 

Read other 1 answers
RELEVANCY SCORE 96

I need help importing text database (for mailing lists) from ACT 4.0 to Excel 2000. However, I do not have ACT application on my computer, and am not able to work from the other (second) computer - person is using it all the time. Could someone help me with this, step by step somewhat. Should the person I'm doing this for save ACT file: on CD; could they email it to me, also?

Thanks for any help.
Danane
 

A:ACT 4.0 to excel 2000 -can i import text database?

Hi, and welcome to the TSG forum

can they export as a csv file (comma seperated)
then its simple
you just open it in excel.
 

Read other 3 answers
RELEVANCY SCORE 95.2

I have an excel file with a column with values like 100, 200, 500, 500-02, and 500-04.
Access wants the column to be a number because 500-02 is not one of the first records.

If I use the acImport or acLink I get the same results. Which is an error importing (I get all the data just not the text values in the column) or a null value in the link when view from Access (even though you can open the spreadsheet with excel and see the true data). If I use the import Wizard and change the Field to text it that data is fine.

I also tried acImporting to an existing table with the field set a text but it changes it back to numeric and screws up.

I have a vision impared user and I need a button click to get this data into access.

Thanks for reading my post.
 

A:Solved: ACESS: import excel field as text

Read other 7 answers
RELEVANCY SCORE 94

Hi,

Does anyone know how to change the text import wizard default from tab to semicolon? TI is not hard to choose but some of our end-users are having difficulty. I thought if I changed the default it would help.

Thanks!
 

A:Change Delimter Default in Excel Text Import Wizard

Read other 7 answers
RELEVANCY SCORE 93.6

I would like to import a text file in a certain workbook, in a certain tab. When I open a text document in excel it always opens a new workbook. Is there a way that I can open the same .txt file and have it stay in the Workbook and tab I am currently in?

I would like to automate a process where several .txt documents are imported into the same file, but even running the macro below causes it to open a new workbook.

Any Thoughts?
Thanks,
Joe

Sub Macro1()

Workbooks.OpenText Filename:= _
"C:\Program Files\PTI\MUST 9.1\Program\systlist.lis", Origin:=437, _
StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=True, Tab:=True, Semicolon:=False, Comma:=False, _
Space:=True, Other:=False, FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3 _
, 1), Array(4, 1), Array(5, 1), Array(6, 1), Array(7, 1), Array(8, 1)), _
TrailingMinusNumbers:=True
End Sub
 

A:Import a text file to a certain tab.

To open a text document in the same workbook, make sure the tab you want the text imported into is active. If you are using Excel 2003, use the Import Data command (Get External Data submenu on the Data menu), instead of the Open command that it seems like you have been using. if you are using Excel 2007, click the Data Tab on the ribbon and choose From Text.

As to batch importing, I have not yet figured out how to make this work in the active document, but if you want a macro that allows you to select which files you want to import, and then it places the data from those files onto the separate worksheets in a new workbook, you can use the following code:
Code:
Sub CombineTextFiles()
Dim FilesToOpen
Dim x As Integer
Dim wkbAll As Workbook
Dim wkbTemp As Workbook
Dim sDelimiter As String

On Error GoTo ErrHandler
Application.ScreenUpdating = False

sDelimiter = "|"

FilesToOpen = Application.GetOpenFilename _
(FileFilter:="Text Files (*.txt), *.txt", _
MultiSelect:=True, Title:="Text Files to Open")

If TypeName(FilesToOpen) = "Boolean" Then
MsgBox "No Files were selected"
GoTo ExitHandler
End If

x = 1
Set wkbTemp = Workbooks.Open(Filename:=FilesToOpen(x))
wkbTemp.Sheets(1).Copy
Set wkbAll = ActiveWorkbook
wkbTemp.Close (False)
wkbAll.Worksheets(x).Columns("A:A").TextToColumns _
Destination:=Range("A1")... Read more

Read other 1 answers
RELEVANCY SCORE 93.2

Help Request: formula or macro to Import all text files (tab seperated text file) in one worksheet
(NOT as seperate sheets in one work book). [Excel 2013]

Thanks in advance
 

A:Solved: Excel: How to import multiple text files in single worksheet

Read other 11 answers
RELEVANCY SCORE 93.2

Hi,

Referring to the post with subject line "Solved: Excel: How to import multiple text files in single worksheet", which is already in solved state.
I had a doubt and so i have opened a new thread for this.
I have downloaded the first sheet attached in the post mentioned above and I have changed the file names in the sheet2. But of no result.
Here I just wanted to know the procedure of how to use this to import the data from text files.
Please help me here. Early reply is highly appreciated.
Thanks in advance for the help.

BR
Nagasayana reddy J
 

A:Solved: Excel: How to import multiple text files in single worksheet

Read other 11 answers
RELEVANCY SCORE 91.6

Hi,
I'm using Access 2010 and wish to import a tab delimited text file containing the following data:

Mobile Called Known ChargeGroup Date Time Duration TimeBand Cost Count
01234567890 10987654321 654321 Mobile to Mobile Orange 29/10/2012 13:11 00:00:05 Daytime 0.020 1
01234567890 10987654321 654321 Mobile to Mobile Orange 29/10/2012 13:13 00:00:02 Daytime 0.010 1
01234567890 10987654321 654321 Mobile to Mobile Orange 29/10/2012 13:14 00:00:01 Daytime 0.010 1
01234567890 10987654320 654320 Mobile to Mobile 3 29/10/2012 13:15 00:06:17 Daytime 1.010 1
01234567890 10987654321 654321 Mobile to Mobile Orange 29/10/2012 13:21 00:00:04 Daytime 0.020 1

To import I'm selecting External Data> Text file and working through the Wizard.

When it completes with an error saying not all data could be imprted. The log table that is created has the following:

Error Field Row
Type Conversion Failure Mobile 1
Type Conversion Failure Called 1
Type Conversion Failure Mobile 2
Type Conversion Failure Called 2
Type Conversion Failure Mobile 3
Type Conversion Failure Called 3
Type Conversion Failure Mobile 4
Type Conversion Failure Called 4
Type Conversion Failure Mobile 5
Type Conversion Failure Called 5

I have done this many times before but it was always with Office 2003. Is it possible something has changed that I am unaware of?
Any advice on how I can get around this? All other fields appear to import fine.
Cheers

Paul
 

A:Access - Import From Tab Delimited Text File

The most likely cause of the problem is with the way that Access handles importing the field types, it takes the first record and applies whatever type of value it finds to the field type in the Import Table, which means that when it finds a Number in the first line it assumes the data is going to be numbers. If however some records have text in them you get a type conversion error.
You should be able to overcome this by importing in to a Table with all the fields set to Text and then correcting the data using the error list before setting the field types to the correct one.
Alternatively if you can open the text file you could make the changes to that prior to importing.
 

Read other 1 answers
RELEVANCY SCORE 91.6

I have 250 text files. Now, i have to put them in cells, like text file no.1 goes to E2 , Text file no 2 content goes to E3. How can i do this?

Thanks
 

A:import 250 text file's content to 250 cells

Read other 16 answers
RELEVANCY SCORE 89.2

Text box border macro based on if text box contains data
Hi i have been trying to create some worksheet code so that for a particular sheet if a textbox is blank the border does not show, but if this contains data the border does show. I have the below code, this works if the textbox contains no data but has a border, the code removes the border. However if the text box contains data but has no border the code doesnt draw the border. I am very new to vb so any help gratefully received.

code is:

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)

Sheets("LRCR by division-open").Select

Shapes("Text Box 1").Select

If TextBox1 = "" Then

Selection.ShapeRange.Fill.Visible = msoTrue

Selection.ShapeRange.Fill.Solid

Selection.ShapeRange.Fill.ForeColor.SchemeColor = 65

Selection.ShapeRange.Fill.Transparency = 0#

Selection.ShapeRange.Line.Weight = 0.75

Selection.ShapeRange.Line.DashStyle = msoLineSolid

Selection.ShapeRange.Line.Style = msoLineSingle

Selection.ShapeRange.Line.Transparency = 0#

Selection.ShapeRange.Line.Visible = msoFalse

Else

Selection.ShapeRange.Fill.Visible = msoFalse

Selection.ShapeRange.Fill.Solid

Selection.ShapeRange.Fill.Transparency = 0#

Selection.ShapeRange.Line.Weight = 0.75

Selection.ShapeRange.Line.DashStyle = msoLineSolid

Selection.ShapeRange.Line.Style = msoLineSingle

Selection.ShapeRange.Line.Transparency = 0#

Selection.ShapeRange.Line.Visible = msoTrue

Selection.ShapeRange.Line.ForeColor... Read more

A:Solved: Text box border macro based on if text box contains data

Read other 13 answers
RELEVANCY SCORE 88.8

Afternoon,

I'm having trouble extracting text from the middle of a text string using Excel.

I've been searching around and there are a few ways this can be done however most really on using a function to search for the text after a specific letter or seperator.
For example singling out the middle initial of a name:

Jeffery J. Skilling
John D Doe

In Column B the First Name will be extracted using the following formula
=LEFT(A2,SEARCH(" ",A2,1)-1)

in Column C the Middle Initial will be extracted. for middle init use this formula
MID(A2,SEARCH(" ",A2,1)+1,1)
My problem is that i can't single out anything to search by to be able to define what needs to be extracted.

Below is a list containing some of the items from my list. As you can see they differ in number of characters and have multiple dashes "-". What formula/process can i use to extract the bold numbers from each of the text strings. I have about 27000 lines to process!

200-CP-57535-B
150-CL-3871-S
200-DMW-57135-B3
250-CL-57133-B3
80-SW-18363-X1
80-DO-57101-B

Once again your help is always greatly appreciated!
 

A:Solved: Excel: Extract text from the middle of a text string - Difficult

"multiple dashes": agreed, but in your sample all items have the same number of multiple dashes -- 3.

If that's a given, just use Data > Text to Columns with "-" as delimiter. Then delete fields 1, 2 & 4 from the results since it seems that "section" 3 is always the bold stuff.

HTH, if not post back.
 

Read other 3 answers
RELEVANCY SCORE 88.4

Many times in the past when I would type plain text into cells of an Excel spreadhseet, I noticed that at point, the contents of a cell would turn into sharp signs (i.e. ####################). I did not know what triggered this, but I did notice that if I change the cell type from Text to General, the cell's text would come back to normal.

Today I had this happened again, and I was determined to find out what caused it. As it turns out, if you have a Text-formatted type cell and you type more than 255 characters in it, all the cell's contents will turn into sharp signs. In order to revert to the text you must either change the cell's format to General or truncate the text manually to a maximum of 255 characters.

The problem with formatting cells as General in a text-only spreadsheet is that you cannot use characters that make Excel think you are typing a formula; that is, you cannot use hyphens or "keywords" such as "not", etc, without prefixing them with a '. This is why I normally format all cells as Text when I know I will only type text in a certain spreadsheet.

Has anyone else noticed this, and is there a solution to have more than 255 characters in a cell without having to change its type to General? Thanks for any help.
 

A:Excel: Text in Text-formatted cells changes to ### after the 255th character

You might want to read this:
http://office.microsoft.com/en-us/excel/HP051992911033.aspx
- in general, 1024 characters is the maximum allowable in a cell, but, as you have noticed, at 255 characters they are no longer displayed in the cell normally, but you can enter 32,767 characters in total, but after 255 characters they can only be read in the formula bar.
Also, if your cell only contains numeric data, then changing the format to General will leave you with information using scientific notation.
Alas, spreadsheets are spreadsheets and not word processors.
 

Read other 1 answers
RELEVANCY SCORE 88

I have used Eudora for many years and I'm now switching to Outlook 2003. I have about 200 addresses in Eudora and it has no export option. I have managed to get all the names and addresses into a comma delimited file by doing a manual search and replace. Here's the format:

FirstName,,LastName,,[email protected]

I did all of this on the assumption Outlook had a way to import a comma delimited text file into its address book. But, alas, I don't see any way to do it.

Anyone have any suggestions?

I don't mind abandoning this method for another if need be.
 

A:Import Comma-delimited Text File into Outlook 2003 Address Book?

I was just looking at a site for making a backup of Eudora's Address Book.
http://email.about.com/cs/eudoratips/qt/et111702.htm

Try Exporting the Contacts folder in Outlook, as a .csv file, first.
Then add the contacts from the Eudora Address Book to the .csv file and Import the .csv file back into the Contacts folder in Outlook
 

Read other 2 answers
RELEVANCY SCORE 86

I receive data files in ASCI text. I want to open them in Excel or in Access but I do not want to spend 2 days counting spaces. Sometimes, I do not even have a clearly delineated file format to help me break it out.
Any tips?
 

A:Opening ASCI text data files in Excel or Access

None that I know of without you having to do all the leg work. What is the source of the text file? As in where is it coming from, what program does it originate in?

No way of having them save it into a format that Excel or Access can import?
 

Read other 2 answers
RELEVANCY SCORE 85.6

Hi.

I have a userform which reads from a text file stored on a network device, and displays the text in a textbox.

A suggestion has been made by a colleague who wants to be able to perform a search on this textbox to find certain keywords. No other suggestion has been made, and I am looking into whether this is possible?

Is there anyway this can be implemented?

Any help would be appreciated.

Kind Regards

Lightingman2003
 

A:Excel 2003 - VBA Search through text within a text box

Read other 6 answers
RELEVANCY SCORE 85.6

Hi guys, I have a slight problem after my first data scraping session.

Basically I have around 500k of lines and around 50k "www.domain.com/username" urls that are in this text file. However the only part I need is the url and everything else is redundant. The URL is dynamic so it's different username everytime as well as on a random line rather then continuous every 5 lines or so.

Is there a software out there or maybe a notepad++/sublime2 algorythim that takes out all the data or simply extracts the data I want?

Here is what it looks like:


Code:
http://www.youtube.com/watch?v=RiVKDn5kyfo,,,Landon Austin - Armor - Official Music Video Download on iTunes!! - <a href="http://goo.gl/aaIY8E" target="_blank" title="http://goo.gl/aaIY8E" rel="nofollow" dir="ltr" class="yt-uix-redirect-link">http://goo.gl/aaIY8E</a> Download on Amazon!,,
http://www.youtube.com/watch?v=z91KJ2I7j2s,,,Download on iTunes ? For more information ?? smtown hompage : <a href="http://www.smtown.com" target="_blank" title="http://www.smtown.com" rel="nofollow" dir="ltr" class="yt-uix-redirect-link">http://www.smtown.com</a> ?? smtown EXO-K*...,,
http://www.youtube.com/watch?v=52oJrdLhXlE,,,Watch the official music video by Kerbera for their hit single &quot;Counterpoints For more information on Kerbera check them out on*.... Read more

Read other answers
RELEVANCY SCORE 84.4

Hi,

I have 30 different files in the same path, but the name of the each file should be different, how i can combine all the files data into a single text file.

If there is any macro will help me solve this.

Thanks in advance!!!
 

A:Solved: Combining 30 text files into single text file

Read other 16 answers
RELEVANCY SCORE 84.4

I want to extract data that will be stored in Thunderbird emails
These emails I have now found out are in Mbox format (I think that's the name!) - which is 'nearly' a pure text file format (from what I've read)

I want to go through this file and extract data from emails
The emails will be of a specific fixed format, like:

Name: Joe Bloggs
Email: [email protected]
Address: 1 Road
London
E1 1AA

Order:

etc.

The address field above and the order field will vary, but the format will remain the same

What language can I use to extract the data? (That would be the easiest!)

I've got Windows Vista - thought I'd mention this

Thanks
OM
 

A:What do I need to go through a text file and extract data?

Read other 10 answers
RELEVANCY SCORE 84.4

Hello Everyone,

This is my first post on this site. I am also working on my first macro and it is turning out to be quite complicated but the mere idea of it working is enough to keep me at it.

In short, I want to use an excel macro to read a text file for a specific line of text, and then write data to the text file on the line before. In other words, rather than the data being added to the end of the file it's added to a particular section of the file after the existing data of that section.

Is this possible? Does anyone have example code for this? I have searched online and tried another forum and no luck so far. I appreciate any tips or sample code, thankyou!!
 

A:Inserting Data in a Text File

Read other 8 answers
RELEVANCY SCORE 83.6

I created this batch file to log certain users logins. It creates a text file to log in, but doesn't populate any of the data to it. Could someone please take a look at it and see what I did wrong. I'm new to writing batch files.

Thanks in advance. Here is the code.

@echo off
set target=JDoe
if %username% == target echo %username% %date% %time% %computername% >> c:\logfile.txt
 

A:Solved: Batch file creates text file but does not populate data to it

target is a variable. You have to surrournd it with %% like any other variable.
Code:

C:\>set target=Squashman

C:\>if %username% == %target% echo %username% %date% %time% %computername% >> c:
\logfile.txt

C:\>type logfile.txt
Squashman Fri 05/23/2008 10:34:14.74 BUMBLE-BEE

C:\>

 

Read other 3 answers
RELEVANCY SCORE 83.6

Greetings! I've searched everywhere for the answer to this issue. It must be common, but I can't find it anywhere. I'm using MS Word 2007, but the problem was the same in 2003. I sometimes get a text box that is behind regular text. I need to move it. One normally just selects a text box and drags, or cut and paste, it where one wants. However, when it is behind text, it can't be selected. I have found no way to select normal text and "send it behind."

How do I get to this text box that is behind my regular text? I've been told to "move the regular text out of the way, then you will be able to get to your text box." But the text box moves with text!

Thanks,

7nyerik
 

A:Text box stuck behind regular text in MS Word 2003 and 2007, Can't select text box.

You can't post a link to your computer to post an image. We cannot access your computer. Upload the png image as an attachment please. To do that, scroll down to "Manage Attachments" then click on "Browse" to locate the file on your computer then "open" it and then click on "Upload" and submit your reply.
 

Read other 1 answers
RELEVANCY SCORE 83.2

Hi,

I've a question with Excel and appreciate all help given.

Question:

How do I convert an 100-row Excel 2003 Worksheet ( see attached Sample1.xls) to a text file where each column is separated by a new line (see attached Sample2.txt) ?

Thanks for your reply!
 

A:Convert excel to text file

I can't think of a simple single step solution but this two step process should do the trick ...

Save the Excel file as a "Text (Tab delimited) (*.txt)" file.

Open the text file in MS-Word (or other editor that allows find and replace of special characters in an entire document).

Find and replace all of the Tabs with Line Breaks.
 

Read other 1 answers
RELEVANCY SCORE 83.2

When trying to preview an Excel 2002 document using the Preview option in MS Word 2002 (File --Open and then Preview under Views) I am getting this warning "This file needs to be opened by the Microsoft Excel worksheet text converter, which may pose a security risk if the file you are opening is a malicious file. Choose yes to open this file only if you are sure it is from a trusted source."
I can click "Yes" and the spreadsheet will view without further issue. This is a fairly new warning--we have been viewing files this way for years. Is there a way to stop this from coming up everytime we want to view an Excel file?
I have tried a 'fix' I found on the MS website, but it didn't work.
1. Quit Microsoft Word
2. Click Start, click Run, type regedit, and then click ok.
3. Locate and then click to select the following registry key:
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Word\Options
4. After you select the key that is specified in step 3, point to New on the Edit menu, and then click DWORD Value.
5. Type DoNotConfirmConverterSecurity, and then press Enter.
6. Right-click DoNotConfirmConverterSecurity, and then click Modify.
7. In the Value data box, type 1, and then click OK.
8. On the File menu, click Exit to quit Registry Editor.

Thanks,
 

A:File needs MS Excel text converter

Go to this site:
http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=830807&kbln=en-us
and download the hotfix. This should supply you with a file that will install and take care of your problem.
 

Read other 2 answers
RELEVANCY SCORE 83.2

Hi all,

I'm having a bit of a problem in Excell. Whenever I save an excel file as text, it places quotation marks arrond any cell which contains a comma.

Has anyone ever encountered this or know how to resolve it?

Thanks
 

A:Converting Excel to text file

Read other 12 answers
RELEVANCY SCORE 83.2

hey,
i need to copy the text from various textboxes to a new .txt file in Visual Basic Studio Pro 6.0

is someone able to help me out here? it's basically going to be something where people can fill out a form, then saves their data as a .txt file so that i can access it at will... this is sorta urgent... but yea.

also, if the name of the txt file could be their First and Last name...

something tells me this could take LINES of code...

thanks in advance.
 

A:Copying data from various text boxes to a .txt file

Did you get this sorted yet?

Regards,
Rollin
 

Read other 2 answers
RELEVANCY SCORE 83.2

Dear friends, I am not a programmer by any chance and in a situation where I need some immediate help. I am grateful for all taking the time to read and respond.

I have a bunch of text in a text file and every so often there are 4 letter words occuring in all uppercase. I want to extract these 4 letter words and output them into an excel or csv file (which I can import in excel). I will list certain occurrences so you get an idea.

%%ABCD%%%%
&FOKP blablabla
bla bla cbdfjc sjdkjscxj SDGF cnikdjnidbnv
bkabkabla ABCDEwhatever

I want to extract ABCD, FOKP and SDGF here, and not ABCDE. The % sign is actually that sign"%". Some places this changes to other characters such as # or $ or @; but I am interested in the 4 letters occurring together and ONLY 4 letters, they occur all in caps and/or followed by spaces and/or characters and/or other text. If in any place there is a text such as &&ABCDEblabla, then I want it to ignore this info as I am only interested in 4 uppercase letters occuring together and no more or no less.

If I am confusing you then please let me know and I can try to explain more. I am in very urgent need of this and have tried everyone at my university, but no help. I am very grateful for your time and hope you can provide a script or lead me in the right direction. Thanks a million again!
 

A:batch file for text data extraction

Not something that can easily be done in pure batch. You would be better off doing this with a utility or programming language that has a more robust regular expression capability. I am going to alert someone to look at this thread that will have a better idea if this can be done with a hybrid batch and jscript solution. That will be as close as it gets without using a 3rd party utility or another programming language.
 

Read other 3 answers
RELEVANCY SCORE 83.2

I am writing a pretty simple program that requests an integer from 1 to 12 to be entered in a text box and then is suppose to show the results in a list box. The results should be the gifts for that day along with that day's cost. The data can only be strictly imported from the text file and the code has to process it. I am really stumped on this practice problem!? I would be thankful for any tips!



Say you put "3" in the textbox, the result in the listbox should be:

The gifts for day 3 are
1 partidge in a pear tree
2 turtle doves
3 french hens
Cost: $213.00
Total cost for the twelve days: $15,748.72

Here is the text file I am suppose to import the data from:

(TwelveDays.Text)
partridge in a pear tree
140.00
turtle dove
29.00
French hen
5.00
calling bird
79.00
gold ring
75.00
geese-a-laying
25.00
swan-a-swimming
500.00
maid-a-milking
5.15
lady dancing
446.58
lord-a-leaping
377.06
piper piping
146.78
drummer drumming
145.76

This is what I have so far, I am stuck on this practice problem:

Private Sub btnEnter_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnEnter.Click

Dim Christmas As System.IO.StreamReader
Dim item As String
Dim price As String
Dim days As Double

Christmas = System.IO.File.OpenText("twelvedays.txt")

days = txtDay.Text

Do Until Christmas.Peek <> -1

item = Christmas.ReadLine
price = Christmas.ReadLine

Loop
Christmas.Close()

End Sub
 

A:VB help! How do I get the desired results from data in a text file???

Instead of a do until loop, use a for/next loop where the for is -
For counter = 1 to days
item = Christmas.ReadLine
price = Christmas.ReadLine
Totalprice = Totalprice + price
Next counter
Counter and Totalprice will need to be dimensioned as Integer and Double.
 

Read other 1 answers
RELEVANCY SCORE 83.2

I need convert/save Excel files into the ASCII comma delimited text files. It needs to be in this format in order to upload healthcare data to the CDC (NHSN).

Thank you.
 

A:How to convert/save an Excel file to ASCII comma delimited text file

File - Save As. Change Save as type option at the bottom...
 

Read other 3 answers
RELEVANCY SCORE 82.8

Hi Tech fundies, I am not one! (57 oldie.lol)
I am on Vista home 32 bit, upgraded to win 7 Prof 32 bit and have a HP all in one 5610. All works well except I cannot scan documents in text, no options, just image (tif, jpg, etc).
I am doing home study and am desperate to resolve the problem.

Can someone pleaseeee tell me what OCR or software I can overcome this with?
Hp info is mine dump of useless help and I am now 700 megabites poorer on a 2 gig contract. On bended knee I thank you to help me resolve this.

Pensioner and not too bright,
McRae

A:scanned image to text!!!

You will need OCR software to do it. Optical character recognition.

Read other 6 answers
RELEVANCY SCORE 82.8

1st Post! Hi, I have Windows XP Pro & a Lexmark ink cartridge Printer, This just started yesterday. When I scan a Photo or Text, everything looks perfect, so I save it to My Desktop as a Jpeg photo. When I open it, there is no photo, but a pile of, it looks to me like Egyptian writing, a bunch of Code that you would see on the Tombs? Thank You!

A:Scanned Jpeg or text

How are you opening the the image, what program does it open in?

Read other 10 answers
RELEVANCY SCORE 82.8

Hi, I didn't know which forum to post this question so if you would like to move it to the appropriate one, please do so.

My dilemma. A website I am using doesn't accept any format of document unless it's in a word document or text. So, I scanned both the word document and a dmv printout (not word) & tried to save it in text format. However, the scan only uses tiff, jpeg, bit & bng (?). Can anyone help me figure out how to combine both a word document & a dmv printout into one format - text?

I have a PC, Windows 7. I have a HP Laserjet 3390.

Thanks.
 

A:Solved: scanned doc to text

Read other 7 answers
RELEVANCY SCORE 82.8

I have scanned a document and want to type some information onto the document and do not know how to do so. Can you help me out?

A:Text onto scanned image

did you scanned a text document that you want to edit or is it a picture that you want to put words on top of?

If a text document, you need to use ocr software when you scan. If a picture, you need a graphic program in order to do it. If you provide more info, maybe we can be more specific.

Read other 1 answers
RELEVANCY SCORE 82.8

Is there a program that will convert scanned text into a word processing format? I found one I think is what would work, but it was $129. I'm just working with recipes and I don't want to pay that much if I don't have to. Also, I'm not sure that is the program I want. Thanks for help.
 

A:Scanned text conversion

Do you have M$ Office ???
 

Read other 2 answers
RELEVANCY SCORE 82.8

Help!

I created a table using Excel, and from that table I created a line chart using the Chart Wizard.

After the chart was complete, I then added data using the drawing tools "add text icon."

When I want to included the data table when printing, the text that I added prints fine.

Now here is where the problem occurs. if I just select the chart, the text disappears, and if I do a print preview or print, the text doesn't show up. The text that I added is behind the chart in a cell. I tried to bring it forward but that doesn't work.

What am I doing wrong?

If I create the table in Power Point, and then add the text, everything prints fine. I don't understand why it works in Power Point and not in Excel.

Thank you for your help.
 

A:Excel-Printing Text that was added to a Chart using the Drawing Tools "Text Icon"

When you select a chart in Excel, that becomes the print range. I think you'll be better off copying the chart to it's own worksheet and resizing to desired size...and of course, carry the text box(es) along with it.
 

Read other 1 answers
RELEVANCY SCORE 82.8

Hi,

I have 2 text files. I want to replace the characters in file 1 based on file 2 string. From position 16 (i can set this as a variable value Postion start) to character 96 (which is also a variable for position End).

Eg: File 1 data

This is a test. Line 1 has header data. Header Line 1. Header Line 2.
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Trailer Line starts. Trailer Line Ends.

Eg: File 2 data

WHAT IS A TEST. Change this line since there that the header line is X.
YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY
Trailer line starts. Trailer Line Ends.

After program execution, File 1 data should look like (only characters 16-96 in the file should be changed like File 2):

This is a test. Change this line since there that the header line is X.
YYYYYYYYYYYYYYYYYYYYYYYYXXXXXXXXXXXXXXXXXXXXXXXXXX
Trailer Line starts. Trailer Line Ends.

Is this possible using a BATCH program? please help me...
 

A:Replacing data in a text file reading from other file

Read other 6 answers
RELEVANCY SCORE 82.4

Excel is my weakest area of office programs so I was wondering if anyone can tell me if this is possible and possibly offer any advice on how to implement it.

Problem
I have a spreadsheet with a list of names and dates and what that person is doing on each day. I also have a text file of whenever each person is away, which I export from a calendar. What I want to do is have excel read the text file and write to the correct cell based on what the text file says.

Example text file
Tom - Holiday 13/07/2010 14/07/2010
Harry out 14/08/2010 16/08/2010

Attached is an example spreadsheet.

So based on this text file I would want to fill in cell C3 with "Holiday" (the second date is the first return date) and cell D5 and E5 with "out"

Is this possible to do?
 

A:excel: Read from a text file and put in a cell

Read other 16 answers
RELEVANCY SCORE 82.4

Hi,

I'm hoping someone with a fair understanding of Excel and VBA can give me a hand here

I don't really use Excel much, even less the VBA side of things (more web type things).

Here is the problem, I receive a file of tabulated data in Word format which I need in Excel, with the data in the correct cells. Currently someone is transcribing this manually which is taking about a week every month

It is a fixed file format (columns always start in the same place) so can be saved as a txt file, but being fixed format there is no delimiter so Excel dosen't know what to do with it and just sticks the whole thing in cell A,1.

I have read that there is a funtion workbooks.opentext which might be able to help but i'm unsure of the parameters and how to implement this

I'm using Excel 2000 with the built-in VBA 6 (I think).

Any help is gratefully received
 

A:Excel Macro to Read in Text File - Help R

Read other 9 answers
RELEVANCY SCORE 82.4

Hello. I hope anyone can help me with my little problem. I been trying to do this for two days, without sucess.

My problem:
I have a problem with a part of my macro:

I have one long row in my excel sheet I would like to copy into a text.file. And at the same time you should be able to save the text.file wherever you want on your computer. I believe this shouldn't be to difficult, but I haven't managed. Tried to use CreateTextFile method combined with GetSaveAsFilename method...

Then later I need a new macro: This should ask where to find the text.file. You choose the location and the macro copies the data from the text.file into the same row in the excel sheet as it was pick from. And then another macro will use this row to some other stuff. Is this possible and how?

Might sounds strange to do it this way, but the clue is, is that my excel sheet is supposed to be on a cd, and not be save into the computer, only the text.file will be saved (too save space on the computer)

Would be really greatful for any tips that could help me!
Have a good day!!

Bjorn
 

A:Macro question: Get one row from excel to a text.file

You really should post some sample data to your next post so that we can see exactly what you are talking about. If possible, post a sample Excel workbook with data and the corresonding text file that should be created. Writing to a text file shouldn't be too difficult. When you say text file are you referring to a true .TXT file or another format such as .DOC

Rollin
 

Read other 3 answers
RELEVANCY SCORE 82.4

I'm currently looking for a new job and have set up some criteria on a job web site called jobserve.
the jobs they have a very good, however, in order to obtain all the jobs the search criteria is very small and so i get about 1100 jobs per email and i have 6 emails with different criteria.
So my problem is I would like to put a text file which is formated as below into a Db or Excel List

the Skills section does have varible lines but seems to be to a maimumn 8 lines - if there is less text then less lines

I once managed to get a text file like this into a Db but that was using DCL on a VMS system.

I would thne be able to quickly - sort by RATE: and eliminate a few, sort by location: and eliminate some more - sort by Position: and eliminate more

then scroll through what I suspect will be a quarter of the results.

as i say I get 6 emails each with between 700 and 1500 jobs per day, and it takes all day - out of which I gues i find between 3 and 12 jobs to apply for.

I know Access and Excel to some extent

anyone able to provide some code to convet text to a DB or excel list and can help thanks

I have removed, names and numbers i the text
--------start

Industry: IT
Type: Permanent
Position: Information And Systems Architect Consultant
Skills: We are looking for Information & Systems Architect Consultants
(preferably with SC Security Clearance) to provide system engineering,
technical project management advice in the specification & procurement
of major ... Read more

A:extract from TEXT file into a DB or Excel List

Read other 16 answers