Delete all occurences from string up to a certain character
Posted on 2013-06-16
I need to remove all references from a string that start off with
up to the point of the next ","
if they have "ISNULL" and a plus (+) or minus (-) sign in them.
For example this is part of the string
"FEE FII FO FUM THe packers rule AS ((((isnull([QtyOnhand],(0))+isnull([b_PORecNotCosted],(0)))
+isnull([c_TranRecNotCosted],(0)))-isnull([d_TranShipNotcosted],(0)))-isnull([e_OrdRelNotInv],(0))), But the Vikings don't and never have
This string should look like at the end:
FEE FII FO FUM THe packers rule, But the Vikings don't and never have
Can anyone help?