View Single Post
  #1   Report Post  
Tom
 
Posts: n/a
Default Need to find the 1st two characters of the 1st two words

Does anyone know how to come up w/ a smart function that will exctract the
first 2 letters of the first 2 words from a string.

For instance, I may have the following data in a column:
Alpha Bravo Zulu Yankee
Delta Kilo
Mike Tango Papa

I'd like to have the 4 characters strung together, such as:
- ALBR
- DEKI
- MITA

Now, the following would be a BIG PLUS!!! Let's say I had a 4th record such
as "Mke Tango Yankee". In this case, I would have MITA twice since the 1st
two words are the same (3rd and 4th record). Is there now a chance to take
the 3rd word for the example "duplicate value"? So, I'd come up with:

- ALBR
- DEKI
- MITA
- MIYA

Thanks,
Tom