Re: Returning Partial Strings

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Thu, 31 Jan 2008 14:44:02 -0800, ScottM wrote:

I'm trying to separate a word/string of characters in a text field from the
rest of the field, but the strings are of varying lengths. Is there a way to
extract this? For example, my field contains the following values:

RAST 2006-1 M5
CWALT 2006-AR1 A

How can I extract the "RAST" and the "CWALT" from each?
How can I extract the "2006-1" and the "2006-AR1" from each?

Thanks in advance!

Look up the Split Function in VBA help.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.

Relevant Pages

  • Re: Returning Partial Strings
    ... but the strings are of varying lengths. ... extract this? ... John W. Vinson [MVP] ...
    (microsoft.public.access.queries)
  • Re: Extracting time from strings
    ... to hurt is in trying to determine the shift times in 24 hr format. ... Some rosters are 14 day, others are 28 although all will start on ... extract the employees name, position and section from the first columns. ... strings to extract the times. ...
    (microsoft.public.excel.programming)
  • Re: Extract text plus "n" characters or date on partial match
    ... Maybe starting from the same code I need to extract dates, first, ... extract the "rmd" strings. ... To extract the rmd strings as you write above, ... Dim i As Long ...
    (microsoft.public.excel.programming)
  • Re: Extract specific string
    ... Rick (MVP - Excel) ... Where do you want the extracted strings to go... ... > The string start always with "S" and finished with 8 digits and a VB ... Do the strings you are trying to extract ...
    (microsoft.public.excel.programming)
  • Re: Query on pattern matching
    ... I need to extract few strings from one file and paste it to another file. ... Since i am using spaces as delimiters here, i am facing problems. ...
    (perl.beginners)