Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1581 > unrolled thread

Re: Need help creating a view that can edit a string.

Back to article view | Back to comp.databases.ms-sqlserver

This discussion starts older than the indexed window; earlier articles aren't shown. The article labeled Started by below is the oldest one visible, not the original post.

Contents

  Re: Need help creating a view that can edit a string. Johnnyb <john.lutheran@gmail.com> - 2011-02-10 13:51 -0800

#1581 — Re: Need help creating a view that can edit a string.

On Feb 10, 1:16 pm, "Bob Barrows" <reb01...@NOyahooSPAM.com> 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 addition
> 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

[toc] | [standalone]

Back to top | Article view | comp.databases.ms-sqlserver

csiph-web