Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

removing a specific character from a string

I do not have very much knowledge of programming and really need help. I am pulling reports from a field contains a string of text that is limited to 80 characters. If someone enters more than 80 characters, a "+" is added and the text continues. So I want to remove all the "+" signs or every 81st character. I have tried using Replace formulas but have not been able to make it work. field name is rlmain.desc. Need help with the formula and where to place it. Thanks for any help you can provide

like image 645
Rolly Avatar asked Nov 09 '11 12:11

Rolly


1 Answers

Try this:

Replace({rimain.desc},"+","")
like image 156
craig Avatar answered Nov 07 '22 19:11

craig