-
need a piece of pl/sql to do this.....
a varchar2(200) field gets passed in with a bunch of text in it. I need to scan the text
for instances
of a "special char" if one or more is found it needs to replace the following text up
until the next blank space with ++++ as an example. my rough flow of it is below. does
any one know of anything existing like this?
grab text field
look for(1st, 2nd, 3rd, ...) speacial char
if
find 1st special char(example: @ )
and NOT eof (end of varchar2 200)
replace string following it until next blank space(starting at the char
after special char and go to first space and replace with newval)
special char++
else exit
return changed varchar2(200)
thanks in advance
SM
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|