parse

Hello VBA world... well this question is for Excel Function world: I am trying to parse a string and return just the text within a string. The text strings are the same but the ending number variations differ. For example, I have two comparable variables "XXX12" and "XXX2" and I'm trying to...

Hello and thank you for your expertise. Here is my situation. I have approx. 500 text files all residing in one folder. This folder only contains text files. Each text file has approx. 100 rows of data, tab delimited. I would like to import every row from each file into one sheet in...

I have numerous Access generated reports saved as PDFs. Is there any way to parse this to excel? The pdf's themselves are standard flat files, with a few fancy headers. Any suggestions?

Thinking through a problem here and thought I would elicit thoughts from the board. I have a few thousand emails saved as text files. [For the sake of the problem, they are all saved in .txt format]. The issue is that the emails are often chains where the recepient/sender/dates/subject can...

Hello everyone, I have a .csv export file that contains description fields like the following (in A1): <table border="0" cellpadding="0" cellspacing="0" width="383" height="160"><col width="383"><tr height="160"> <td class="xl63" style="height: 120pt; width: 287pt;" width="383"...

Sorry this is a compound problem but I am not sure how to solve each step with a method producing an output compatible with input types for the next piece. I need to parse comma delimited numbers (stored as text) in cells like those in col C below. I then need to look up each of the parsed...

I am trying to search for a value such as A01 (in cell A5) within cell R25 and if A01 is present anywhere in R25 then in cell B5 it will place a 1. R25 might have: A05A01A25A40 Once I can do this I plan on creating a loop to go through range R25-R1000 and have B5 continue to add 1 to the...

OK, any help would be appreciated... I'm trying to take the contents of one cell and parse it out into an array. The cell content looks like: "John; Joe; Bob; Marty" Any ideas how?? Thanks! M

Hello, I could really use some help parsing this data. All of the data is in the same field, and I would like to have each address field (i.e. Address1, City, State, Zip Code) in separate fields. 100 Laketrail Drive , Alpharetta, Georgia, 30022 1001 St Charles Ave , Atlanta, Georgia, 30306...

in one cell I have data such as: d10d100i01d09d07i04 and i am hoping to to add a comma before each letter so that it appears like this: d10,d100,i01,d09,d07,i04 i dont mind if it has to add a comma before the first one either: ,d10,d100,i01,d09,d07,i04 i have a lot of data like this and need...

in one cell I have data such as: d10d100i01d09d07i04 and i am hoping to to add a comma before each letter so that it appears like this: d10,d100,i01,d09,d07,i04 i dont mind if it has to add a comma before the first one either: ,d10,d100,i01,d09,d07,i04 i have a lot of data like this and need...

Hello, I'm working on a project that has data grouped first by one attribute, and then another: There are three tractors using a 335 HP engine, and each of them has their own column. I've been working on a macro to condense those three columns into a single column, with the format as...

Hello, another question. I have a cell that looks like: B217F1C1-FL1-AP1 the B217 stands for building 217, the F1 stands for first floor....any way I can do a function to add those values to seperate cells? So a Floor column that would say "First Floor" and a Building column that would say...

Anyone have any code that can be used to parse an IF statement read from a cell into its 3 parts (condition test, true case, false case)? I'm not really wanting to have to write that from scratch. Any help is greatly appreciated!

Hi, I'm trying to make a macro that does the following: Parses an address inside a cell to the following fields to the right of that cell: First Name Last Name Street City State Zip Country (really I'd like it to do this for ALL cells I've got selected, so it can do multiple addresses at...

I've got a simple sounding problem. I have a list of common name suffixes (e.g. Jr., Ph.d, J.D., etc). I have a long list of full names. I want to search and see if any of the suffixes on my list are in the name. If so, I want to parse the name into part 1 (everything but the suffix) and...

Need assistance on a smart formula (no VBA) that will reverse the order of a list of names - parsing into separate columns. The formula needs to be able to recognize/distinguish that if a comma(s) is present, then the names are listed as last, first middle. If there is a period this means...

I have some code that will parse the FIRST IP address it finds in a string. Could someone help with the code for continuing through the remaining part of the string and parsing out any additional IP addresses it finds and concatenating them with a comma and space (", ")? There are specific...

The code below attempts to parse the worksheet COPY_APR_All_States based upon the state (column "F") by making a new worksheet (named by State, the "holdState" variable) for every state found in column "F" of COPY_APR_All_States, and then adding the respective rows to the new worksheet. I have...

Hi all, I've been using the forums for several days to get answers to my questions but finally came across a dead end. Please help! I'm working with a dataset where there is a whole bunch of text in one cell that I need to parse. There are two delimiters: "~" and ";". Furthermore, there are...