Re: Split Field or Extract a part

From: Rohtash Kapoor (rohtash_nospam_at_sqlmantra.com)
Date: 02/18/04 

Date: Wed, 18 Feb 2004 08:21:10 -0800

Could you give sample data. 

---
Rohtash Kapoor
http://www.sqlmantra.com
"Robert" <anonymous@discussions.microsoft.com> wrote in message
news:82f801c3f638$f650fc90$7d02280a@phx.gbl...
> 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: _ecvt, _gcvt and _fcvt problem
    ... The question is...Do you understand what Robert ... >>>But I have problem about conversion double to string. ... >> problem I strongly recommend taking some time to learn about UNICODE. ... >> please indicate which newsgroup and message). ...
    (microsoft.public.windowsce.embedded.vc)
  • Re: User Define Array Data Type - Subscript out of range
    ... Works just DANDY, Robert! ... strDataType As String ... ' Load Array ...
    (microsoft.public.access.modulesdaovba)
  • RE: C10312e7 Error
    ... > Make sure you are running the netmon trace from the Exchange server and that you capture all traffic. ... > the capture and then include LDAP, SMTP, and TCP/IP. ... >>Thanks for the link Robert. ...
    (microsoft.public.exchange.admin)
  • Re: Digital Passthrough
    ... Robert W ... I wish to capture movie files from VHS to the PC. ... > linked the VHS to the camcorder and camcorder to the PC using Firewire. ...
    (microsoft.public.windowsxp.moviemaker)
  • Re: String.each
    ... On 3/3/07, Robert Klemme wrote: ... >>> each character of a string and then processes it using a block. ... String's enumeration is a bit weird and inconsistent. ... String as array of lines does have it's uses at times but I wonder ...
    (comp.lang.ruby)