troubleshooting Question

Oracle procedure logic - string manipulation

Avatar of jknj72
jknj72 asked on
Oracle DatabaseSQL
17 Comments1 Solution724 ViewsLast Modified:
I have a view where I have to do a little string manipulation. I have a text field where I just want to bring back the text in the field after the last pipe | . For instance '~(`|¤|football)~'
I just want to bring back football. There is commonality to the data because they all start with '~( and end with )~'. Also, the data that I need will always be after the last pipe |.
Another example would be '~(`|¤|{link:10098}|Mobile, Alabama,)~' would return
Mobile, Alabama,

Please let me know if you have any questions.

Thanks everyone
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 17 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 17 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros