styles3000 Posted August 7, 2009 Share Posted August 7, 2009 If I have a document that reads...... banco patagonia+60% aig stock+50% optionsxpress+40% colonial bank+40% banco estado+40% aig+40% postal regulatory commissionBreakout michael saldateBreakout jill sobuleBreakout gates of andaron+850% robert manwill+700% legg mason tennis+500% legg mason+300% slaughterhouse What kind of function could I use to look within the document looking for any addition sign "+" and "number"(ie.+850%,+700%,+40%,+500%)and delete them? Link to comment Share on other sites More sharing options...
dantay9 Posted August 7, 2009 Share Posted August 7, 2009 StringRegExpReplace($String, "\+\d+%", "") should work. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now