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

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

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

Show all headers | View raw

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

Back to comp.databases.ms-sqlserver | Previous | Next | Find similar | Unroll thread

Thread

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

csiph-web