Link to home
Start Free TrialLog in
Avatar of Gus Koutsivitis
Gus KoutsivitisFlag for United States of America

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.
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

thanks!
ASKER CERTIFIED SOLUTION
Avatar of Mike Eghtebas
Mike Eghtebas
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial