Re: Split Field or Extract a part

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

Date: Wed, 18 Feb 2004 09:35:30 -0800

Sample Data:
description
                      
-----------------------------------------------------------
---------------------
3 L,DSP16-24,R-Leaning/Shifted
1-4 Layer BD (1-10 Itms),20 R-Leaning/Shifted
DblStk Pull-Off,R-Leaning/Shifted
Reg Pull-Off,R-BadWood
Reg Pull-Off,R-Leaning/Shifted
Reg Pull-Off,10 R-Leaning/Shifted
Reg Pull-Off,R-Leaning/Shifted
P16-24,R-BadWood
6 L,P25-27,6 R-BadWood
L,P16-24,20 R-BadWood
1-4 Layer BD (11+ Itms),2 R-Leaning/Shifted,4 R-TiHi
1-4 Layer BD (1-10 Itms),2 R-Leaning/Shifted,R-BadWood
1-4 Layer BD (1-10 Itms),R-Leaning/Shifted
1-4 Layer BD (1-10 Itms),6 R-Leaning/Shifted
BANDS,3 L,P16-24,R-BadWood
BANDS,9 L,P16-24,3 R-BadWood
BANDS,2 L,P16-24,6 R-BadWood
1-4 Layer BD (1-10 Itms),4 R-BadWood

>-----Original Message-----
>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: Split Field or Extract a part
    ... CREATE TABLE TuTu ... INSERT INTO TuTu VALUES ('1-4 Layer BD (1-10 Itms),20 R-Leaning/Shifted') ... INSERT INTO TuTu VALUES ('Reg Pull-Off,R-Leaning/Shifted') ... INSERT INTO TuTu VALUES ('6 L,P25-27,6 R-BadWood') ...
    (microsoft.public.sqlserver.mseq)
  • Re: Soil dielectric constand and conductivity for East Texas
    ... because at a deeper layer there is a strata of different resistivity. ... The top layer here Reg is about one to six inches thick of rich ... pastorial soil. ... Measurements of a ground rod at various places on my farm show anything ...
    (rec.radio.amateur.antenna)
  • Re: Extremely Important Announcement
    ... I believe there is a layer of meaning that you have either overlooked or ... > REG wrote: ... Prev by Date: ...
    (rec.music.opera)
  • Re: Extremely Important Announcement
    ... REG wrote: ... > I believe there is a layer of meaning that you have either overlooked or ... Prev by Date: ...
    (rec.music.opera)
  • Re: Extremely Important Announcement
    ... I certainly would call her Juno-esque. ... REG, not a Paycock. ... >> I believe there is a layer of meaning that you have either overlooked or ...
    (rec.music.opera)