Hi,
I am trying to remove specific text from a string using regex. The cell contents contain one or more items separated by commas with "not detected" at the end. I'd like to remove "not detected" to leave just the items listed that can be split by the comma. What I am using:
Regex( Substitute( :"DETAILS"n, "not detected", "" ), "\S*" )
However, this appears to be truncating the list wherever there is a space, so "item A, item B not detected" becomes "item" where I would like to have "item A, item B."
I suppose I can work around it by removing spaces first, but would like to keep in more concise if possible. Is there a modification that would return the list and only remove the "not detected"?
Thank you,
Cass
