dba123
asked on
Keep first 150 chars of string
If I have an incoming string. How can I use regex or something else to take that string, and keep only the first 150 chars and also exclude any HTML, line-feed, carriage returns, or tabs?
I am working on cleaning some of our descriptons and not sure the best methods to do this and how I'd go about it.
example incoming string:
In any organization, recognizing and understanding the nature and impact of toxic behaviors can provide for the ability to manage the adverse environment and mitigate the potential risks that we often face in the workplace. In Coping with Toxic Managers , Roy Lubit skillfully tackles this complicated topic by presenting the psychological aspects of toxic behaviors in a manner that is understandable and embraceable. This is not one of those 'flavor of the month' pop-psychology books-;it's truly about the science of how and why toxic people think, act, and react. Read this book and you may start looking at the people in your organization quite differently.<br><br><b>You
I am working on cleaning some of our descriptons and not sure the best methods to do this and how I'd go about it.
example incoming string:
In any organization, recognizing and understanding the nature and impact of toxic behaviors can provide for the ability to manage the adverse environment and mitigate the potential risks that we often face in the workplace. In Coping with Toxic Managers , Roy Lubit skillfully tackles this complicated topic by presenting the psychological aspects of toxic behaviors in a manner that is understandable and embraceable. This is not one of those 'flavor of the month' pop-psychology books-;it's truly about the science of how and why toxic people think, act, and react. Read this book and you may start looking at the people in your organization quite differently.<br><br><b>You
ASKER
thanks...but will that strip out any html, line-feeds, carriage returns, and tabs?
ASKER
before, i was using this:
productDescription = productDescription.Substri
productDescription = productDescription.Substri
ASKER
but that wasn't stripping out any html, line-feeds, carriage returns, and tabs
ASKER
Ok, well, in the meantime let me figure out how I can tell it to strip the HTML, line-feeds, carriage returns, and tabs. But I won't close this until I get that fgure out....either on my side or by your help. I'm thinking regeix in the Substring maybe?
ASKER
or regex with substring maybe actually...
ASKER CERTIFIED SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
data = data.substring(1,150);