Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jomeir

    Formula to remove bracketed text

    Thanks for all your suggestions... much appreciated!
  2. jomeir

    Formula to remove bracketed text

    @fishermacse... Your suggestion got me thinking and I have actually got it working in a Pair of formulas, or formula in a formula. One thing i notice it's doing, is leaving a space where the bracketed text was... any ideas how to close that space e.g. "250gsm ," The bracketed text was after...
  3. jomeir

    Formula to remove bracketed text

    Thanks for the suggestion, but i need to remove the text within the bracket also.
  4. jomeir

    Formula to remove bracketed text

    Hello all, I am using the following formula to detect and remove brackets and the text within it however I need it to loop as some fields have more than one instance of bracketed text. The formula is: IF INSTR({EstDescription.Description}, "(") = 0 THEN {EstDescription.Description} ELSE LEFT...

Part and Inventory Search

Back
Top