troubleshooting Question

SQL Server 2008 R2 - Strip most all text but keep specific text . . .

Avatar of kouts1
kouts1Flag for United States of America asked on
Microsoft SQL ServerMicrosoft SQL Server 2008
1 Comment1 Solution237 ViewsLast Modified:
Hi guys,

I have a column with HTML text that I need to remove everything but keep only  "Assigned To:"  and everything after that. Is that possible?
Example data: "Assigned To:" is near the end.
Admit Decision to Inpatient:  VB?  NO Medicine  -  Dutsi BehmTest  Flag  Value    Units    Ref. Range Status   Lab  Address  BEDREQUESTAdmitted To: Black Team CleanBEDREQUESTAssigned To: G6E-111111

Open in new window

I need to end up with:  Assigned To: G6E-111111

Mike Eghtebas
Database and Application Developer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
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 1 Comment.
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