Gus Koutsivitis
asked on
SQL Server 2008 R2 - Strip most all text but keep specific text . . .
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.
I need to end up with: Assigned To: G6E-111111
thanks!
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
I need to end up with: Assigned To: G6E-111111
thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.