LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Converting Text files to Excel sheets with specific formatting

Converting Text files to Excel sheets with specific formatting

Hello, I have an issue with .txt files and excel. I have a text file that
is outputted from our mainframe that needs to be converted to an exact excel
format. The text output has tons of information that is not needed and hides
pertinent information within long strings of useless data. The text appears
something like this:

19923098981489098747791230980983097200409040970387 7891023478700011000234

The information that I would need out of the same string would be the
following parts:

19923098981489098747791230980983097\\\\\20040904\\ \\\0970387789102347870001\\\\\\\1000234\\\\\
the 20040904 which is the date and 1000234 which is a test account number.

The text file consists of about 20 to 25 strings like this per line. Each
value needed would have to automatically fill a cell in a named column.

Im not big on excel or data automation so Im here for some guidance please.

Thanks

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to search Excel files based on a specific text string in VBA c Bob Excel Discussion (Misc queries) 1 March 6th 09 05:09 AM
Excel (xls) files spontaneously converting to text files Be-jamin Excel Discussion (Misc queries) 0 November 18th 08 05:31 PM
Converting specific text to numbers then sum Mule Excel Worksheet Functions 8 July 8th 08 10:19 PM
Stop Excel from converting text labels in CSV files to Values Just Want a Label! Excel Discussion (Misc queries) 1 January 11th 05 04:51 PM
Converting text files to Excel - a difficult one sarah W Excel Programming 1 July 23rd 04 02:45 AM


All times are GMT +1. The time now is 02:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"