Data Mining

Hello IrishBull74,

Welcome to the Forum!

Do you want all the call numbers on the sheet? Is the call number always in this format "/CBRE b4957204-1"?

Sincerely,
Leith Ross

The call #'s always start with B and then a 7 digit number, and sometimes followed by a -1 or-2 depending on what vendor it is sent to.
example B1234567-1, and yes I am looking for all the call #'s

Hello IrishBull74,

Do you want to list these on another worksheet in a single column in the same workbook or does this need to be in a separate workbook?

Sincerely,
Leith Ross

I would like to ultimately have them in a separate worksheet in the same workbook along with the data in column A, I have a list of machine #'s in Column A and the call numbers are in the text of the calls in column D. I need the machine numbers in one column and the call #'s in the other column

Hi

In your workbook, have a blank sheet sheet2 ready for the output.

Put the code below into a general module and run on the data sheet.

Please Login or Register  to view this content.

HTH

rylo

Hate to say it but that doesn't work

Hi

Example file time. Show your format, some representative data, and a sheet that shows what the output should be for the given example data.

rylo

Am I missing something here, or why don't you just use the formula "=right(A1,10)" with A1 being the cell address where the data to be mined is located.

Hi

From the OP's post

Please Login or Register  to view this content.

Have to cover the situation where there is no trailing -1 or -2......

rylo

Machine# Start Time End Time Comment
ABCDXXXX 11/9/2008 11/10/2008 11/09/08 20:29 XXX Site reports lights in the canopy are not working B4957204-1

each space is where a cell starts and another ends

I appreciate the help on this.

Hi

Where's the example file?????

rylo

Can you not do a "Reverse Right' lookup for the first space character?

Here ya go.... want the machine # start and end times and just the call # out of the comments section B1234567

Hi

See how the attached goes. Output on sheet2.

rylo

A GODSEND INDEED!

How do I view the macro itself?

Nevermind, found it..