Split Field or Extract a part

From: Robert (anonymous_at_discussions.microsoft.com)
Date: 02/18/04 

Date: Wed, 18 Feb 2004 08:05:00 -0800

I have been trying for some time to capture a part of a
string to convert and sum a number accross my result set.
The string looks like this: "abc,1 def,10 R-@@,xyz". I
have been looking for a way to split the field or extract
a part of it specifically "10 R-@@" but the problem lies
in the order not being consistent. Sometimes the part is
second, sometimes it is third and sometimes it ends up at
the end. The only thing that remains constant is the "R-
@" where the @ is some variable sequence of letters. Any
ideas to get me started?

Thanks,

Robert

Relevant Pages

  • Re: Regex Capture problem
    ... "learned" my regex using a freeware utility that had slightly different ... was trying to capture instead of. ... I have used Regex utilities before, so I understand the concepts of text ... Function RESub(str As String, SrchFor As String, ReplWith As String) As String ...
    (microsoft.public.excel.programming)
  • Re: SQL - Capture Specific Text and Copy to New Column/row
    ... The script is: ... Please advise of how I may capture only the date/time data. ... wildcard characters as characters in the string. ... by the Option Compare setting of the module. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Regular Expression Hangs
    ... You wouldn't need a regular expression to ... a single fixed string. ... Those patterns are defined by rules that are expressed in the ... will capture the following: ...
    (microsoft.public.dotnet.languages.csharp)
  • Help with atoi function for a numero program.
    ... a single digit number by adding up the corresponding number to ... sum is 8). ... The res will be sum of ram and spartans value 5+8= 13. ... I am converting the integer to string and so that ...
    (comp.lang.c)
  • Re: Herfried K. Wagner - HELP!
    ... Where did you find the command string ... Private Sub StartRecording() ... mciSimpleSendString("open new type waveaudio alias capture") ...
    (microsoft.public.dotnet.languages.vb)