troubleshooting Question
DB2: Need to extract specific characters left of delimiter in string
PresidentLincoln
asked on
asked on
I am using Data Studio to write a query for a DB2 AIX database. I have a small issue I'm running into.
I have a column that appears like this:
I need to extract all characters, starting from the "SBN", all the way up to, but not including, the equal sign. The numbers after "SBN" can be of varying length, so I just need the beginning of the string up until the equal sign. What is the easiest way to accomplish this?
I have a column that appears like this:
SBN:123456=1
SBN:1234=0
SBN:12345678=5
I need to extract all characters, starting from the "SBN", all the way up to, but not including, the equal sign. The numbers after "SBN" can be of varying length, so I just need the beginning of the string up until the equal sign. What is the easiest way to accomplish this?
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 3 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.
Our community of experts have been thoroughly vetted for their expertise and industry experience.