DROPWORD – Delete a single word from a string

This function deletes a word from a space delimited string, if it exists.

DROPWORD(<needle>,<haystack>)
Where:
<needle>
The word for which to search.
<haystack>
The string where to search.

If the function finds <needle> as a space delimited word within <haystack>, it returns <haystack> with that word deleted. Otherwise it returns <haystack> unchanged. The command is case sensitive.

If <needle> occurs more than once, only the first occurrence is deleted.