Path: csiph.com!eeepc.pasdenom.info!news.pasdenom.info!news.dougwise.org!nntpfeed.proxad.net!proxad.net!feeder1-2.proxad.net!74.125.46.80.MISMATCH!postnews.google.com!a8g2000pri.googlegroups.com!not-for-mail From: Johnnyb Newsgroups: comp.databases.ms-sqlserver Subject: Re: Need help creating a view that can edit a string. Date: Thu, 10 Feb 2011 13:51:47 -0800 (PST) Organization: http://groups.google.com Lines: 31 Message-ID: References: NNTP-Posting-Host: 134.253.26.10 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1297374708 2301 127.0.0.1 (10 Feb 2011 21:51:48 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Thu, 10 Feb 2011 21:51:48 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: a8g2000pri.googlegroups.com; posting-host=134.253.26.10; posting-account=kYW--QoAAABRuO6dTOz2QITtLsB-PRVZ User-Agent: G2/1.0 X-HTTP-Via: 1.1 sahp4060.sandia.gov:80 (squid/2.6.STABLE21) X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US) AppleWebKit/534.13 (KHTML, like Gecko) Chrome/9.0.597.94 Safari/534.13,gzip(gfe) Xref: csiph.com comp.databases.ms-sqlserver:1581 On Feb 10, 1:16=A0pm, "Bob Barrows" wrote: > Johnnyb wrote: > > I receive this data in a column in a table: > > $8982162:2$905122:2$905PPA: > > 25$9601217:2$962B19:2$CSRI96:2$WDCOLACK:2$IDRBLACK2:2$IDRRED:2$ > > > I need to make a view that will keep only the entries in that string > > that start with 'WDCO' and omit the rest > > > So I need to edit text in the process of copying the data from the > > table to the view. Hope this makes sense, sorry, I'm a newb. > > > SQL 2008 with patches. > > Please show us exactly what you want to extract from that string in addit= ion > to attempting to describe/explain it. Based on your description, you want > the query/view to return: > WDCOLACK:2$IDRBLACK2:2$IDRRED:2$ > > Is that your intent? > Or do the $ symbols represent delimiters for "entries" in the string, in > which case this is what you want to return: > WDCOLACK:2 Sorry, it is the second answer. I get random entries - like $8982162:2$905122:2$905PPA:25$9601217:2$962B19:2$CSRI96:2$WDCOLACK: 2$IDRBLACK2:2$IDRRED:2$. The $'s are delimiters, and I only want to capture the entires that start with 'WDCO'. Thanks