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: 103
Default Parse a txt file and save as csv?

Hello;

I am trying to come up with some vba that will parse a txt file. There are
two files that come with different size delimited strings. I would like to
try to find a generic script that will parse the string lengths according to
their size and then add a comma after the end of the string length. I would
then like to save it into a csv file with line breaks. Can anyone direct me
to an accurate solution.

The string lengths are different, but I don't mind having two separate
scripts to run on the separate files.

Any help or direction would be greatly appreciated.

Thanks

Frank Pytel
 
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
parse from txt file geebee Excel Programming 3 August 19th 08 07:55 PM
Want to use Excel to parse a text file Michael[_44_] Excel Programming 17 October 7th 07 09:51 PM
Parse File Location Mike Excel Worksheet Functions 5 October 3rd 07 04:05 PM
How to parse data in text file sifar Excel Programming 4 October 8th 05 01:50 AM
Parse Text File John[_62_] Excel Programming 5 October 22nd 03 02:50 PM


All times are GMT +1. The time now is 06:34 AM.

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"