text file processing

I have text files that may have one, or multiple, instances of the following line groupings: PG27FANU1022356 PG2803110701 PG30A0331202412002 2809...

Hi, I want to make a macro to search for repeating blocks of text in a text file. I know how to load the text file to memory but I don't know how to find the repeated text. I've seen examples of searching for text using regular expressions which seems like it might be the way to go, but I...

Hi, I have a very large file of forex data that I wish to use to test trading strategies. I know that normally you'd have all the data you want in the spreadsheet and all the formulae replicated down. But this input file is way too big for that. Plus, I want to be able to design the one...

Hi all, I have a large number of text files containing five tab delimited columns and several hundred rows. I currently have a macro that opens the text file, finds and calculates the required 'results' then pastes these into a new summary sheet. It's currently taking around 1 second per file...

Hello, I'm new to the forums and although I've used excel for quite awhile, I've never actually had a reason or need to use macros for data import or manipulation. At the moment I'm trying to work on a modeling problem which will output the data in the form of a large text file. The data is...

I am working in Excel 2010 with an imported text file drawn from an older program where headers from a print version are repeated for each page - roughly 3000 headers in one of 15 reports I need to aggregate. I have to keep the headers initiially in order to add data from the headers to the...

Hello, I am trying to copy content of a worksheet to a text file. What i want to know is how can i name the text file based on a given string in a particular cell. And the issue is that i do not need the complete cell content I want to drop/trim last 4 characters of the cell. Eg: value in my...

I'd like to import a CSV file with VBA. Some of the columns should be formatted as text (i.e., numbers with leading or trailing zeros such as ZIP codes), others as numbers, some as dates, and others should be skipped. I know the proper data type by looking at the header row name, however, the...

hi, i have a text file and i need to process that. the processsing should be like this. in my file whenever i encounter a string 'record' i should start writing the contents form there to the next occurence of the string 'record' in a seperate text file. this should happen until the end of...