alphanumeric strings

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

reporter1

Thread Starter
Joined
Mar 6, 2008
Messages
43
Hi Excel Pros,

I'm no excel wizard and I'm having difficulty separating strings of text and numbers from one cell into separate columns.

Here's an example:

MONSEF,BERNADETTE03/25/910930DMRAAM10-t/f1000150012001730

I'd like the information separated as follows:

MONSEF,BERNADETTE 03/25/91 0930 DMRA AM10-t/f 1000 1500 1200 1730

Each row has different length names, dates, times etc...

Is this even possible to accomplish with a formula?

Dizzy,
reporter1
 
Joined
Jul 28, 2008
Messages
1,899
So you would like to split a string into smaller strings, by finding a series of charactars and splitting at that point ? If this is not what you meant could you elaborate please :D
 

reporter1

Thread Starter
Joined
Mar 6, 2008
Messages
43
Fabez,

Yes, but with some strings being different lengths, I can't do delimited text to columns. Here's another example:

LOPRIORE,JOHN09/27/941200PM10-fss1000173014451945

Should read:

LOPRIORE,JOHN 09/27/94 1200 PM10-FSS 1000 1730 1445 1945

The last four sets of numbers are all made up of 4 characters (1000, 1730, 1445, 1945)

Is there help for me?
 
Joined
Jul 28, 2008
Messages
1,899
Where is the data generated as it would be easier to include a seperator string when it is made. If you have no control over its making then it would be best to use wild cards and generic strings to search and split the main string.
 

reporter1

Thread Starter
Joined
Mar 6, 2008
Messages
43
Fabez,
The PDF file is created by someone else so I can't change the original format. I'm not very familiar with wild cards and generic strings. How would I get each string to separate at points where numbers meet numbers if the number of characters is different? Is the wild card used for numbers that are all the same in length?

Thanks,
reporter1
 

OBP

Joined
Mar 8, 2005
Messages
19,895
Are some of those numbers always the same length?
Like the last 4 for instance?
 

OBP

Joined
Mar 8, 2005
Messages
19,895
Would you want to seperate the Second name from the comma with a space?
 
Joined
Jul 28, 2008
Messages
1,899
Okay then. A wild card is something that can represent anything, like * does in Actionscript, a generic string is a general string like, dd / mm / yy.

LOPRIORE,JOHN09/27/941200PM10-fss1000173014451945

LOPRIORE,JOHN 09/27/94 1200 PM10-FSS 1000 1730 1445 1945

In order to achieve the seperation on this string you would have to follow several steps.

I could either tell you how to do this in Excell or another language if you want :D
 

OBP

Joined
Mar 8, 2005
Messages
19,895
If it can wait until tomorrow and none of the Excel Guys come along I can create you some VBA that should do it.
 

reporter1

Thread Starter
Joined
Mar 6, 2008
Messages
43
I think I'd prefer excel so I can learn something from it in case something similar occurs again in the future. It's no emergency - it can wait until Monday. I'll be leaving here (work) in 20 minutes.

Thanks -
reporter 1
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top